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

How to create Min/Max Receive & Transmit Bandwidth during local business hours .

rabinarayan

Can some one suggest me on this.

Find more posts tagged with

Accepted answers

All comments

rabinarayan

Still waiting for response .
I was able to create this for 1 week /last hour / month but not for a particular business hours.

zackm

you have to use timestamp limitations in your datasource:

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Loop1 Twitter: @Loop1Systems
ZackM Twitter: @ZackM

rabinarayan

Could you please share the screen short of the next step.
I mean what would be the custom table for this.

rabinarayan

I want to create

Min/Max Receive & Transmit Bandwidth during local business hours - Last 7 days

So please share me the screenshot how to do this

I have tried on this way but no data is fetching from server .

Capture 3.PNG

Capture 2.PNG

zackm

looks like you've found a bug in the web report engine. I'm seeing the same issues on this side. I would suggest opening a ticket with support to get a resolution.

in the meantime, you could get a similar report via a custom SQL query as such:

SELECT  n.Caption 'Device'  ,i.Caption 'Interface'  ,MAX(In_Maxbps) 'Peak Receive bps'  ,MIN(In_Minbps) 'Min Receive bps'  ,MAX(Out_Maxbps) 'Peak Transmit bps'  ,MIN(Out_Minbps) 'Min Transmit bps'FROM InterfaceTraffic tJOIN Interfaces i ON i.InterfaceID = t.InterfaceIDJOIN Nodes n ON n.NodeID = t.NodeIDWHERE t.DateTime > (GETDATE()-7)AND (  (DATEPART(WEEKDAY, t.DateTime) <> 1) AND -- Not Sunday  (DATEPART(WEEKDAY, t.DateTime) <> 7) AND -- Not Saturday  (CAST(t.DateTime AS TIME) BETWEEN '06:30' AND '18:30') --Between 6:30am and 6:30pm)GROUP BY n.Caption, i.CaptionORDER BY n.Caption, i.Caption

rabinarayan

I'm getting below error while executing

Msg 8153, Level 0, State 1, Line 1

Warning: Null value is eliminated by an aggregate or other SET operation.

Could you please suggest on this

zackm

that's just a warning that your original data set had NULL values in it that were removed during the aggregate functions.

basically, in the joining of InterfaceTraffic to Interfaces to Nodes, there were columns with NULL values; but after the SELECT clause finished, the NULL values were eliminated from the final results (because NULL was not the MIN or MAX for anything).

It's a warning, not an error, should be able to be ignored.