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

I want to display a list of nodes and how long it's been since they last talked back.

I have some derelict nodes, I have no problem looking at what ones are down but I want something that shows what's down and how it has been down for.

There's some in my system I can surely delete from the database.

I'm sure it can be done...

Find more posts tagged with

Accepted answers

FormerMember

This Custom SQL Report will show the nodes that are down, and when they last showed as up, you can then delete the nodes via the Web Console

1. Start > Programs > Solarwinds Orion > Alerting Reporting and Mapping > Report Writer
2. File > New > Advanced SQL
3. Name the Report

4. In the SQL tab enter:
SELECT Caption, IP_Address, LastSystemUpTimePollUtc
FROM Nodes
WHERE
Status ='2'
ORDER BY LastSystemUpTimePollUtc
ASC

5. Save the report with an appropriate name, eg Down Nodes

6. This report will now be available on the Web Console.

All comments

FormerMember

This Custom SQL Report will show the nodes that are down, and when they last showed as up, you can then delete the nodes via the Web Console

1. Start > Programs > Solarwinds Orion > Alerting Reporting and Mapping > Report Writer
2. File > New > Advanced SQL
3. Name the Report

4. In the SQL tab enter:
SELECT Caption, IP_Address, LastSystemUpTimePollUtc
FROM Nodes
WHERE
Status ='2'
ORDER BY LastSystemUpTimePollUtc
ASC

5. Save the report with an appropriate name, eg Down Nodes

6. This report will now be available on the Web Console.

lbrowne

Awesome thanks! One question - step 5, where am I clicking to Save this?

I'm still on the SQL tab where you enter the SQL queries...

When I hit the save button along the top of the Report Writer, it just wants me to save it as a file...

FormerMember

My pleasure :-)

You save as a file...save in the Reports folder on the Orion server. The report is then available in the Web Console.

lbrowne

I get this message when trying to save:

Detected usage of a macro, which links to a nonexistent field in the report. Therefore WebURL, which uses this macro, will not be generated correctly.

Missing fields:

NodeID

KwameB

I've just tried this & works great.

However, I noticed that LastSystemUpTimePollUtc only returns values for SNMP nodes.

I'd like to get the same results for my ICMP nodes, is there a "Last Ping Response" field anywhere in the Database?

lbrowne

I'm interested in this too.