DQL
Questions about Dynatrace Query Language
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is there a way to query Settings via DQL?

36Krazyfists
Advisor

For example, I'd like to get a list of all of our configured Davis Anomaly Detectors that contain the word "Mail" in them so that I can easily pass on a report of what alerts are setup for our Email (Exchange) team.

I don't see a way to do this with the current fetch commands, as they only allow you to query the Davis Events and Problem tables which are for alerts/events that have triggered.  I want a list of what's configured that could possibly trigger.

And really, that's just one example.  In general, I'd like to be able to query other configuration settings via DQL so that I can easily see how things are set without having to go do an API call to the Settings API via PostMan or Swagger every time.

3 REPLIES 3

michiel_otten
Champion

Hi,

I don't believe this is possible. You should be able to do it via the custom Javascript code in a notebook though. 
I've not tested it but it should work. More info here.

KR.
Michiel

#Performance matter!

Julius_Loman
DynaMight Legend
DynaMight Legend

@36Krazyfists configuration is not exposed via DQL in Grail. But it's accessible through platform API or TypeScript SDK - for Davis Anomaly Detectors in particular this SDK https://developer.dynatrace.com/develop/sdks/client-davis-analyzers/ 

So you can easily set up a workflow in Dynatrace , query the Davis Analyzers and send out a report from the workflow.  See the JavaScript code examples in the SDK docs for examples how to use it.

Dynatrace Ambassador | Alanata a.s., Slovakia, Dynatrace Master Partner

Joseph_Hobbs
Guide

If you haven't done so already, check out the Dynatrace CLI (dtctl).  It makes pulling data from the tenant way easier than having to fall back to Swagger or Postman.  The Settings API is available via dtctl, both for read and write.

Featured Posts