Here is the issue, at work we have a small/medium sized network with several file servers. Our AS/400 team performs an audit every year of access rights, and gives a report to the various department heads about what each of their employees can access. Now, they want this report for the network shares on the PC side of the network as well. We did have another employee working on this, but he has quit, and apparently he was recording all the share permissions by hand. On top of that, I already know of several mistakes and omissions in his records, so I am very sure I have to start over from scratch.
My boss is willing to pay for software if we can find anything that will allow us to get this data and export it to an excel spreadsheet or access database for the analyst's audit. I also have been looking at the windows 2000 resource kit, and the showacls.exe, perms.exe, and cacls seem to be promising apps, but I would somehow need to get the output into either excel or access. (our analyst says that with my help she could get it from excel to access, so thats why its an either or situation.)
If anyone has ever worked with something like this, or has any suggestions I am in need of some help.
Domain is primarily windows 2000 servers, with 4 windows 2003 servers.
Thank you.
My boss is willing to pay for software if we can find anything that will allow us to get this data and export it to an excel spreadsheet or access database for the analyst's audit. I also have been looking at the windows 2000 resource kit, and the showacls.exe, perms.exe, and cacls seem to be promising apps, but I would somehow need to get the output into either excel or access. (our analyst says that with my help she could get it from excel to access, so thats why its an either or situation.)
If anyone has ever worked with something like this, or has any suggestions I am in need of some help.
Domain is primarily windows 2000 servers, with 4 windows 2003 servers.
Thank you.