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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Create a database

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 database
http://www.sqlserver-dba.com/2012/02/sql-server-powershell-active-directory-search.html
http://www.sqlserver-dba.com/2011/07/powershell-sql-server-security-audit.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -