Is there any way to join Call_Rec table to Hsplit/DSplit?

[cbobch]

Hi all,



I've got ODBC access to the CMS system and am pulling the tables into an offline SQL database for reporting/dashboarding.



I've actually got two questions I'm hoping to get answers to.



1: Is there anyway to join the call_rec table to the Hsplit/DSpilt tables without duplicating the split records? If I do a join on Split, ACD and row_date I'm going to get duplicated for however many agents are on the split/ACD combo that date.



2: Is there anyplacve in CMS that the threshold for Service level is stored? I expected to find it in root.Synonyms but it's not there. I'm guessing it's somewhere in the system since CMS needs it for its own reports.



Thanks for any assistance.

[shaikht]

Hi,

call_rec is not having interval data but dsplit is having day as interval. So not sure if you will get correct data by joining them

threshold will be part of exception tables like agex for agent exceptions and spex for split skill exceptions.Following exceptions can be adminitered on CMS:
Exceptions are gathered on agents, splits/skills, trunk groups, VDNs, vectors, and unusual events such as Malicious Call Trace and disruptions in data collection. You can administer exceptions and generate reports for VDNs and vectors if your company has purchased the Call Vectoring feature.

Also go thorugh following doc to get more details on database items and calculations used in CMS:

https://downloads.avaya.com/css/P8/documents/100170085

If still assitance is needed on customizations, please engage Avaya Professional team. Please be notified that it can be billable as they work on project basis.

I hope it helps.

[cbobch]

Hi,

call_rec is not having interval data but dsplit is having day as interval. So not sure if you will get correct data by joining them

threshold will be part of exception tables like agex for agent exceptions and spex for split skill exceptions.Following exceptions can be adminitered on CMS:
Exceptions are gathered on agents, splits/skills, trunk groups, VDNs, vectors, and unusual events such as Malicious Call Trace and disruptions in data collection. You can administer exceptions and generate reports for VDNs and vectors if your company has purchased the Call Vectoring feature.

Also go thorugh following doc to get more details on database items and calculations used in CMS:

https://downloads.avaya.com/css/P8/documents/100170085

If still assitance is needed on customizations, please engage Avaya Professional team. Please be notified that it can be billable as they work on project basis.

I hope it helps.

Thanks for the advice. The spex table is just what I was looking for.

In regards to joining the tables, that goes in accordance of what I thought. But that leads to the question how can I get a count of abandoned calls before it hits an agent and include it in a dashboard/report based on call_rec records grouped by day?