Thursday, October 18, 2007

remove PIX 7-710005 messages (UDP request discarded) from db

remove PIX 7-710005 messages (UDP request discarded) from db

set rowcount 0
delete from pix001
where issue =710005 and
rid <(select max(rid) rid from helper1 where lpc='PIX001-ISSUE-DELTA') and (
charindex('255.255.255.255/711',messagetext)>0 or
charindex('inside:194.48.0.0/8116',messagetext)>0 or
charindex('inside:172.19.0.0/8116',messagetext)>0)


%PIX-7-710005: UDP request discarded from 0.0.0.0/8116 to inside:1.2.3.4/8116