Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Folder ACL List to Table

Posted on 2007-03-27
12
Medium Priority
?
1,197 Views
Last Modified: 2013-11-27
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
0
Comment
Question by:victornegri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 3
  • +1
12 Comments
 
LVL 67

Accepted Solution

by:
sirbounty earned 1200 total points
ID: 18804765
http://www.somarsoft.com/ dumpacl may be helpful for you..
0
 
LVL 10

Author Comment

by:victornegri
ID: 18804884
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
 
LVL 67

Expert Comment

by:sirbounty
ID: 18804947
SecurityExplorer (pricey) may be a more graphical option for you...
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 

Expert Comment

by:pobblebonk
ID: 18805244
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
 
LVL 10

Author Comment

by:victornegri
ID: 18805750
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
 
LVL 4

Assisted Solution

by:jmhquest
jmhquest earned 800 total points
ID: 18805909
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
 
LVL 10

Author Comment

by:victornegri
ID: 18805916
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
 
LVL 4

Expert Comment

by:jmhquest
ID: 18807394
MS has an example to list all the folders on a computer.  Look in the PowerShell script repository.
0
 
LVL 4

Expert Comment

by:jmhquest
ID: 18807400
p.s. getting the ACLs is a WMI call.  Feed the results of the folder list into the wmi call.
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 19009617
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
 
LVL 10

Author Comment

by:victornegri
ID: 19009795
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

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question