So I have a script that updates our active directory based on data from our employee records database. Currently I pull all records from a view of the employee database, and cycle through each record, then query AD baesd on the users employee ID.
So this means I query AD for everyone employee I cycle through. My script takes about two hours to complete for around 2500 users. I was wondering if it would be quicker to pull all of AD into a recordset, and rather then querying AD for every user, I could query the AD recordset which would be in memory.
I can't seem to find if this is possible with vbscript. I know I can search the recordset, but not using SQL. If anyone has any ideas for me that would be great.