ICM DB query using script node id

[santoshmhaske1]

Hi Guys,

We want to run a query in ICM HDS database using script node id which i got from script monitoring.

This we require to check the call abandoned at node level.

Kindly share the table  and query details.

We are having ICM 7.5

Thanks & Regards,

Santosh Mhaske

[jessicas]

If you know the details of the call. You can query the Route_Call_Detail table and sort by the scriptID and FinalObjectID. FinalObjectID is where the call ended. The details of the tables is also in the DB schema guide. Below is the link to ICM 7.5.x database schema guide:

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_7_5/reference/guide/icm75schema.pdf

[santoshmhaske1]

Hi Jesica,

Thanks for reply. Actualy we want to check the data at node level.

Each node has some specific id based on that we want to check it in DB.

Santosh

[david.macias · Accepted solution]

You might want to take a step back and look at your script design.  You can use call types for most of the reporting you're looking to do.  You just need to find logical break points between the IVR and ICM.

david

[fabien_damien]

Hello Santosh,

were you able to find where in the database those Node IDs can be found?

i`m looking to map node ID to its name.

regards.

[Alok Mohanty]

Rt click on ur script properties and check the Author Name and DateTime of change

query

======

Select * from Script

where Author like '%XXX%'

and DateTime between '12/17/2010 10:00' and '12/17/2010 10:05'