Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2008-06-11 : 15:54:12
|
| Hey guys, My team is responsible for providing internal and external auditors with sql server and system level audit information whenever they request, this can happen once a week, ten times in a month, once a month, it doesn't matter... So, to keep us from stop in the middle of our daily routine I'm working on automating some of these requests and having this information available on our SSRS server.I have my hands wrapped around the sql stuff, usually the type of request we receive from auditors at the sql level are:List of users and type of access on server A and database 1Who got access to what between two datesList of service accountsAnd some other stuff...What I'm trying to accomplish now are the system level reports, I need a way to get information from the local users and local groups (members of local groups), such as:List of Local GroupsMembers of Local GroupsShares and who has access to those sharesHas anyone worked on any requests similar to this? What did you end up using? WMI SQL, DOS Commands...? Any suggestions or ideas?---http://www.ssisdude.blogspot.com/ |
|
|
|
|
|
Audit Requests and WMI - or any other ideas