topic DQL: fetch dt.synthetic.events or dt.synthetic.detailed_events does not show Browser Synthetic test data. Why? in DQL

DQL: fetch dt.synthetic.events or dt.synthetic.detailed_events does not show Browser Synthetic test data. Why?

chloe_bennett — Mon, 28 Apr 2025 19:27:24 GMT

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.

Re: DQL: fetch dt.synthetic.events or dt.synthetic.detailed_events does not show Browser Synthetic test data. Why?

marco_irmer — Mon, 28 Apr 2025 20:06:01 GMT

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 }

Re: DQL: fetch dt.synthetic.events or dt.synthetic.detailed_events does not show Browser Synthetic test data. Why?

p_devulapalli — Tue, 29 Apr 2025 05:35:21 GMT

@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