How to collect the TCD and RCD from AW server in UCCE

[vinayakumarKB38924]

Hello Experts,

Could you please share me how can collect TCD and RCD from AW server

[Ramamoorthy Shanmugam]

Hi Vinay,

Please Microsoft SQL Server Management Studio and connect AWD server as server name and password. and select awdb or hds database and execute the below query.

select * from Route_Call_Detail where DateTime between '2021-12-29 00:00:00' and '2021-12-29 23:59:59' order by DateTime desc

select * from Termination_Call_Detail where DateTime between '2021-12-29 00:00:00' and '2021-12-29 23:59:59' order by DateTime desc

Ram.S

[vinayakumarKB38924]

Thank you so much

[bill.king1]

If you're running any type of ongoing reports on these tables (not just a one off to troubleshoot), you'll want to copy these off to another server, per the Cisco guidance.
"Because this table grows larger in size, running custom reporting queries against it while it is on the HDS can degrade performance. To optimize performance, extract data from the HDS into your custom database. The custom database must be on a separate server and ensure that other Unified ICM or Unified CC Enterprise components do not use it. Use only DBDateTime (date and time of the record when written to the HDS database) to perform the extraction. You can index the table on the custom database according to the custom reporting needs."