Ive got a VBscript that pulls DisabledUsers from AD, ouputs a DisabledUsers.txt, then fires another VBscript to update the watchlist on Envision. The second script generates a sql file (based on the original script that was created by Dave Glover) then calls the _setupEnvironment.cmd which i thought calls the sql file. But it doesnt seem to.
Any help appreciated.
Once everything is working i will of cause share the scripts with everyone.
My mistake it calls the startISQL.cmd which processes the userlist. Something definitely happens to the list when viewed from Envision console. The list seems to be blanked? Is there anyway to physically access the database and view the tables?
If i run startISQL.cmd i loads aui to the db allowing me to run statements but i cant view anything from it. If i run the sql file content directly in the gui, it seems to process and gives me a execution time. Can anyone help?