Re: Select Statement Output

[carlo s]

The following query is working for me...

select Date, substring(MsgText,POSITION('access' in MsgText)+35, POSITION('/'in MsgText)-17)as outside, count(*) as Hit_Count from SystemEvents
where MsgText like'%denied%'
and MsgText like '%OUTSIDE-INTERFACE-IP-GOES-HERE%'
and Date > '2009-01-01'
group by substring(MsgText,POSITION('access' in MsgText)+35, POSITION('/'in MsgText)-17)
Order By Hit_Count DESC