Which version of NPM do you use. From NPM 10.7+ we introduced new reporting.
1. Click report in web.
2. Create new report.
3. Pick Custom table.
4. Pick Events as things which you need.
5. Pick eventtype = Node rebooted.
6. In edit pick what you want.
7. Configure table.
Be aware in default events are deleted after 30 days. Can be changed in settings of course.
WIll give this a go
I was using the report writer and managed to get.... However it was giving me all of them.
- Nodes.Caption AS NodeName, Nodes.LastBoot AS Last_Boot, DATEDIFF(day, Nodes.LastBoot, getdate()) AS no_of_days
(Nodes.Comments LIKE '%Plymouth%')
ORDER BY 2 DESC