cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

VNQM - Call details (swql)

The VoIP call details screen has a lot of options.  But a client didn't all those options or the always used the same options.   If that's the case, it's easy enough to write a script for it to quickly get the needed information.

This is the result of the default VoIP search.

cscoengineer_0-1586815329918.png

 

The custom script gives us just the fields we are interested in.  A no-frills approach.

cscoengineer_1-1586815401447.png

 

SELECT TOP 500
CallingPartyNumber as [Call Origin]
,DetailsUrl as [_Linkfor_Call Origin]
,OrigCCMRegionName as [Origin Region]
,FinalCalledPartyNumber as [Call Dest]
,DestCCMRegionName as [Dest Region]
,Duration
,CallSuccess as [Call Status]
,OrigMOS
,DestMOS
,tolocal(ObservationTimestamp) as [Start Time]FROM Orion.IpSla.VoipCallDetails cd
order by ObservationTimestamp desc

Thank you
Amit

email: ashah@loop1.com

Loop1 Systems - SolarWinds Training and Professional Services

 

Labels (2)
Version history
Revision #:
1 of 1
Last update:
‎04-13-2020 05:06 PM
Updated by: