Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

ICM DB query using script node id

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

Re: ICM DB query using script node id

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

5 REPLIES
Cisco Employee

Re: ICM DB query using script node id

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

Community Member

Re: ICM DB query using script node id

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

Re: ICM DB query using script node id

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

Community Member

Hello Santosh,

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.

Community Member

Re: ICM DB query using script node id

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'

1514
Views
5
Helpful
5
Replies
CreatePlease to create content