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

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.




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.

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

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”

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

Thanks, let me try..