Need help getting extension's parameters from database

[ar_gen_tum (Serggio)]

Hello, everyone.
How can I get some extension’s parameters from database and use it in dialplan?
I need CID Num Alias, SIP Alias, Email Address for Dictation Services.

It is like ${DB(AMPUSER/${AMPUSER}/cidname)} for the extension’s Display name.

Thanks in advance.

[lgaetz (Lorne Gaetz)]

Most of the settings you can see for yourself by running:

database show AMPUSER xxxx
database show DEVICE xxxx

Where xxxx is the local extension number. You won’t find the SIP alias in the astdb, you will have to get that from the MySQL table, asterisk.users.

[dicko]

You can similarly extract the email from /etc/asterisk/voicemail.conf

[ar_gen_tum (Serggio)]

Thanks.
I need get Email Address from Dictation Services, but this doesn’t work:

Set(email=${DB(AMPUSER/${CDR(dst)}/dictate/email)}

I don’t get it. Whats wrong?

[ar_gen_tum (Serggio)]

My fault. I found mistake.
Thanks again!

[PitzKey (Itzik)]

Post what your mistake was, so it will help other users…