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

Customized Report Assistance

roselyn

Has anyone have script for the ff:

Total number of Interfaces UP, DOWN And SHUTDOWN for a given node.

Total number of UP and Down Nodes.

Average and Peak Traffic Rates (last Month) ---> frm mon. to fri only 9am to 5pm

????

Find more posts tagged with

Accepted answers

njoylif

ok, that's a good bit of stuff

1. Total # interfaces up/down/SD per node...

select n.nodeid, n.caption,
    (select count(Status) from interfaces where nodeid=n.Nodeid and status=4) as AdminDown,
    (select count(Status) from interfaces where nodeid=n.Nodeid and Status=1) as UP,
    (select count(Status) from interfaces where nodeid=n.Nodeid and Status=2) as DOWN
from Nodes n

2. Count of Nodes given a particular status...

select COUNT(n.status),
s.shortdescription
from Nodes n join statusInfo s on n.Status=s.StatusId
group by n.status, s.ShortDescription

will post a link to content share for the last one in a bit.

All comments

njoylif

ok, that's a good bit of stuff

1. Total # interfaces up/down/SD per node...

2. Count of Nodes given a particular status...

select COUNT(n.status),
s.shortdescription
from Nodes n join statusInfo s on n.Status=s.StatusId
group by n.status, s.ShortDescription

will post a link to content share for the last one in a bit.

roselyn

hi!

Thanks for the help

njoylif

see THIS LINK for content share for report #3

have fun.

roselyn

Hi!

Thanks a lot

roselyn

Hi!

I got this error when I tried to change the limitation part.

Could you help me on this? What if I don't want to have some limitation? Iw anted all devices to be monitored?

error.gif

njoylif

no problem. send me an email with your report and what you are trying to do specifically or give me a call. today is bad, but tomorrow I should be able to take care of it.

If you send to me as well, I might be able to get to it today.

Have a good day.