Load_Watchlist.SQL

[RSAAdmin]

Can anyone possible give me a Load_Watchlist.SQL of course with dummy payload. I just need to see what it is actually meant to look like. Im so close to getting a working VBScript for automatting the watchlists, just need this to get the last bit working.

[RSAAdmin]

Each load_watchlist.sql file generated by an invocation of dbupdate_watchlist.cmd is left residual in the %_ENVISION%\database\cmd directory, so you should have a copy there.  However, below you find the contents of one where I created a watchlist called "samplewatchlist", created a input file called "samplewatchlistvalues.txt" containing the following values: 

123.123.123.123
222.222.222.222
111.111.111.111
321.321.321.321

Then invoked the following command:

%_ENVISION%\database\cmd>dbUpdate_watchlist.cmd samplewatchlist samplewatchlistvalues.txt

-----begin contents of load_watchlist.sql file -------------------------

begin
if ( exists( select 1 from "watchlist" where "name" = 'samplewatchlist')) then
        update "watchlist"  set listvalues = '123.123.123.123~W~222.222.222.222~W~111.111.111.111~W~321.321.321.321~W~' where name = 'samplewatchlist';
     commit;
end if;
end

-----end contents of load_watchlist.sql file ----------------------------

hope this helps,

ryan