# What AWS AZ a Pod is in?

**URL:** <https://community.dynatrace.com/t/what-aws-az-a-pod-is-in/51947>\
**Category:** Cloud platforms\
**Tags:** dql, aws, dynatrace-managed\
**Created:** [June 4, 2025, 7:20pm UTC](https://community.dynatrace.com/t/what-aws-az-a-pod-is-in/51947 "2025-06-04T19:20:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shakib](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@shakib](https://community.dynatrace.com/u/shakib)\
**Post date:** [June 4, 2025, 7:20pm UTC](https://community.dynatrace.com/t/what-aws-az-a-pod-is-in/51947/1 "2025-06-04T19:20:14Z")

</div>

I’m trying to create a dashboard or a DQL query that gives me the AZ all of my pods are in. I see that in the EC2 Node metadata I can see what AZ those nodes are in, and of course I can see what AZ the pods running on that node are in, but I want the information in one single view with all of the pods (or filterable list).&nbsp;  
Anyone know how I can achieve this with DQL or a dashboard query?

---

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [June 5, 2025, 4:43am UTC](https://community.dynatrace.com/t/what-aws-az-a-pod-is-in/51947/2 "2025-06-05T04:43:19Z")

</div>

Hi&nbsp;[@shakib](https://community.dynatrace.com/user/47920)&nbsp;,

May be you can try this

```markup
fetch dt.entity.cloud_application_instance
| fieldsAdd nodeid=runs_on[dt.entity.kubernetes_node]
| lookup [fetch dt.entity.kubernetes_node| fields id, node.id = id, node.name = entity.name,cluster.id = belongs_to[dt.entity.host]], sourceField: nodeid, lookupField: node.id 
| fieldsRemove nodeid, lookup.id, lookup.node.id
| fieldsRename host_id=lookup.cluster.id, hostname=lookup.node.name
| lookup [fetch dt.entity.host | fields id,Az_id = belongs_to[dt.entity.aws_availability_zone]], sourceField:host_id,lookupField:id
| fieldsRename az_id=lookup.Az_id, hostid=lookup.id
| lookup [fetch dt.entity.aws_availability_zone], sourceField:az_id, lookupField:id
| fieldsRename PodName=entity.name, availability_zone=lookup.entity.name
| fieldsKeep PodName, hostname, availability_zone

```

You might get a result like this.

 ![Screenshot 2025-06-04 at 11.42.00 PM.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/0/0026cb46d8dd847c44725e0f7ba621865c244446.png)

BR