SWQL to Bring Back API Monitor

narzsa

Hi All,

I'm struggling with trying to create a SWQL statement related to the inbuild API pollers

Can anyone give me a basic start?

I.e i want to do a quick count on the number of API pollers in use based upon the Microsoft Azure SQL Database found in API Poller Management

james.kluza

SELECT COUNT(ID) as [Number of Monitors], CASE WHEN api.templateID IS NULL THEN 'Custom' ELSE api.Template.DisplayName END AS [Template Name]
FROM  Orion.APIPoller.ApiPoller api
Group by api.Template.DisplayName, api.TemplateId

If you want to only return those that match the name in question, this would work:

**UPDATED**

SELECT COUNT(ID) as [Number of Monitors], api.Template.DisplayName as [Template Name]
FROM  Orion.APIPoller.ApiPoller api
WHERE templateID = 14
Group by api.Template.DisplayName