|
I was able to use SHOWACLS and a txt file w/ a list of all servers and drives to script some information gathering, now I need to format the txt file to be a CSV to be usable in Excell....
The TXT file looks like the following....
:\sites\QEHO\Europe CPO\2002\monthend\01jan Everyone Full Control [ALL]
N:\sites\QEHO\Europe CPO\2002\monthend\01jan\CPO Europe BUILTIN\Administrators Full Control [ALL] NT AUTHORITY\SYSTEM Full Control [ALL] QRTP\TSE_HYPERION_IEUR Change [RWXD] QRTP\TSE_HYPERION_ADMIN Change [RWXD]
N:\sites\QEHO\Europe CPO\2002\monthend\01jan\other Everyone Full Control [ALL]
so on and so forth (word wrapping may have occured) but in short what I have is line1 = path line2..x (until blank line is found) are the groups and associated permissions...
What I need to do it parse the file and re-write it to be path,groupname,permission
any tips are appreciated!
|