Run SQL - Extension

[gchiarapa_value]

I would like to create a cucm query to bring information about the extensions, like directory number, device name, Device Pool, Directory Template 1 and Recording Option/Profile.

tks for help.

[Chris Deren]

How about just BAT export devices?

[gchiarapa_value]

Yes, I know there is this option, but I need to extract this informations automatic.

[Chris Deren]

Couple helpful links:

https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html

http://www.ucguerrilla.com/2012/03/cucm-sql-queries-series.html

[Gilmar Silva]

I was looking for a similar SQL query so I hope the following queries might be helpful to someone:

run sql select dev.name as devicename, dev.description as description, np.dnorpattern as extension, rp.name as recordingproile, rd.tkrecordingflag as RecordingOption  from devicenumplanmap as dnp left join  device as dev  on dnp.fkdevice=dev.pkid left join numplan as np  on dnp.fknumplan=np.pkid left join recordingprofile as rp  on dnp.fkrecordingprofile=rp.pkid left join recordingdynamic as rd on dnp.pkid=rd.fkdevicenumplanmap where rp.name != 'NULL'

The field "recordingoption" has the values 0,1 and 2 with following meaning:

run sql select * from typerecordingflag
enum name moniker
==== ================================ ========================
0 Call Recording Disabled RECORDING_FLAG_DISABLED
1 Automatic Call Recording Enabled RECORDING_FLAG_AUTOMATIC
2 Selective Call Recording Enabled RECORDING_FLAG_SELECTIVE