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
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.
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'
Good afternoon,Strange occurrence happening. We two different agents getting connected to the same caller/customer. We have checked the ext in CUCM, they are different. We have checked the ICM configs, different. We have listened to the call r...
Is there a way in UCCE with using an admin script maybe using the email application in Call Studio to send out an email? I know in UCCX you can send out an email if the script were to fail but is there a way to do it in UCCE? Any help would be great!
Fun lab with Packet Tracer and running Cisco CME with 3 ip phones, 3 laptops, 1 switch, and 1 router. Fun lab with repetition. You will be able to test your phones and laptop for connectivity etc. Solution;see attached CME Packet Tracer L...