How Does one Alert on a Server that hasn't rebooted?

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

)

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

)

Thank you I'll give that I try. I appreciate the advice