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
Store

Reboots last 24 hours

Okay maybe I am overlooking something and you can assist. I am trying to pull a 24 hour report for reboots. I dont need to a million mile long list of the last time each device has rebooted, I just want to see what devices that have rebooted in the last 24 hours. The canned report will allow you to specify reboots since a certain day but dont seem to do so based on a time frame such as the last 24 hours. Anyone have any advice on this one?

thx,

TCK

Find more posts tagged with

Accepted answers

All comments

tbaggins

I'm looking for the same thing!!! Why can't we specify Every server where reboot = changed withing a 24hr time frame?

Nandish

Using report writer tool,you can select create report to start off.Then from the bunch of options you should be able to select "Advanced SQL".This would allow you to write your own custom query.Any SQL experts should be able to write a query to satisfy your needs.Feel free to post back the SQL query when you have one up working.

FormerMember

select sysname, lastboot
from Nodes
WHERE lastboot >= DATEADD(day, -1, GETDATE())

Nandish

Thanks pyro13g for posting this SQL Query.