[cisco-voip] Unity Caller Input audit

[Anthony Holloway]

Here is one way to do a simple audit.  Please use this more of a starting
point than a completely polished solution.

First, you will need to install CUDLI from:

http://ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html

I highly recommend you read the help file and watch the training video.
 Jeff has a great way of explaining his tools and his humor is fun too.
 Boom!

Then you would need to use the query builder in CUDLI to run the following
query:

select
vw_subscriber.Alias,
vw_menuentry.TouchtoneKey,
vw_menuentry.TargetConversation,
vw_callhandler.DisplayName as CallHandler,
vw_alternatecontactnumber_subscriber.TransferNumber as AlternateNumber
from
vw_menuentry
left join
vw_subscriber on vw_menuentry.CallHandlerObjectId =
vw_subscriber.CallHandlerObjectId
left join
vw_alternatecontactnumber_subscriber on vw_menuentry.ObjectId =
vw_alternatecontactnumber_subscriber.MenuEntryObjectId
left join
vw_callhandler on vw_menuentry.TargetHandlerObjectId =
vw_callhandler.ObjectId
where
vw_subscriber.Alias <> '' and vw_subscriber.Alias <>
'undeliverablemessagesmailbox'
order by
vw_subscriber.Alias asc, vw_menuentry.TouchtoneKey asc


This will produce a menu tree for every subscriber whether or not they are
using caller input.

Example:  This user has * for sign-in, 0 for operator, 4 for going to some
alternate number (blacked out for privacy), and 5 for going to a call
handler, the rest are unused.

[image: Inline image 1]


On Tue, Jul 22, 2014 at 8:52 AM, Matthew Collins <mcollins at block.co.uk>
wrote:

>  Hi All,
>
>
>
> I’m trying to audit all of the caller input settings on Cisco Unity
> Connection 8.6.2.20000-76 local end user mail boxes. These details are
> not collected on the bulk export feature. Any thoughts?
>
>
>
> Regards
>
>
>
> Matthew
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140723/54942c44/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 15157 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140723/54942c44/attachment.png>