SQL Server Forums - Create a database

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

Create a database

New Topic

Author

Topic

aidmondo
Starting Member

Ghana
23 Posts

Posted - 04/20/2013 : 15:51:16

Create a database to store the details of all users in active directory.

aidmondo

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1853 Posts

Posted - 04/21/2013 : 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

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.