DQL Network Zones

[D_Miller]

Hello,

Hopefully a very quick simple question. Are Network Zones available in DQL?
We have our Google Clusters set to their own Network Zones and we are having to configure the Fallback setting. I was looking to write a DQL that would allow me see these settings rather than having to look at each Network Zone in turn vi the UI.

[Etienne1]

Hello,

Yes, network zones are available in DQL

[D_Miller]

What's the name of the DQL table?

[Etienne1]

Hello,

Here's how you can do it in DQL : 

timeseries usage = avg(dt.host.cpu.usage, filter: { in(dt.entity.host, classicEntitySelector("type(host),networkZone(\"stlo\")")) }), by: { dt.entity.host }
| sort arrayAvg(usage) desc
| fieldsAdd entityName(dt.entity.host)

[D_Miller]

Thank you

But I'm looking to query the values of the properties of a Network Zone. e.g. Fallback Mode

[p_devulapalli]

@D_Miller Not sure you would be able to get fallback mode via DQL,  it is available via API though 

https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-api/environment-api/network-...