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
LVL 10
victornegriAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sirbountyCommented:
http://www.somarsoft.com/ dumpacl may be helpful for you..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
victornegriAuthor Commented:
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.
0
sirbountyCommented:
SecurityExplorer (pricey) may be a more graphical option for you...
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Mathew NewtonWebmasterCommented:
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
0
victornegriAuthor Commented:
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).
0
jmhquestCommented:
You could create a PowerShell script to get a listing of all the folders and their ACLs on a server.

http://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx
0
victornegriAuthor Commented:
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)?
0
jmhquestCommented:
MS has an example to list all the folders on a computer.  Look in the PowerShell script repository.
0
jmhquestCommented:
p.s. getting the ACLs is a WMI call.  Feed the results of the folder list into the wmi call.
0
sirbountyCommented:
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...
0
victornegriAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.