cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1433
Views
2
Helpful
4
Replies

Run SQL - Extension

gchiarapa_value
Level 1
Level 1

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.

4 Replies 4

Chris Deren
Hall of Fame
Hall of Fame

How about just BAT export devices?

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

Gilmar Silva
Level 1
Level 1

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