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

Error Greeting Export/Report

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Error Greeting Export/Report

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.

4 REPLIES
Cisco Employee

Re: Error Greeting Export/Report

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...

Cisco Employee

Re: Error Greeting Export/Report

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.

Community Member

Re: Error Greeting Export/Report

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

Community Member

Re: Error Greeting Export/Report

Nevermind last post, you beat me to it. Thanks a ton!

135
Views
0
Helpful
4
Replies
CreatePlease to create content