cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

354
Views
0
Helpful
2
Replies
Participant

Unity - Did user record a Personal Greeting?

How can I tell if a voicemail box is using the system default greeting, or if a user has recorded a personal greeting?

I have tried the User Data Dump tool, but the "GREETING_STANDARD_SOURCE" doesn't track with the actual recording status.

Unity Connection will use the system default greeting until a user has recorded a personal greeting. User Data Dump will give a status of "1" if the Greetings - Callers Hear - My Personal Recording is enabled, even if they have not recorded an actual greeting yet.

Is there a SQL database entry that will show if there is a greeting recorded?

 

This is Unity Connection 10.5.1 and User Data Dump 8.0.53

 

 

Everyone's tags (3)
2 REPLIES 2
Highlighted
Enthusiast

Re: Unity - Did user record a Personal Greeting?

Are you looking for a tool that gives you a list or just to check an individual mailbox? I would go to ciscounitytools.com and grab audio text manager. There may also be sample code that you can use there.
Participant

Re: Unity - Did user record a Personal Greeting?

I spent some time digging through the CUC database (thank you Jeff Lindborg and CUDLI). It looks like a filename is listed in the streamfile column of the vw_GreetingStreamFile table if a user has recorded a greeting. Unfortunately, vw_GreetingStreamFile lists all of the greetings, not just user mailboxes, so you have to cross reference to the vw_CallHandler table. User mailboxes are considered 'primary' call handlers, system call handlers are not.

If I did everything right, this query will list all user mailboxes that have a Standard Greeting recorded (just cut & paste into the CUDLI Query Builder):

 

SELECT vw_CallHandler.DisplayName, vw_GreetingStreamFile.StreamFile
 FROM vw_GreetingStreamFile JOIN vw_CallHandler
 ON vw_GreetingStreamFile.CallHandlerObjectId=vw_CallHandler.ObjectId
 WHERE vw_CallHandler.IsPrimary=1 AND vw_GreetingStreamFile.GreetingType='Standard'

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here