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

Report Writer

Dear All,

Just need a small help, we have around 30 links which are monitored through Orion NPM. i want to write a report to generate list of locations whose utlization is contanstly below 50%.

I have written report for list of links which are above 75% and that works fine, but when i try to generate the list of locations which are below 50% even the links which are bove 50% also get included in the same.

Is there a way to generate list of locations only below 50%.

Thanks & Regards

Vinod Dhure

Find more posts tagged with

report_writer

utilization_below_50%

Accepted answers

All comments

lchance

this must be a bug...

it does the exact same when i try the same report.

lchance

...i found something interesting.

if you use SORT DESCENDING on the utilization then it will work!

SELECT
Nodes.Caption AS NodeName, Interfaces.FullName AS Full_Name, (NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 AS AvgXmitRecvPercentUtil
FROM
Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)
WHERE
(
((NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 > 1) AND
((NullIf(InPercentUtil,-2)+NullIf(OutPercentUtil,-2))/2 <= 50)
)

ORDER BY 3 DESC

vinod

Have refered the problem to Solarwinds support team, they are looking into the same..

Regards

Vinod Dhure

vinod

Dear All,

Seems its going to take some time till the solarwind support teams gets back with the solution. Till then do any of you see any workaround for the problem.

Kindly help !!!!!

Thanks & Regards

Vinod Dhure

bshopp

Did you try what lchance recommended in the thread?