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

SQL query Report for lastboot data and convert to days/hours since last boot (Server list from Query does not match Company master Server List)

Hi Everyone,

I am running into an issue where a query I am putting together to pull lastboot data from Server Nodes and convert the date into an "uptime" the list of servers being returned does not match our master server list (off by about 100 servers).

Our master server list is using the following which produces the correct amount of servers expected:

The below query I am trying to match this by pulling from NodesData_Category = 2, but the list I am getting back is a bit short:

SELECT

Caption
,Ip_Address
,MachineType
,LastBoot
,Owner
,OwnerName
,NodesData_Category
,DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp
,CONVERT(VARCHAR(40), DATEDIFF(minute, Nodes.LastBoot, GETDATE())/(24*60))
+ ' days, '
+ CONVERT(VARCHAR(40), DATEDIFF(minute, Nodes.LastBoot, GETDATE())%(24*60)/60)
+ ' hours, and '
+ CONVERT(VARCHAR(40), DATEDIFF(minute, Nodes.LastBoot, GETDATE())%60)
+ ' minutes.' AS 'Time Up'

FROM [Nodes]
where NodesData_Category = 2

ORDER BY Caption ASC

Is there an easier/better way to query from the same location as the dynamic query pictured using SQL? Any advice would be greatly appreciated.

Find more posts tagged with

Accepted answers

All comments

Seashore

That SHOULD give you the same amount of devices

adam.beedell

Looks the same
Should really use SWQL for this sort of thing
If the results between the two queries are the same, but the last of servers doesnt match the CMDB list, that's pretty normal, and you'd need to compare the lists, add some stuff, maybe recategorize some other stuff, sometimes remove some stuff too.

antcooper

Thanks for the info, I am going to dig deeper into why the two list of servers is different.

Looking at the SWQL functions available HourDiff will work fine for the amount of hours.

Having trouble using a SWQL function to calculate the date and add text of 'days' 'hours, and' 'minutes' Any suggestions for best use case here?