cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2780
Views
5
Helpful
5
Replies

ICM DB query using script node id

santoshmhaske1
Level 1
Level 1

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

1 Accepted Solution

Accepted Solutions

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

View solution in original post

5 Replies 5

jessicas
Cisco Employee
Cisco Employee

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

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

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

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
Level 1
Level 1

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'