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

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