28 Apr 2025 08:27 PM
So, I was trying to create items for a dashboard with DQL that displayed the status of my HTTP and Browser Tests. For my HTTP test, the data I get back is as expected. However, I noticed that the data from my Browser tests are not being retrieved at all for some reason. I am able to get the title of my Browser tests with "dt.entity.synthetic_test", but that doesn't give me any details on whether it was successful or not. My current DQL code looks like this:
fetch dt.synthetic.events
| join [ fetch dt.synthetic.detailed_events ], on: { left[event.id] == right[event.id] }
Can anyone help me get my Browser Test data including whether it was successful or not? I'd really appreciate the help.
28 Apr 2025 09:06 PM
This is a guess, but I suspect the reason you are not seeing these is because the synthetic browser data is not available in Grail yet (at least not GA). In our case we just used metrics. A sample query follows.
timeseries {availability = avg(dt.synthetic.browser.availability),
executions = count(dt.synthetic.browser.availability)
},
by: { dt.entity.synthetic_test }
29 Apr 2025 06:35 AM
@chloe_bennett I have something like below setup to report on the status by location in DQL. Hope it helps
timeseries {
availability_series = avg(dt.synthetic.browser.availability),
performance_series = avg(dt.synthetic.browser.event.duration)
},
by:{ dt.entity.synthetic_test,
dt.entity.synthetic_location},
filter: { matchesValue(entityAttr(dt.entity.synthetic_test, "tags"), "XYZ") }
| fieldsAdd monitor_name = entityAttr(dt.entity.synthetic_test, "entity.name")
| fieldsAdd location = entityAttr(dt.entity.synthetic_location, "entity.name")
| summarize { monitor_name = takeFirst(monitor_name),
location_name = takeFirst(location),
availability = avg(arrayAvg(availability_series)),
performance = avg(arrayAvg(performance_series))
}, by: {dt.entity.synthetic_test,dt.entity.synthetic_location}
| sort availability asc, performance desc
| fieldsRename `Monitor name` = monitor_name,
`Location` = location_name,
`Availability` = availability,
`Avg Event duration` = performance