Finding a call that ran through a specific script

[t-masterson]

I have an Admin TOD script that for some reason has a single call, supposedly route to a closed msg during the middle of open hours.  Is there a SQL query or a tool I can use to find that call?  I'm guessing it would involve the name of that script and the day.  Thanks much for y'alls help!

Travis

[Shalid Kurunnan Chalil]

Hi ,

you will be able to find out which is the routing script executed for the specific call. and from the routing script you can identify the admin script which used for TOD.

1. in order to find the routing script, pull the records from the TCD for specific call.

2. take the RouterCallKeyDay and RouterCallKey and query it from RCD.

3. note down the scriptID

4. Run below query to find out the masterscriptID

    select * from Script where ScriptID ='xxxx'

5. note down the MasterSCriptID.

6. run the below query to find out the actual routing script.

   select * from Master_Script where MasterScriptID ='yyyy'

7. you will be getting Enterprise name of the routing script.

Hope above will serve your purpose.

Note: rate the post, if you find it usefull.

Regards,

Shalid K.C

[t-masterson]

But that is the problem, I don't know the call information to pull it.  I only know it went through the closed script.  I need to query what calls went through that script.

[Shalid Kurunnan Chalil]

hi ,

I think then you can go in reverse order.

I am not sure, i didnt try this. but I will check this today and let you know.

1. get the master script ID from Masterscript table based onenterprise name

2. find out all scipt Id from script table based on masterscriptID

3. run the RCD table which having above scriptID .

rate the post, if you find it usefull.

Regards,

Shalid K.C

[sandeep chauhan]

Hello,

You can find the scripts through which call ran via the below 3 queries.

1. 1. select
      
   2. select * from Script where ScriptID ='ABCD'   <<<<<<< Pick this value from the 1st query
      
   3. select * from Master_Script where MasterScriptID = 'EFGH'   <<<<<<< Pick this value from 2nd Query
      

   ScriptID,* fromRoute_Call_Detail
   
   

Script type in the 3rd query will give you if the script is routing script pr an admin script.

1=  routing script

2=  admin script

Rate if satisfied :)

Regards

Sandeep