Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SWQL for PRI trunk utilization help

cyr0nk0r

<code>

-- Good query finding MAX value

select n.Caption,

vge.IfName,

max(vges.AvgVoiceIncomingUtilization + vges.AvgVoiceOutgoingUtilization) Max_Incoming_Plus_Outgoing

from VoipGatewayEndpointStats vges,

VoipGatewayEndpoints vge,

VoipGateways vg,

Nodes n

where vges.VoipGatewayEndpointID = vge.VoipGatewayEndpointID

and vge.VoipGatewayID = vg.VoipGatewayID

and vg.NodeID = n.NodeID

and vges.RecordTimeUtc > DATEADD(HOUR, -1, GETUTCDATE())

group by n.Caption, vge.IfName

order by n.Caption, vge.IfName

</code>

We have this query that is pure SQL to get max concurrent calls for all PRI's for a given time period. I'm attempting to get something similar to this built in module but get call counts rather than percent usage. (screen shot attached)

Was hoping someone could help provide the SWQL that this built in module is running to get the data that we can then modify to get call counts expressed as a number rather than a percentage.