MiVoice Connect - How to Locate Auto Attendant Greeting File

[its_the_butcherman]

Is it possible to determine the file name of the AA Greeting file and its location in MiVoice Connect (ShoreTel)?

Normally the AA Greetings are kept in Shoreline Data/Vms/SHORETEL/{mailbox}, but if the user recorded them via Director, they are stored in Shoreline Data/Prompts and the name of the file only correlates to the user that did the recording. I have 43 AA's I have to port over to MiVoice Business, and I'm hoping for a faster way to pull the recordings from the filesystem than to listen and tag each individual file, not to mention those don't get deleted half the time when re-recorded.

 

[its_the_butcherman]

Ok, I figured it out and thought I would post the result in case anyone else is looking for it.

When you record from Director it does store it in Prompts, but also copies it over to the SHORETEL/{mailbox} directory as Prompt{id}.wav. To figure out which prompt goes to which AA (On Hours, Off Hours, etc) go into the raw database and look at the `shoreware.submenus` table.

The MenuDN column matches the extension number of the AA.
The TypeTypeID column matches the scheduled type (1 = On Hours, 2 = Off Hours, 3 = Holiday, 4 = Custom).
The PromptID column matches the {id} field in the Prompt{id}.wav file.

Hope this helps someone in a similar situation.