cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
825
Views
0
Helpful
3
Replies

SIP Profile Search

Mike Supalo
Level 1
Level 1

Hello. Trying to find a way to search on a specific SIP profile within 12.5 CUCM. My goal is to confirm which CSF (Jabber users) are configured with the Default BCFS Profile for content sharing. Unfortunately exporting a file via Job Scheduler doesn't provide this detail, nor does RTMT. Any ideas? Thank you

2 Accepted Solutions

Accepted Solutions

Hi, You can run dependency records on SIP profile which has BFCP enabled. Open a SIP profile and use related links dropdown on top right corner to select dependency records.  It will show the list of devices which are using that SIP profile. 

If dependency records are disabled then you can enable it via System > Enterprise parameters

 

Regards,

Onkar Mahajan

 

Please rate if helpful

View solution in original post

Gregory Brunn
Spotlight
Spotlight

Silly question... does doing a dependancy check in CUCM not do this for you?

So go to the SIP profile and in the top right click the drop down to do a dependancy check... Dependancy checks need to be enabled for of course

Not VPNed to check in a CUCM now.

 

If not I would the other way to do this would be to do a getPhone axl request for the phones that contain it or a SQL querry looking for the specific profile.

 

View solution in original post

3 Replies 3

Hi, You can run dependency records on SIP profile which has BFCP enabled. Open a SIP profile and use related links dropdown on top right corner to select dependency records.  It will show the list of devices which are using that SIP profile. 

If dependency records are disabled then you can enable it via System > Enterprise parameters

 

Regards,

Onkar Mahajan

 

Please rate if helpful

Gregory Brunn
Spotlight
Spotlight

Silly question... does doing a dependancy check in CUCM not do this for you?

So go to the SIP profile and in the top right click the drop down to do a dependancy check... Dependancy checks need to be enabled for of course

Not VPNed to check in a CUCM now.

 

If not I would the other way to do this would be to do a getPhone axl request for the phones that contain it or a SQL querry looking for the specific profile.

 

Adam Pawlowski
VIP Alumni
VIP Alumni

You can do this via SQL query as well using PuTTY or similar.

 

admin:run sql ccm select pkid, name from sipprofile
pkid                                 name
==================================== ==================================================
71ffbec9-9fbc-ef88-1e75-877a83302231 Jabber Standard SIP Profile <-----
fcbc7581-4d8d-48f3-917e-00b093b39213 Standard SIP Profile
2a7b6a2c-dac3-a756c-0999-62ba378d8943 Jabber SIP Profile for Mobile Device

admin:run sql ccm select count(name) from device where fksipprofile = (select pkid from sipprofile where name = 'Jabber Standard SIP Profile')
(count)
=======
5055

or

admin:run sql ccm select count(name) from device where fksipprofile = '71ffbec9-9fbc-ef88-1e75-877a83302231'


Modify the query as needed to collect the fields you want such as "name", and perhaps add some qualifiers to eliminate templates and things like:

run sql ccm select name from device where fkdevice = <some_pkid> and typemodel = '503' and typeclass = '1'

which should limit it to CSF devices that are a phone and not a template.

 

 

 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: