Powershell to the rescue!

by Mikeal Email

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

No feedback yet

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)