I created API Pollers and I am not sure how to display these in a dashboard

Question

1 pulls an experation date

1 pulls a string to know if the backup is successful

1 pulls a table of how many critical, warning, and infomratioal alerts we have in another tool.

I see them in the Orion.APIPoller.ValueToMonitor table, But i am not seeing the any dates or numbers. Is there a specfic way to display this information in a dashboard?

SolarWindNoob · Answer

This works but I am wanting to put it on a dashboard not on a node details page. I didnt know this was a widget though

fop · Answer

Orion.APIPoller.ValueToMonitor is the base table for poller information. If you look at its declaration in SWQL Studio you can see that it links to both Orion.APIPoller.APIPoller and Orion.APIPoller.ValueToMonitor.Metrics and these are where the polling results are stored. This is a widget query I wrote for testing whether ingress or egress on a storage account is alerting and in need of investigation. It will show the status of those metrics as either up or down. SELECT ID, apiv.ApiPollerId , CONCAT('',apiv.DisplayName,'') as [Storage Metrics] , apiv.ApiPoller.Node.Caption , apiv.Metric , apiv.ApiPoller.DisplayName as [Name] , CASE WHEN apiv.status = 1 THEN CONCAT('

', 'Up', '

') ELSE CONCAT('

', 'Down', '

') END AS AccStatus FROM Orion.APIPoller.ValueToMonitor apiv WHERE apiv.ApiPoller.node.nodeid = ${NodeID} —replace this with an actual node ID for testing and NOT (apiv.DisplayName = 'Storage Account - Success Server Latency' or apiv.DisplayName = 'Storage Account - Success E2E Latency' or apiv.DisplayName = 'Storage Account - Availability' OR apiv.DisplayName = 'Storage Account - Total Trasactions') and apiv.apipoller.displayname like '%storage%' ORDER BY apiv.ApiPoller.Description DESC

Lofstrand · Answer

There is a widget for the node details page called "API Pollers" that show all pollers on that node.