Report to find out servers not rebooted for 'n' number of days

Dhyanesh,

If these devices are using SNMP, you could try a report based on system up time (1.3.6.1.2.1.1.3).

Hello,

You can try this, add the sysUptime OID in UnDP and monitor it for the group of devices you want, you can further take a report of the UnDP and filter for the ones with time less than 30 days.

Not sure how far this would work, scanning system Uptime would be the best guess.

Thanks,

Malcolm.

For windows servers, I would look at the LastBoot setting.   This should also be present for all SNMP devices.  If not, then I would resort to the UnDP.

Just be aware that on SNMP monitored devices, if the agent was restarted - the last boot will reflect the time when the agent was started.

The code is same as Node DOwn with duration code with changing the eventtime to lastboot.  I added a condition for just windows servers; this can be changed based on need.

I've had clients set up several of these.  One for Networking, one for Servers, etc.

SELECT

-- Node

n.Caption AS [Node Name]

,DetailsUrl AS [_LinkFor_Node Name]

,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name]

-- IP and availability

,n.IP_Address as IP_Address

,'/Orion/DetachResource.aspx?ViewID=2123&ResourceID=21222&NetObject=N:'+tostring(n.nodeid) as [_LinkFor_IP_Address]

,'/Orion/Images/SubViewIcons/VitalStats03.png' as [_IconFor_IP_Address]

--edit

--,'Edit' AS [Edit]

--, '/Orion/Nodes/NodeProperties.aspx?Nodes=' + ToString(n.NodeID) AS [_LinkFor_Edit]

--,'/Orion/images/nodemgmt_art/icons/icon_edit.gif' as [_IconFor_Edit]

--,n.CustomProperties.City as [City]

,concat(SUBSTRING(tostring(n.LastBoot),1,4),SUBSTRING(tostring(n.LastBoot),5,2)

,SUBSTRING(tostring(tolocal(n.LastBoot)),12,8)) as Downtime

,CONCAT(HOURDIFF(tolocal(n.LastBoot),getdate())/24,' Day(s) ',

        HOURDIFF(tolocal(n.LastBoot),getdate())-(HOURDIFF(tolocal(n.LastBoot),getdate())/24)*24,'h ',

        MINUTEDIFF(tolocal(n.LastBoot),getdate())-(MINUTEDIFF(tolocal(n.LastBoot),getdate())/60)*60,'m') AS [LastBoot]

FROM Orion.Nodes n

WHERE STATUS = 1 and n.Vendor like 'Window%'

--and n.caption like '%${SEARCH_STRING}%' or n.IP_Address like '%${SEARCH_STRING}%'

ORDER BY MINUTEDIFF(tolocal(n.LastBoot),getdate())  desc

Thanks

Amit

Lets get back on track.

1)    SNMP is the widest implemented option that allows for the same monitoring to be used - which is why we chose it.

2)   Windows LastBoot, from memory, is a WMI variable requiring a different monitor arrangement for Windows, the fun and joy of WMI, and and non windows servers / devices would end up with SNMP based one anyway..

3)   Yes - SNMP is not perfect, it is a 32 bit counter so will rollover when it reaches the upper limit.

4)   We are talking about IPMONITOR, not ORION. IPMONITOR does not monitor uptime via any OID or WMI by default.

Our solution was the simplest to be able implement across the board, and as IPMONITOR is primarily SNMP based, seemed like the easiest and most practical option.