4 Replies Latest reply on Jun 4, 2015 8:10 AM by TreyJ

    Report Writer SQL query help


      I'm trying to use an sql query in report writer to create a report from trap data.  I'm pulling one line out of the trap data using the SNMP OID and I'm getting something like this:


      <190>May 27 2015 07:39:49: %ASA-6-716002: Group <RremoteAccess> User <testuser> IP <xxx.xxx.xxx.xxx> WebVPN session terminated: Idle Timeout.


      I would like to be able to remove the first four characters from this line.  The number rotates between <188>, <189> and <190>.


      Is there a way in SQL to do that?