I am trying to view all my synthetic monitors and their last response. Use case is to know out of my configured monitors how many are failing and what are those. Since the count is large ( currently 100+ and going to be much more) I am looking for ways to pull them via NRQL.
I have this query
FROM SyntheticRequest SELECT URL, monitorName, responseCode, responseStatus
This is helping, however, I came to know for a simple browser scenario, this table will have all the dependent url’s for configured synthetic url ( for eg: google.com will show up add urls, images downloaded urls etc) - which I do not need.
So I am kind of trying to join two tables to see if I can get something however, this isn’t helping either.
SELECT monitorName, type, URL, domain, responseCode, responseStatus FROM SyntheticCheck, SyntheticRequest
Seeking help to understand what could be the possible solution? Idea is to get a table which would display last poll time, monitor name , url, http code and response status ONLY for configured synthetics - not the dependents needed in case of simple browser or ping ones ( only one line for a monitor BTW).