Powershell to the rescue!
by Mikeal
Last time I had to do a permission audit of a file server it took an extremely long time. I basically ended up having to type everything into excel by hand while examining the folder properties. This becomes quite annoying when your dealing with hundreds of folders. Windows Powershell introduces a much better way to handle this daunting task.
get-childitem p:\ | get-acl | select-object path,group -expand access | export-csv c:\rawr.csv
Then just import the csv into excel and do a little cleanup via the right and len commands so your paths don't look horrible.
At first you will see:
Microsoft.PowerShell.Core\FileSystem::P:\My folder
Use:
=RIGHT(A1,(LEN(A1)-38))
Which will convert it to P:\My folder
Now add a filter for the everyone permission and go scare your management team by showing them everyone can access there files!
Windows Powershell is available at: http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx
More information on acl-get is available at: here
11/21/08 10:23:16 am, 