Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Report or sql statement

Hello,

I am using netflow version 3.1 and I am trying to built a report with anything marked with CS0 and is RTP traffic, but I can't really see a way to do this with report writer.

Is there a way I can pull up the SQL statement from this page(screenshot): http://gyazo.com/c9ff3e8d906a1e3dc5763d12ea41c7c1.png

basically that is giving me what I want from the netflow page, but I need to send a report with this info.

I should be able to do what I need if I have the sql statement, unless someone has done this with report writer.

thanks.

Find more posts tagged with

Reports

netflow

report_writer

qos

Accepted answers

salparadise

I created a new view similar to the Netflowsummary view, but I added a the ToS field and only grabbed the values that had ToS = 2 (this is CS0).

I called this view NetflowsummarywithTos, then I can query this view with the following (screenshot link):

http://gyazo.com/54b62507872358f89d65dcfa787791de.png

I have also attached this in case anyone needs to copy and paste.

And this was able to give me the RTP traffic marked with CS0 for the last 7 days, and some other criteria specific to my environment which is what I needed.

longquery.sql

All comments

chris.lapoint

With report scheduler, you can email a web page in an email. So, if you're getting what you want from a NetFlow page, that might be the simpler/easier option for you.

salparadise

I tried that but the query times out, so the email never gets sent. I have pursued this a different direction. Thanks.

MarieB

HI Sal--

Would you mind posting your direction and any solutions you find for the benefit of the community?

Many thanks,

salparadise

I created a new view similar to the Netflowsummary view, but I added a the ToS field and only grabbed the values that had ToS = 2 (this is CS0).

I called this view NetflowsummarywithTos, then I can query this view with the following (screenshot link):

http://gyazo.com/54b62507872358f89d65dcfa787791de.png

I have also attached this in case anyone needs to copy and paste.

And this was able to give me the RTP traffic marked with CS0 for the last 7 days, and some other criteria specific to my environment which is what I needed.

longquery.sql