nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

Report Writer- Customizing Historical Traffic Reports

asadeghi

Hi There,

Can someone explain to me, how to customize the "95th Percentile Traffic Rate -Last Month" report for one single device?

Thanks,

Ali

Find more posts tagged with

traffic_rate

report_writer

95th_percentile

Accepted answers

Yann

Hi,

Since this is an advanced SQL Report, you will need to edit the SQL Query.

Open the Report in Report Writer. Click on The SQL Tab and add the following line just before the ORDER BY Statement:

WHERE Nodes.Caption='Node-Name'

Node-Name is the name of your single device.

ON (Interfaces.InterfaceID = RESULT_MAX.InterfaceID)
---------------------
WHERE Nodes.Caption='Node-Name'
ORDER BY NodeName, Interface_Caption

Save the report under another name to keep the original report.

All comments

Yann

Hi,

Since this is an advanced SQL Report, you will need to edit the SQL Query.

Open the Report in Report Writer. Click on The SQL Tab and add the following line just before the ORDER BY Statement:

WHERE Nodes.Caption='Node-Name'

Node-Name is the name of your single device.

ON (Interfaces.InterfaceID = RESULT_MAX.InterfaceID)
---------------------
WHERE Nodes.Caption='Node-Name'
ORDER BY NodeName, Interface_Caption

Save the report under another name to keep the original report.

asadeghi

Thank You.

DaveAz

Is there a method for this to report for just a few interfaces on two devices?

Thx,

Dave

DaveAz

...Or a way to filter if I added a comment field?

Yann

Hi Dave,

If you add a custom property to the interfaces you want to report or if they begin with the same name, the results can be filtered too in the WHERE condition.

e.g.:

WHERE Interfaces.Report95thPercentile = 'true'

or it could be:

WHERE Interfaces.Caption LIKE "%FastEthernet%"

and you can combine multiple filters in the WHERE condition such as:

WHERE Nodes.Caption LIKE "%Server%" AND Interfaces.Caption LIKE "%FastEthernet%"

HTH,

Yann

DaveAz

I added a comment to only the interfaces I want to be in this report. Let's say it's "whatever". So it should look like this: WHERE Interfaces.Caption LIKE "%whatever%"?

Sorry to be such a pain...

DaveAz

I tried that string, and it didn't work.

In your first reply, you gave a string for a single 'Node-Name', Is there a way if I have two 'Node-Names'?

Thanks a ton for helping me!

Yann

Sure it should be possible:

WHERE Nodes.Caption='Node-Name-1' OR Nodes.Caption='Node-Name-2'

DaveAz

Weird...I attempted that, except I used AND...I assumed that's how that string would have went.

What do you think about the comment field? I tried that a couple different way and still no luck.

Thanks,

Dave

Yann

Could you attach the SQL Query that does not work and detail how you setup your Custom Properties (comment field)?

Thank you,

Yann