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

All+Unmanaged+Nodes+-+Web.xml

From the (locked) article https://thwack.solarwinds.com/t5/NPM-Documents/All-Unmanaged-Nodes-Web-xml/ta-p/528321 @rfackrell posted a SQL query that was wasn't working on other installations. After digging through, I found the table names might vary. For my installation, I need to change

line 59 to "FROM dbo.Nodes n WITH(NOLOCK)" and

line 64 to "FROM dbo.AuditingEvents WITH(NOLOCK)" and

line 67 to "LEFT JOIN dbo.AuditingEvents r1 WITH(NOLOCK) ON (r1.TimeLoggedUtc = MaxDates.max_datetime AND r1.NetObjectID = MaxDates.NetObjectID AND r1.ActionTypeID = '27')" No quotes.

And now it works for me...

Frank

All props to rfackrell

Find more posts tagged with

Accepted answers

All comments

bobmarley

I use this SWSQL Query to show mine

SELECT TOP 1000 NodeID, IPAddress, Caption, UnManaged, UnManageFrom, UnManageUntil
FROM Orion.Nodes
Where UnManaged = TRUE
ORDER BY UnManageUntil

frankmuhlstadt

Nice! Made it a widget

rfackrell

Awesome Thank you!
I posted a link to this in the original so people can find your work.