# How to split up Azure Service Bus queues based on Namespace split up table

**URL:** <https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539>\
**Category:** Cloud platforms\
**Tags:** azure, clouds\
**Created:** [March 4, 2025, 10:53am UTC](https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539 "2025-03-04T10:53:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Selvaramakrishn](https://avatars.discourse-cdn.com/v4/letter/s/82dd89/32.png) [@Selvaramakrishn](https://community.dynatrace.com/u/Selvaramakrishn)\
**Post date:** [March 4, 2025, 10:53am UTC](https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539/1 "2025-03-04T10:53:46Z")

</div>

I have tired but, I could get only split the active connections and success connections count split up. but there is no relationship metric between service bus queues and name space.

 ![Azure_query.png](https://global.discourse-cdn.com/dynatrace/original/3X/c/f/cfa5e1ec347f333c378c0ce593fd4a27814a3b93.png)  
 ![Queue_details_missing.png](https://global.discourse-cdn.com/dynatrace/original/1X/74339279a202775a04e2ebe65eca0d3dd1917d58.png)  
 ![screenshot_from_support.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/5/85b71b70b270a05c2101ff96d2fd4eb69affe7dd.png)  
 ![Response_from_support.png](https://global.discourse-cdn.com/dynatrace/original/2X/5/57b3a2b3cd2faeed8b513ce1d89c1398c7c02a56.png)

---

<div class="post-metadata">

**Author:** ![kayjayeff1](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kayjayeff1](https://community.dynatrace.com/u/kayjayeff1)\
**Post date:** [March 4, 2025, 11:36am UTC](https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539/2 "2025-03-04T11:36:53Z")

</div>

Have you explored doing this with DQL in notebooks or the new dashboards? I had similar issue with Azure Event Hubs which are similar to the Service Bus resources.

---

<div class="post-metadata">

**Author:** ![Selvaramakrishn](https://avatars.discourse-cdn.com/v4/letter/s/82dd89/32.png) [@Selvaramakrishn](https://community.dynatrace.com/u/Selvaramakrishn)\
**Post date:** [April 7, 2025, 1:20pm UTC](https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539/3 "2025-04-07T13:20:31Z")

</div>

Yeah, explored with Notebook but still it’s not resolved

---

<div class="post-metadata">

**Author:** ![kayjayeff1](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kayjayeff1](https://community.dynatrace.com/u/kayjayeff1)\
**Post date:** [April 7, 2025, 1:25pm UTC](https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539/4 "2025-04-07T13:25:05Z")

</div>

this is for Event Hubs, but since the 2 services are similar, I would think you’d be able to do something similar. Here is DQL that shows top event hubs with namespace by “Messages In”

```markup
timeseries sumOutMsgs=sum(dt.cloud.azure.event_hub.traffic.msg_out),sumInMsgs=sum(dt.cloud.azure.event_hub.traffic.msg_in), sumOutBytes=sum(dt.cloud.azure.event_hub.traffic.bytes_out), sumInBytes=sum(dt.cloud.azure.event_hub.traffic.bytes_in),
  union:true,
  filter: not(startswith(lower(azure.subscription), "abc123")),
  by: { azure.location , azure.event_hub_namespace.name, azure.resource.name}
| limit 1000
| fieldsAdd TotMsgsOut = arraysum(sumOutMsgs)
| fieldsAdd TotMsgsIn = arraySum(sumInMsgs)
| fieldsAdd TotMsgsDiff = TotMsgsIn - TotMsgsOut
| fields Location=azure.location, Namespace=azure.event_hub_namespace.name, EventHubs = azure.resource.name, TotMsgsIn, TotMsgsOut
| filter TotMsgsIn > 0 or TotMsgsOut > 0
| sort TotMsgsIn desc
| limit 10

```

---

<div class="post-metadata">

**Author:** ![Selvaramakrishn](https://avatars.discourse-cdn.com/v4/letter/s/82dd89/32.png) [@Selvaramakrishn](https://community.dynatrace.com/u/Selvaramakrishn)\
**Post date:** [April 7, 2025, 2:25pm UTC](https://community.dynatrace.com/t/how-to-split-up-azure-service-bus-queues-based-on-namespace-split-up-table/50539/5 "2025-04-07T14:25:59Z")

</div>

Thanks, let me try..
