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

Is it possible to only display this portion of the chart?

Is it possible to only display the highlighted chart when displaying information? I am currently in the process of making ingress/egress charts for all sites, and would like to only have this portion so I can provide management with a quick, visually pleasing graph indicating performance without having too much clutter.

Find more posts tagged with

Accepted answers

All comments

wluther

fpilipauskas No, not natively. Not without making changes a bunch of changes to default code/files. However, you can, fairly easily, implement some custom graphs, which should allow you to fit a bunch more data onto a page.

This document will break down the installation process, and show you how the different pieces work.

Custom Graphing: Fun With Highcharts

From there, you should be able to modify the code enough to build yourself a page, crammed full of graphs.

Let us know if you have any trouble, as well as if you were able to successfully build your page of graphs.

Thank you,

-Will

fpilipauskas

Thanks Will! I actually had someone from my office refer me to this but I ran into issues due to my extreme lack of knowledge of SQL. I am attempting to get the Total Traffic Transmitted and Received for a given interface in Bytes/s over the course of 24 hours. I am brand spanking new to SQL, and was curious if I would be able to generate this through something like sql management studio? Could you expand on how you generated the query to pull for memory over last 24 hours? Did you just know how to write the code, or did you use a builder?

wluther

fpilipauskas I did not actually write the SQL query for that modification, however, once you start poking around in there, you pick up a bunch of handy info. I have not used any tools that would build my query, however, Thwack has a ton of examples. I tend to search through Thwack first, find some examples, and then use those examples as jumping off points. Over time, you just start using fewer and fewer examples, as you memorize the common areas. I do, however, use SSMS when I am working on queries.

I believe the view you are looking for, to track the tx/rx for an interface, is "dbo.InterfaceTraffic".

SELECT TOP 1000 [NodeID]      ,[InterfaceID]      ,[DateTime]      ,[In_Averagebps]      ,[In_Minbps]      ,[In_Maxbps]      ,[In_TotalBytes]      ,[In_TotalPkts]      ,[In_AvgUniCastPkts]      ,[In_MinUniCastPkts]      ,[In_MaxUniCastPkts]      ,[In_AvgMultiCastPkts]      ,[In_MinMultiCastPkts]      ,[In_MaxMultiCastPkts]      ,[Out_Averagebps]      ,[Out_Minbps]      ,[Out_Maxbps]      ,[Out_TotalBytes]      ,[Out_TotalPkts]      ,[Out_AvgUniCastPkts]      ,[Out_MaxUniCastPkts]      ,[Out_MinUniCastPkts]      ,[Out_AvgMultiCastPkts]      ,[Out_MinMultiCastPkts]      ,[Out_MaxMultiCastPkts]      ,[Archive]      ,[Weight]FROM [dbo].[InterfaceTraffic]WHEREInterfaceID='3753'ANDDateTime >= DateAdd(hh, -24, GETDATE())ORDER BY DateTime DESC

In the example query above, the results would show every data point for the specified interface (InterfaceID='3753'), for the last 24 hours... I think...

That example has a bunch of extra data too, which you can simply remove. Also, if you are wanting to graph it in a normal order, you might want to remove the "ORDER BY" line.

Other than that, just jump in. Google + Thwack = 2 best buddies!

Thank you,

-Will

fpilipauskas

Thanks for all the assistance!