SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Create a database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aidmondo
Starting Member

Ghana
23 Posts

Posted - 04/20/2013 :  15:51:16  Show Profile  Reply with Quote
Create a database to store the details of all users in active directory.

aidmondo

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 04/21/2013 :  02:28:45  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000