CMS Report queries

[srini17]

Hi,
I am looking for the following.
1) The details of CMS/Avaya ACD database objects/tables which store the 'Real-Time' transaction data for an Agent call.
1) CMS/Avaya ACD database filed mapping for CMS reports namely "Split/Skill Summary Interval Report - Service Desk".
2) CMS/Avaya ACD database filed mapping for CMS reports namely "Split/Skill Weekly Report - Service Desk"

Let me know if you have info or advise.

[shaikht]

Hi,

Real time reports for agent have data in cagent table. You cannot query on real time data tables.

Other two reports looks to be designer report. Click on design mode and edit the reports to get queries and item used in it.

I hope it helps.

Thanks
Tosif