I would like to create a report with the following fields Called Party Number, Call Status, Calling Party Number, Call Origin Date Time, Date Call Disconnect Time. The report would have the fields of the screenshot, below.
+1
I would love to be able to generate a report that shows this information. This is a large reason why we started looking into the SolarWinds VNQM module.
There is several options to create similar report as described:
1) to use report Call in Last 24 hours - similar report but the status which is presented by Origin/Destination Cause
2) to create report in report writer and customize it based on VoIP Call Details - again the call status is presented by cause values
3) to create custom SQL (Advanced SQL) in report writer where it is possible to write any SQL query and transform Origin/Destination Cause Call status (requires SQL and DB schema knowledge)
4) to create custom SWQL resource and show the calls in e.g. summary page view (requires SWQL and SWIS schema knowledge)
note: the coloring would not be applied in these cases described above
What is the table in the database that is related to Call Status.
Thank you! I believe the report writer is all I was looking for.
you can use DB view called VoipCallDetails (available from 4.0), the columns OrigCause_value, DestCause_value need to be combined to evaluate success or fail (default success cause values can be found in VNQM voip settings under Successful call termination codes)
Hi would post an example SQL that makes the junction of these two columns so you can create status. And most of the fields in the report, I'm new in customizing reports with SQL.
Thank you.
Hi all,
We want to create about failed "calls termination Cause" . How do i find related table in the database?
Hello All, Hope this help,
i'm using that on VNQM 4.2.2, you can add as more as you want of conditions you need
###########################################################################
SELECT TOP 10000 VoipCallDetails.CallID AS Call_ID,
VoipCallDetails.OrigDeviceName AS Origin_Device_Name,
VoipCallDetails.OrigCCMRegionName AS Origin_Region_Name,
VoipCallDetails.DestDeviceName AS Destination_Device_Name,
VoipCallDetails.DestCCMRegionName AS Destination_Region_Name,
VoipCallDetails.Duration AS Duration,
CASE [OrigCause_value]
WHEN 0 THEN 'No error'
WHEN 1 THEN 'Unallocated (unassigned) number'
WHEN 16 THEN 'Normal call clearing'
WHEN 17 THEN 'User busy'
WHEN 18 THEN 'No user responding'
WHEN 19 THEN 'No answer from user (user alerted)'
WHEN 27 THEN 'Destination out of order'
WHEN 31 THEN 'Normal, unspecified'
WHEN 41 THEN 'Temporary failure'
WHEN 47 THEN 'Resource unavailable, unspecified'
WHEN 53 THEN 'Service operation violated'
WHEN 102 THEN 'Call terminated when timer expired; a recovery routine executed to recover from the error'
WHEN 393216 THEN 'Call split (was 126), This code applies when a call terminates during a transfer operation because it was split off and terminated (was not part of the final transferred call)'
WHEN 1191182367 THEN 'CCM_SIP_487_REQUEST_TERMINATED'
END AS Origine_Cause_Value
,
CASE [DestCause_value]
END AS Destination_Cause_Value
FROM
VoipCallDetails
########################################################
