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

Node uptime in days for specific group... possible?

All,

I have found the query below that will show me all nodes and the "days up" for each. My goal is this report for a specific Orion group and to be able to view this report via the web console. Help and guidance much appreciated.

SELECT NodeID, VendorIcon, Caption,MachineType,
DateDiff(Day,Nodes.LastBoot,GetDate()) AS DaysUp
FROM Nodes
ORDER BY 5 DESC

JSHIV

Find more posts tagged with

Accepted answers

All comments

jshiv

Oh, and to continue the dream... then number of reboots for the past 30, 60, 90 days.

mcbridea

Check the Content Exchnage section for a report you can use or edis as needed. Once you have the report you can publish it as a resource on the web console.

This Technical Reference should get you there. http://www.solarwinds.com/documentation/Orion/docs/UnderstandingOrionReportWriter.pdf