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 |
aidmondo
Starting Member
23 Posts |
Posted - 2013-04-20 : 15:51:16
|
Create a database to store the details of all users in active directory.aidmondo |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-21 : 02:28:45
|
aidmondo, Assuming you have access to the Active Directory - powershell is very good at extracting the groups and members in Active Directory. You could create a powershell script - run through the Active Directory Tree and insert to the database. These posts don't give you the exact script - but will give you an idea of how to connect to the AD and place in a databasehttp://www.sqlserver-dba.com/2012/02/sql-server-powershell-active-directory-search.htmlhttp://www.sqlserver-dba.com/2011/07/powershell-sql-server-security-audit.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|