SAPIEN Technologies

I couldn't get the code to paste as the forum kept prompting there were to many off-site URLs for new users..I tried removing everything I could find, but no luck, so I attached it as a text doc.

Thx!
Marie

Thank you again! Here are the details: 1- This script runs within a SQL job on a 2008 sql server. 2- It retrieves AD data and populates a SQL DB with that data 3- It functions fine using the entire code below, this was written by a SQL DBA a few years ago and I was able to add a couple user attribs ...

Thank you all, I apologize for the bad post! The script that I have is part of a SQL job. The job runs the script and I didn't realize that the entire script wasn't posted. I'm going to update the post, I was trying to edit it, but I don't see that option. I am new to VB and also SQL jobs that run s...

Thx! Yes, that's all I need, and I know this can be done much easier and better, but the SQL group won't change at the moment.

To add this line in, I tried belis the get query, but it fails, where do I add it?

The script I posted runs as a SQL job, so my understanding is that it's just vb and then the commands are in there that work with SQL to add the data to the database. I literally copied and pasted the script from SQL to the post. So if I were to just add the manager part to what I posted, what would...

Thank You Immensely! Can I trouble you for one more question? The script I posted is run as a MS SQL job, and the commands for SQL are in the script. How do I add the part that just pulls the manager info as you posted in your first reply, or if I want to just use the code you posted to pull all the...

Howdy I am nearly done with this script and can't get the managers sAmAccountName. This works to gather many attributes for users and I can get the DN of the manager, but not the samaccountname, can anyone help me with this? Set objRootDSE = GetObject("LDAP://RootDSE") strDNSDomain = objRo...