I just need to know if the following is possible. Every month we perform specific tasks. One task I have is just plain annoying. I have to manually compare my AD user lists vs Assentor user list. Assentor is made by Computer Associates. It is a SQL db that will need to be queried.
I would like to create a VBS that I can double click, and do this task for me. So for example, if User A is in AD, but not in Assentor, I'd like for the VBS to dislpay a page with all the users that are NOT in both tables..
So when the script checks AD and Assentor, both users MUST appear in the list so that it doesn't show on the report. If a user only exists in 1 table, that will then show up on the page at the end of the VBS.
Anyone know if this can be done? I would imagine its possible, but don't know where to start.
Thanks for any input.