|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
10-22-2008
| #1 (permalink) |
| | Compare users in AD with an SQL table and insert the missing users Is it possible to compare users in Active Directory with a SQL table and insert the users who are missing in the table? Any suggestions on this topic would be much appreciated. TIA Nov |
My System Specs |
|
10-22-2008
| #2 (permalink) |
| | Re: Compare users in AD with an SQL table and insert the missingusers On Oct 22, 5:30 am, novi...@xxxxxx wrote: Quote: > Is it possible to compare users in Active Directory with a SQL table > and insert the users who are missing in the table? Any suggestions on > this topic would be much appreciated. > > TIA > Nov Script or pure SQL. One method would be to loop through your AD records user by user. For each user, test if exists in the table. If not, insert the user. This would be the brute force VB script approach. Another method would be to link Active Directory as a linked server to SQL. http://articles.techrepublic.com.com...1-5259887.html You could then write an Insert statement using the results from a SQL query. |
| My System Specs |
|
10-22-2008
| #3 (permalink) |
| | Re: Compare users in AD with an SQL table and insert the missingusers Of course it's possible to do that. What database are you using? |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Help Run Dll C:\Users\ Users name\AppData\local\temp\axdeqxgo.dll | Vista security | |||
| compare users in csv to AD | PowerShell | |||
| Access All Users & Default Users Start menu | Vista file management | |||
| C:\Users\all users\start menu - DENIED | Vista file management | |||
| cant connect to my doccuments on \\domaincontroller\users\users sh | Vista networking & sharing | |||
