Is it possible to create a report using data from a custom graph?

I've created a custom graph on an interface that shows the peak transmit and receive bps, and I've also set the statistics collection to every 1 minute. This allows me to zoom in and see minute-by-minute data sampling. I've been unable to figure out how to replicate this same information in a report. Here's the graph:

I'm able to make a report and use the peak transmit and receive bps data, but I can't set a sample interval lower than each hour. This is the case even when creating a reporting that only monitors statistics within the last day, last few days, etc. Is it possible to use the minute-by-minute data sampling from the custom graph to create a report, or somehow use a sampling interval lower than each hour? The goal is to create a report that shows the peak transmit and receive bps each day of the past month. If a sampling interval of one minute was available, this should be possible.

1 (1).PNG

Thanks for the guidance.

Find more posts tagged with

sample interval

Accepted answers

mesverrum

That's because your retention settings do not hold detailed stats that long, the default is only 7 days of granular data. You have to increase your default retention to at least 30 days run the report for the current month.

All comments

mesverrum

That box is for summarizing data, just switch it back to the default value of show every data point. Thats going to conflict with your show only the top 6 setting though, as it will pick the first node and only show you 6 data points

jjmerrill

No luck there. I'm filtering by a specific interface on a node, and using the "show all values in the database, do not summarize" option results in only one data point on the graph. The data exists within SolarWinds in some way, or the minute-by-minute graph wouldn't be possible. If I could somehow use a report to collect all of the data from that graph and then show the top X values in a given month, that would be the solution.

mesverrum

Post your query and I can tell you what its doing wrong. If you just want a report of the top x tx/rx utilization rates for a given interface it would be something like

select top 5

i.fullname, it.datetime, it.InPercentUtil, it.OutPercentUtil

from orion.npm.interfaces i

join orion.npm.interfacetraffic it on it.interfaceid=i.interfaceid

where i.fullname like '%xe.1/0/4.2030X'

order by (it.inpercentutil + it.outpercentutil) desc

jjmerrill

Thanks for the help. The link below has the XML export of the web-based report that I built out. There's probably a much cleaner way to export the report query. Please let me know if that's the case - I'm still very fresh to building out custom reports.

Dropbox link

This report is very close to what I'm looking for, except I want the sampling interval to be at least every 5 minutes, if not every 1 minute, instead of each hour. The objective is to show the peak transmit/receive rates on the interface and the time when they occurred within the previous month. Right now, the report generates the peak transmit bps with the timestamp of the hour that the interface peaked at, which isn't granular enough to be useful.