jjmerrill

Thanks again for your time. I can confirm that changing the detailed statistics retention is what was missing. Thankfully, there's plenty of storage left in the SQL server to accommodate the change. Here's a screenshot in case this might help someone in the future.

Sounds like I'll need to increase the "Detailed Statistics Retention" to at least 30 days. I have the interface statistics sampling set to 1 minute for the interface I'm working with. I'll go ahead and give this a try and reply again with the results. Thanks for taking the time to help with this.

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…

Thanks again for the guidance. Everything is working as expected. Here's a snippet of what I'm doing in case it might help someone in the future. WHERE (Interfaces.Caption LIKE '%InterfaceX%') OR (Interfaces.Caption LIKE '%InterfaceY%') I'm using the "%%" modifiers so that SQL will grab any interface caption that contains…

I agree with your overall philosophy, and like the idea of using a report for this instead of email alerts. I may still configure a utilization alert for 90%+ for certain interfaces, but leave it at that. I'm still new to the SolarWinds platform as a whole, but have managed to clean up a fair amount of the alert fatigue…

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…

Thanks for the quick response and the guidance.

This worked great, thank you as always for your time and knowledge. I created a custom property named "Report_Filter" with the custom properties editor (Success Center ) and assigned it to my 10 interfaces, and gave them an appropriate value for the custom property. Because I'm using 1 minute for the detailed polling…

Possibly, though it would be great if we could use our existing tools and not incur additional cost. If it isn't possible to add additional info to these MIBs on the email alerts, we might have to consider additional tools. Thanks for the response.

Good thought, but the lowest sample interval is still only for each hour even when using a report that grabs from the last 7 days or less. SolarWinds is definitely getting the data somehow, as I can create a custom chart on the interface and see minute-by-minute the peak and receive bps. If I could get this into a report…

Thanks for the quick response. When pasting that at the bottom of the SQL query, it's returning "Query not valid". I'm missing something easy due to my lack of SQL knowledge. Also, is it possible to use the WHERE statement to add multiple interfaces? For example, if an interface name contains "NameX" OR "NameY", show in…

Thanks for the response and the guidance. I think we've been overly reliant on traps in the past and that this is good advice.