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...
All props to rfackrell
I use this SWSQL Query to show mine
SELECT TOP 1000 NodeID, IPAddress, Caption, UnManaged, UnManageFrom, UnManageUntil
Where UnManaged = TRUE
ORDER BY UnManageUntil
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.