×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

Error Greeting Export/Report

Answered Question
Apr 21st, 2006
User Badges:

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!

Correct Answer by lindborg about 11 years 4 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
lindborg Fri, 04/21/2006 - 10:13
User Badges:
  • Cisco Employee,

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

Correct Answer
lindborg Fri, 04/21/2006 - 10:32
User Badges:
  • Cisco Employee,

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.

JoshMiller Fri, 04/21/2006 - 10:57
User Badges:

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

JoshMiller Fri, 04/21/2006 - 10:58
User Badges:

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

Actions

This Discussion