asked on

Folder ACL List to Table

Ultimately, this is what I want: I want to be able to print out a list of what folders a group or user has access to on a specific server and what permissions they have on that folder.

I'm thinking about dumping a list of users and groups into a table in MS Access and then doing some form of ACL query on a server and dumping that info into a table... the problem is, I don't know how to do that.

Anyone out there that can point me in the right direction or provide links?

FYI: Windows 2003 Domain

ASKER CERTIFIED SOLUTION

sirbounty

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

victornegri

ASKER

Have that tool... but you know what, I never noticed that it had command line switches until now. I can probably just create csv files and link them in Access.

Thanks.

Will keep the question open just in case other people have input.

sirbounty

SecurityExplorer (pricey) may be a more graphical option for you...

Mathew Newton

Hi,

I would recommend using a VBScript and WMI to query the servers and load the data into an access database using ADO.

If you need further advice let me know.

Mat

victornegri

ASKER

Mat, If you could point me in the right direction for that I'd appreciate it. I tried doing that before but I couldn't get the recursion to work on large folder structures (which is what I need).

SOLUTION

jmhquest

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

victornegri

ASKER

Been looking into that too (just found it today). :)

Seems like it has good potential. Just hope I can call the script from within Access.

Do you have any good examples I can use to get started with PowerShell (for this particular project)?

jmhquest

MS has an example to list all the folders on a computer. Look in the PowerShell script repository.

jmhquest

p.s. getting the ACLs is a WMI call. Feed the results of the folder list into the wmi call.

sirbounty

Nothing against {http:#18805244} but the author stated that they had already gotten that far on their own and the expert never returned to provide any further guidance on that route...

victornegri

ASKER

I ended up using DumpACL in a batch file with link tables... but I'm learning how to use powershell so maybe in the future, that will be the solution.