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

[Selvaramakrishn]

 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.

[kayjayeff1]

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.

[Selvaramakrishn]

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

[kayjayeff1 · Accepted solution]

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

[Selvaramakrishn]

Thanks, let me try..