04-21-2006 10:06 AM - edited 03-18-2019 05:49 PM
Hello - Are there any tools that will allow me to run a report to show where the error greeting is going for all subscribers/call handlers? This Unity supports multiple sites and I need to review where the Error greeting is going for each subscriber and verify it is going to the correct site.
Thanks!
Solved! Go to Solution.
04-21-2006 10:32 AM
Actually - here's a simple query that will get you most of what you want. Just open up Data Link Explorer (you'll find this in Tools Depot on your desktop) and select View | Query Builder. In the query builder text enter this:
SELECT vw_CallHandler.Alias AS "Destination Call Handler Alias", vw_MessagingRule.ParentAlias, vw_MessagingRule.ConversationName
FROM vw_CallHandler INNER JOIN vw_MessagingRule
ON vw_CallHandler.CallHandlerObjectID = vw_MessagingRule.DestinationObjectID
WHERE vw_MessagingRule.Alias='error' AND vw_MessagingRule.DestinationObjectIDType=3
it will output the results under it in the table - you can right click on it and choose to export the entire table to CSV - it'll look something like this:
Destination Call Handler Alias,ParentAlias,ConversationName
openinggreetingch,openinggreetingch,PHTransfer
openinggreetingch,goodbyech,PHTransfer
openinggreetingch,ch_defaultadmintemplate,PHTransfer
openinggreetingch,operatorch,PHTransfer
openinggreetingch,ch_TGuy3,PHTransfer
openinggreetingch,ch_TGuy4,PHTransfer
What that's showing is that the error greeting for, say, my subscriber with an alias of TGuy4 is set to transfer to the openinggreeting. All my guys are defaulted to going to the opening greeting but you'll see different handler aliases in there.
This shows all handlers, not just ones tied to subscribers... the subscriber handlers will start with "ch_" in their alias so they should be easy to spot.
04-21-2006 10:13 AM
No, there's no reporting tool that will dump that info out for you into a CSV or the like. You can set the error greeting for groups of users in BulkEdit, though.
You can dump out the raw info reasonably easily from SQL but it's a little hard to decipher since the after greeting action consists of an action value, conversation name and target objectId (unique identifier) in the case of sending the caller to a call handler for instance. It could be done, though...
04-21-2006 10:32 AM
Actually - here's a simple query that will get you most of what you want. Just open up Data Link Explorer (you'll find this in Tools Depot on your desktop) and select View | Query Builder. In the query builder text enter this:
SELECT vw_CallHandler.Alias AS "Destination Call Handler Alias", vw_MessagingRule.ParentAlias, vw_MessagingRule.ConversationName
FROM vw_CallHandler INNER JOIN vw_MessagingRule
ON vw_CallHandler.CallHandlerObjectID = vw_MessagingRule.DestinationObjectID
WHERE vw_MessagingRule.Alias='error' AND vw_MessagingRule.DestinationObjectIDType=3
it will output the results under it in the table - you can right click on it and choose to export the entire table to CSV - it'll look something like this:
Destination Call Handler Alias,ParentAlias,ConversationName
openinggreetingch,openinggreetingch,PHTransfer
openinggreetingch,goodbyech,PHTransfer
openinggreetingch,ch_defaultadmintemplate,PHTransfer
openinggreetingch,operatorch,PHTransfer
openinggreetingch,ch_TGuy3,PHTransfer
openinggreetingch,ch_TGuy4,PHTransfer
What that's showing is that the error greeting for, say, my subscriber with an alias of TGuy4 is set to transfer to the openinggreeting. All my guys are defaulted to going to the opening greeting but you'll see different handler aliases in there.
This shows all handlers, not just ones tied to subscribers... the subscriber handlers will start with "ch_" in their alias so they should be easy to spot.
04-21-2006 10:57 AM
Hi Jeff - Thanks for your post!
If I understand correctly, I should be looking in the CallHandler db, and specifically the AfterMessageObjectID. Will this correlate to a CallHandlerObjectID in the same table?
Thanks again for your assistance on this!
Josh
04-21-2006 10:58 AM
Nevermind last post, you beat me to it. Thanks a ton!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide