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

Report Writer SQL query help

TreyJ May 27, 2015 7:55 AM

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!

Re: Report Writer SQL query help

d09h May 27, 2015 10:11 AM (in response to TreyJ)

Seems possible:

SQL Server: REPLACE Function

SQL Server: STUFF Function

I'm not at work to try this, but looks like it would work.
Like Show 0 Likes(0)

Actions
Re: Report Writer SQL query help

TreyJ May 27, 2015 2:29 PM (in response to TreyJ)

After reading the description of those commands, I don't think either would work because the source string is never the same, except for the first four characters. The table it's pulling from is RawData.
Like Show 0 Likes(0)

Actions
- Re: Report Writer SQL query help
  
  d09h May 27, 2015 6:52 PM (in response to TreyJ)
  
  Combined with CASE command, I can see this working.
  
  SQL Server: CASE Statement
  
  Like Show 0 Likes(0)
  
  Actions
Re: Report Writer SQL query help

TreyJ Jun 4, 2015 8:10 AM (in response to TreyJ)

Got pulled off to work on some other projects. I'm not an SQL scripter by any stretch of the imagination, so I'm not sure how that would work.
Like Show 0 Likes(0)

Actions

Go to original post