Please does anyone know how/where to get the ‘Voicemail to Email Address’ field for a given Extn (as set on the ‘Voicemail’ tab of an Extension) ?
I have the following SQL to get various Extension details, including the ‘[users].[voicemail]’ field that seems to indicate whether VM is enabled for a given Extn, but NOT what email address it might be forwarded to (This is NOT the same as the Linked Users email address within ‘[userman_users].[email]’).
mysql asterisk -e "SELECT devices.id AS Extn_No, devices.tech AS Extn_Tech, devices.description AS Extn_Desc, users.voicemail AS Extn_Voicemail FROM devices LEFT JOIN users ON devices.id = users.extension WHERE ((devices.description NOT LIKE 'Zulu%') AND (devices.description NOT LIKE 'WebRTC%')) ORDER BY devices.id;"
I cannot see the actual VM email address in either the ‘devices’ or ‘users’ table, neither can I see an obvious other DB table that might contain the Voicemail fields relating to a given Extn.
Any assistance would be greatly appreciated.