Ive been working on a VBscript to auto update watchlists for a while now. I have finally cracked it and would like to share it with everyone.
It started out that i wanted to pull users for AD (disabled users) and monitor if they get enabled and logged into. I thought must be simple enough to automate. Then relised that there was a limit of 32k using the methods Envision had out the box.
The AutoUpdate script is separated into 2 parts. The first part does the AD look ups and outputs to a TXT file on the Envision Appliance. The second part converts the TXT file into a .sql file and injects it into the Sybase DB.
The process has to be setup this way as the the Envision box is seporated and on its own domain.
I hope these help others out, let me know if you have any issues.