I need to generate an alert for nodes have an uptime of over 300 days. Unfortunately, the LastBoot variable on the Alert Manager requires a specific date. So, I was wondering if any of you have figured this out. Thanks in advance
You can setup an advanced alert and on the Trigger Condition tab, select Custom SQL Alert and Trigger query of Node. Then insert the below SQL in the bottom box:
WHERE Nodes.LastBoot < Getdate()-300
You can set the rest of the alert parameters as desired for trigger actions and so on.
When you say nodes, what types of nodes are they? If they are Linux and Unix nodes - you can directly create a Linux Unix Script monitor for uptime and create a threshold condition accordingly.
as a caution, all nodes have their sysUptime wrap after ~497 days (it's a 32-bit centisecond counter)
