I started to collect various useful DQL query snippets to make it easier for users to get started with DQL. Internally I did this on a notebook, but I also wanted to share this with the community and lete everybody contribute their snippets as well. So why not on an ongoing thread here.
One reply for each snippet and use case, with a little description and a screenshot.
Honeycomb representation of specific service’s health status
This code snippet creates a honeycomb visualization (like we had on old dashboards) of the service health status. It uses a) the service entity information and the existing davis problem events and combines them. You can filter services by tags (e.g. a dt.owner tag).
Split timeseries data into one record per interval (useful for data export)
Metric data sometimes needs to be displayed as one row per time interval for use in tables or for export to other systems. Dynatrace’s native format for timeseries events can complicate this process because the data values for the entire timeframe of a given timeseries are represented as an array within a single record.
We can overcome this challenge by using an iterative expression and applying some transformations to generate a separate record for each discrete interval. This data can then be shown in table format, or exported to CSV, where each row contains a single interval and its data value(s).
Hello Dynatrace universe! Sharing another tool to help you get started with hashtag#Dynatracehashtag#GRAIL. With this DQL Builder & Validator dashboard (LinkedIn) you can easily search for any available data objects (entities, cloud, logs, spans, problems, etc.) and have a standard hashtag#DQL ready with all available fields. If you would ask what fields are available for a data table in GRAIL, you can easily find that list or pick certain fields that you need. There’s also a custom DQL validator to check if the query is correct. Thanks to Sowmiya Venkiteswaran and Bradley Danyo for assisting with this dashboard! Grab your copy from Dynatrace Playground here, LinkedIn