It seems like a relatively easy request. The client wants to know when their server hasn't rebooted as it is part of SQL cluster and some App servers depend on it. I've tried using the Last boot has Changed with the NOT logic but I can't seem to get it to trigger.Any ideas, I'm open to suggestions ?
Solved! Go to Solution.
Not sure how I'd do it in the GUI, but with a custom alert it'd be something like this
Set up a custom swql alert on nodes, the top box will be prepopulated and you can't change it, but in the lower box enter this
where nodes.nodeid in (
Select nodeid from orion.nodes where caption like 'sqlclusterserver%' -- filter on whatever makes sense to get all your sql servers
and daydiff(lastboot,getutcdate())>31 -- this is however many days are supposed to go between reboots
They reboot at 3am on Mondays. Thus far I've applied a system uptime template to the server. But it's thrown off when someone decides to manually reboot the cluster in the middle of the week.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.