how to pull unmanaged nodes report in solar winds
This should do the trick. Either run it against your db, or open Report Writer and select advance sql and paste it in there.
Select Caption,IP_Address,StatusLed
From Nodes
Where Unmanaged like '1'
for the scenario how to run against the database ...can u elaborate bit.
if we want to pull report for UN-managed nodes which are not being used from past 60 days
Open the Solarwinds database manager and run that query from there.
From the NPM server navigate to Start > All Programs > SolarwindsOrion > Advanced Features > Database Manager
This will open the Database Manager. Once it's opened
Click on Add Default Server
Expand the database, then expand the Solarwinds database.
Once it's expanded and you see all of your tables right click over any table and Select Query Table
Delete the contents inside of the box
Paste the query I sent over and select Execute Query. This will give you information you are looking for.
If you want to make this more of a formal process, then I suggest using report writer to save the report.
Here it is in SWQL -- That's from some other post but I can't remember which one. I use it as a resource on one of my pages, you can put it in as a report as well using SWQL.
SELECT N.Caption, N.IP_Address, N.UnManageFrom AS [From], N.UnManageUntil AS [Until], AE.AccountID AS [By], DayDiff(GetUtcDate(), N.UnmanageUntil) AS [Days Left]
FROM Orion.Nodes N JOIN Orion.AuditingEvents AE ON (AE.NetObjectID = N.NodeID)
WHERE N.UnManaged = 1 AND (AE.AuditEventID = (SELECT TOP 1 AE2.AuditEventID FROM Orion.AuditingEvents AE2 WHERE AE2.NetObjectID = N.NodeID ORDER BY AE2.TimeLoggedUtc DESC))
ORDER BY N.Caption
Hi, thanks for the report
i had generated the report using report writer,i can view nodes which are down .. but i am not getting the list of un managed nodes....
Hi,
where we need to use this code
1) report writer ?
or
2) we report console - by creating new report?
Use the web based report manager, create a new report, choose custom query. Edit the custom query resource and paste the code into
Then click submit and go through the rest of the add report wizard.
Hello parsaie,
Thanks for the resource code that got worked for 60 days , if i want to get the report for 90 days where should i change the code?
Hello dear parsaie,
The above code worked for me , could u pls let me know what changes do i need to make in the resource code to pull report for only last 3 months(90days) and only for servers(device specific)...code which you mentioned above i am getting only network devices/nodes....
Awesome! Works perfectly! Thank you pparsaie. Much appreciated.
HI Team,
I want create the report for node status is equals to unmanaged and muted from last 5 days.
Could you please suggest me with correct query?.
Thanks
Aswanikumar
