# Data Explorer - Add management zone as column **URL:** \ **Category:** Dashboarding\ **Tags:** data-explorer\ **Created:** [March 18, 2024, 2:52am UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707 "2024-03-18T02:52:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![i\_g](https://avatars.discourse-cdn.com/v4/letter/i/82dd89/32.png) [@i\_g](https://community.dynatrace.com/u/i_g)\ **Post date:** [March 18, 2024, 2:52am UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707/1 "2024-03-18T02:52:11Z")
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! ---
**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\ **Post date:** [March 18, 2024, 7:41am UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707/2 "2024-03-18T07:41:28Z")
Hi, I think it is possible if you have Grail enabled. Best regards ---
**Author:** ![Ingrida](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ingrida/32/13926_2.png) [@Ingrida](https://community.dynatrace.com/u/Ingrida)\ **Post date:** [March 18, 2024, 3:56pm UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707/3 "2024-03-18T15:56:32Z")
hi [@i\_g](https://community.dynatrace.com/user/73479) , 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. ---
**Author:** ![Gosia\_Murawska](https://avatars.discourse-cdn.com/v4/letter/g/2bfe46/32.png) [@Gosia\_Murawska](https://community.dynatrace.com/u/Gosia_Murawska)\ **Post date:** [August 13, 2024, 1:15pm UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707/4 "2024-08-13T13:15:39Z")
Hi [@i\_g](https://community.dynatrace.com/user/73479)  Have you managed to solve the problem? It would be great if you shared the solution with the Community users 🙂 ---
**Author:** ![i\_g](https://avatars.discourse-cdn.com/v4/letter/i/82dd89/32.png) [@i\_g](https://community.dynatrace.com/u/i_g)\ **Post date:** [August 13, 2024, 11:36pm UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707/5 "2024-08-13T23:36:50Z")
Hi [@GosiaMurawska](https://community.dynatrace.com/user/77704). 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](https://community.dynatrace.com/user/41084) 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. ---
**Author:** ![erh\_inetum](https://avatars.discourse-cdn.com/v4/letter/e/48db29/32.png) [@erh\_inetum](https://community.dynatrace.com/u/erh_inetum)\ **Post date:** [August 14, 2024, 2:11pm UTC](https://community.dynatrace.com/t/data-explorer-add-management-zone-as-column/44707/6 "2024-08-14T14:11:40Z")
Hi [@i\_g](https://community.dynatrace.com/user/73479) , 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: ![erh_inetum_0-1723644596061.png](https://global.discourse-cdn.com/dynatrace/original/3X/7/0/703e5a551ed0144cb54da1ade5971aaa0b410fe7.png) ![erh_inetum_1-1723644641632.png](https://global.discourse-cdn.com/dynatrace/original/2X/e/ef88a6b8f75234a837d8a4901bafe163a8bea5fd.png) Hope it helps. Regards, Elena.