Max Attempts in SIP Dialer

[Hina Jabeen]

I want to check number of Max attempt done by Dialer to connect a Phone, can yo u please guide which table exactly refer this?

w r using SIP Dialer and in configuration, we have configured 3 Max Attempts

Regards,

Hina     

[Gergely Szabo · Accepted solution]

Hi,

there are several ways:

1. (preferred): use the Dialer_Detail view of the HDS database, looking up the number and counting the rows, e.g.

SELECT COUNT(*) AS [attempts], Phone FROM _hds.dbo.Dialer_Detail GROUP BY Phone

You may want to use a WHERE clause to filter out rows by the CampaignID and/or Date etc.

2. (usable): try to figure out the name of the dialing list table in the BA database (on the Logger A server).

DL__ like DL_5001_5002 where 5001 would be the Campaign ID and 5002 the Query rule ID.

This table actually contains the number of calls, see CallsMadeToZone1 and/or CallsMadeToZone2 - some limitations apply.

G.

[Hina Jabeen]

Thank you very much .. can you please tell one more thing, how can we check that the number is attempted 3 times but didnt receive or answered by customer ?

[Gergely Szabo · Accepted solution]

You can tell by the CallResult code. The CallStatus would also be M (max attempts reached) or C (closed).

For the CallResult codes, see the "Outbound Option Guide for Cisco Unified Contact Center Enterprise and Hosted" for your particular ICM version.

G.

[Hina Jabeen]

I used like this

select * from t_Dialer_Detail where CallStatusZone1 = 'M'

select COUNT(*) AS [attempts], Phone from t_Dialer_Detail where CallStatusZone1 = 'M'
GROUP BY Phone