Data Explorer - Add management zone as column

[i_g]

Hi all, 

We have some reporting requirements based on cpu/mem/disk usage, all the standard items. Using Data explorer, I've created the tables I wanted and added them to a dashboard, however I've been asked to include the management zone as a separate column, as the query gets all hosts and we have very different allowances for management zones (dev, prod etc.). 

Is there a way to do this? I can restrict the table as a whole to a management zone from the dashboard menu, however I can't see a way to include management zones in the query itself. 

Many thanks! 

[AntonPineiro]

Hi,

I think it is possible if you have Grail enabled.

Best regards

[Ingrida]

hi @i_g ,

I can not answer your question, bat I may give you kinda different approach to do this by using entities search based filter for your query in data explorer. You can add filter for your table based on management zones entity belongs to like this:

builtin:host.cpu.usage:filter(in("dt.entity.host",entitySelector("type(~"HOST~"),mzName(~"PROD~")"))):splitBy("dt.entity.host"):...

This will filter all host, which belong to management Zone. named PROD.So you could add multiple tiles (one per stage) in your dashboard.

However, I would rather do what you mentioned above:  a single dashboard, which can be tailored using management zone filter.

I am not sure if adding management zones as a column makes much sense in general. Entities may belong to multiple management zones, depending segmentation you use in the future (f.y. all entities for prod, or all entities for all stages for certain application). 

We are using host custom metadata and tags to enrich host info with such information as stage already on oneagent  installation. It still does not allow to split by tag (as split is just by dimension and dimension for system metrics is host).

For Grail usage for it I home someone else can answer it 🙂 (in case you can use it)

Regards,

I.

[GosiaMurawska]

Hi @i_g 
Have you managed to solve the problem? It would be great if you shared the solution with the Community users 🙂

[i_g]

Hi @GosiaMurawska. I was unable to solve the problem using Dynatrace, however it was simple enough to add the management zone in through Excel (when the reports we need are exported from Dynatrace data explorer) to satisfy reporting requirements. 

Thank you for your reply @Ingrida and please accept my apologies for not responding. In this case we have management zones for each environment, as there is no overlap between them to suit our application, and deeper filtering through host groups and tags. This situation required an environment-wide reporting for corporate. 

[erh_inetum]

Hi @i_g ,

I can think of you could use dynamic filters.
First, you can create automatic tags to identy the hosts of each environment. And then configuring in the dashboard the dynamic "Tag key: Host" filters.
The result look like this:

Hope it helps.

Regards,

Elena.