Last post May 13, 2008 09:54 AM by johram
Apr 28, 2008 06:18 AM|pimps|LINK
I don't know if this is possible but I'm going to ask it anyway. I need a VBscript. This script will be a scheduled job. This script needs to check active directory for new users and then it has to write the new users (if there are some) in my SQL Database.
So for the moment I have an SQL database with many users. But from now on I want to get the users automatically from active directory.
Is this possible and/or has anyone an example??
Many many thx in advance!!
Apr 28, 2008 10:13 AM|raghu1|LINK
Yes, it is possible. I would write a console application for that. You need to add reference directoryServices and work of it. You can than schedule the console apps using windows scheduler. I use c# to do something similar. I do not have a VB example, if
you search this forum you will get several good working examples.
May 13, 2008 05:15 AM|pimps|LINK
Thx for the reaction.
But I've been searching the forum for code expample and I can't find some.
Anyone has an example??
Many thx in advance!!
May 13, 2008 09:54 AM|johram|LINK
You can use the
CSVDE tool to export information from Active Directory, according to a filter that you set up. CSVDE will produce a file with comma-separated values which you can then import to your SQL either by using a DTS (in SQL 2000) or by doing som custom scripting.