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

    Report Writer SQL query help

    TreyJ

      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?

       

      Thanks!