Reboot Report help

Prineel

Hi there, looking at creating a reboot report showing device reboot times and count over last x days.

I have a report showing last reboot on nodes but not the counts.

Specifically for Cisco devices.

Thanks

Find more posts tagged with

reboot report

npm

report

Accepted answers

All comments

vinay.by

https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/reports/3003

Hope this helps.

Prineel

Thanks @vinay.by will look into this!

bobmarley

Reboots are stored in the Events table, this should get you started

SELECT [Nodes].NodeID
     , [Nodes].IPAddress
     , [Nodes].Caption
     , [Nodes].MachineType
     , [Nodes].Events.Message
     , [Nodes].Events.EventTime AS EventTimeUTC   
FROM Orion.Nodes AS [Nodes]
Where [Nodes].Events.Message LIKE '%reboot%' AND MachineType LIKE '%Cisco%' AND [Nodes].Events.EventTime > ADDDAY(-7, GETUTCDATE())
Order BY [Nodes].Events.EventTime DESC

Prineel

Thanks @bobmarley this works great!

Anyway to put a count on the number of reboots?

Also assuming by default this will only retain events for 30 days?