cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

chloe_bennett
Newcomer

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.

2 REPLIES 2

marco_irmer
Champion

 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 }

p_devulapalli
Leader

@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

 

Phani Devulapalli

Featured Posts