Also know that PM is aware of this.
Any updates on this?
we're using APM to monitor the "System Up Time" counter under the System category. That matches what's shown in the SystemInfo command prompt info. Then we set up the alerts to only using the default node reboot alert with vendor is not windows and set up a new alert that if vendor is windows and System Up Time is less than 600 seconds to send an alert that it rebooted. This has done the trick, but it requires a customer buy APM, which is not cool. We needed APM anyway.
following up on the perfmon system uptime counter i had a dba built out this report logic that converts the seconds to days and hours
Application_Name is a custom property we use and could be omitted or replaced with a custom field of your own. sort could also be changed to sort by longest running box etc.
convert(varchar,convert(int,APM_ResponseTime.StatisticData)/86400) + ' days ' + convert(varchar,(convert(int,APM_ResponseTime.StatisticData) % 86400 / 3600)) + ' hours ' + convert(varchar(2), ((convert(int,APM_ResponseTime.StatisticData) % 86400) % 3600) / 60) + ' minutes' AS Uptime
Nodes.Application_Name AS Application_Name,
Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
RT.ComponentID as ComponentID,
max(RT.[DateTime]) AS LastCheck
inner join APM_AlertsAndReportsData ARD ON (Nodes.NodeID = ARD.NodeId)
inner join APM_ResponseTime RT ON (ARD.ComponentId = RT.ComponentID)
where ARD.ComponentName = 'System: Uptime'
group by Nodes.Application_Name,Nodes.NodeID,Nodes.Caption, RT.ComponentID) x
inner join APM_ResponseTime on APM_ResponseTime.[DateTime] = x.LastCheck and APM_ResponseTime.ComponentId = x.ComponentID
order by 1 asc, 3 asc