After doing some reading, I figured collection was the term but perhaps not. There are the articles that gives a query to check SNMP isn't collecting/storing data but what about any node? What my biggest problem is how do I make an alert for it? I can create a report running SQL, but if things are fine then blank reports will come out. And why does Custom SWQL or SQL Alert options pre-set a SELECT? It would be nice to be able to input a raw query.
This is the query that I'd like to (if there's not a better one) use for an alert:
Select nodesdata.caption as Name
From NodesData
Inner Join NodesStatistics on Nodesdata.nodeid=NodesStatistics.nodeid
Where NodesStatistics.LastSystemuptimepollUTC < dateadd(hour,-4,getutcdate())
What have found is that a node is polling, shows data on the Vital Stats page. But when you click on it (Memory or CPU) it reports No Data Available. These came to cause alerts not to fire. Which is why I'm looking to have an alert for a node that doesn't have data.
Thanks for your help and assistance.
