Query to compare Active Directory with MS SQL

  • Thread starter Thread starter trixvi
  • Start date Start date
T

trixvi

To compare computersaccounts stored in the antivirus management
database (MS SQL) with the computeraccounts defined in the Active
Directory I need a query. Normally I use MS Access 2002 to compare
tables. How can I connect to the Active Directory so that I can use it
in MS Access as an ordinary table?
 
Actually, ADSI allows you to query the AD using SQL queries. You can use
ADO.net (or just ADO) to select from each and do a compare... You could
also pass to an SPROC and have unmatched dropped to another table.

I used to do this against a SQL database to synch my AS/400 users to AD.
(Populated SQL with a batch script from the 400)
--
Ryan Hanisco
MCSE, MCDBA
Flagship Integration Services

trixvi said:
To compare computersaccounts stored in the antivirus management
database (MS SQL) with the computeraccounts defined in the Active
Directory I need a query. Normally I use MS Access 2002 to compare
tables. How can I connect to the Active Directory so that I can use it
in MS Access as an ordinary table?

--
http://www.WindowsForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.WindowsForumz.com/Active-Directory-Query-compare-MS-SQL-ftopict243081.html
Visit Topic URL to contact author (reg. req'd). Report abuse:
Click to expand...
http://www.WindowsForumz.com/eform.php?p=739354
 
Back
Top