CUIC reporting in UCCE 9.0(1)

[kballintern]

   Is there a way to identify all the details of a unique call? Is there a report for this? ie. the exact time the call was placed, the total sequence the call went through or transferes?

[Gergely Szabo]

Hi,

no stock report I am aware of.

You might want to dig deep using simple SQL commands. After all, (almost) everything is recorded by ICM and kept in a database.

The schema guides are here:

http://www.cisco.com/en/US/products/sw/custcosw/ps1844/prod_technical_reference_list.html

Start with something simple. Like

SELECT * FROM _hds.dbo.Termination_Call_Detail tcd WHERE tcd.DateTime > '2013-06-20 6:00:00' AND tcd.ANI LIKE '%' + '9723033001'

This will return all the rows about all calls coming from 9723033001 since 6:00 AM today.

G.