How do I display the time when the device went down or down since or the last up time? I use the below SQL to get this report:
SELECT [NodeID],
[GroupStatus],
[Caption],
[IP_Address],
[DeviceType],
[LastSystemUpTimePollUtc],
'https://solarwinds1.lvccld.int:5000/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(Nodes.NodeID as varchar(256)) as 'DetailsURL'
FROM [SolarWindsOrion].[dbo].[Nodes]
where
[Status] = 2 and
[DeviceType] in
(Select [DeviceType] from [SolarWindsOrion].[dbo].[Nodes]
where
[DeviceType] = 'Domain Controller' or
[DeviceType] = 'DRAC' or
[DeviceType] = 'ESXihost' or
[DeviceType] = 'Firewall' or
[DeviceType] = 'Gates' or
[DeviceType] = 'GE Security' or
[DeviceType] = 'Inlet' or
[DeviceType] = 'IP Phone' or
[DeviceType] = 'iSCSI' or
[DeviceType] = 'LxNETES' or
[DeviceType] = 'PDU' or
[DeviceType] = 'People Counter' or
[DeviceType] = 'Router' or
[DeviceType] = 'SensorProbe' or
[DeviceType] = 'Server' or
[DeviceType] = 'Sorter' or
[DeviceType] = 'Storage' or
[DeviceType] = 'Switch' or
[DeviceType] = 'Time Clocks' or
[DeviceType] = 'UPS' or
[DeviceType] = 'Video Surveillance' or
[DeviceType] = 'WAP' or
[DeviceType] = 'Wireless Controller')
