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

Custom Report : Historical Data on Lastboot

I'm trying to create a custom report that shows when each node was rebooted over the last 3 months grouping by node name. Any suggestions on how I would go about doing this?

Thanks

Find more posts tagged with

Accepted answers

All comments

Mithrilhall

Okay...I think I'm headed in the right direction but how much historical data is kept on reboots? I would like to determine the number of times each Node was rebooted since it was added to SolarWindds.

This is what I have so far:

SELECT Nodes.NodeID, Nodes.Caption, Events.EventType, Events.Message
FROM dbo.Nodes, dbo.Events
WHERE Nodes.NodeID = Events.NetworkNode AND EventType = 14
ORDER BY Caption

I'm looking at the data I got back by running the above query and I have nothing older than December of 2004. Is there a way to get the information for the last 3 months?

Network_Guru

You must set the "keep event history" In the System Manager "settings" to something longer than 30 days. I keep mine for a year just for reports like this.

-=Cheers=-
NG