03-30-2021 09:35 AM
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
Solved! Go to Solution.
03-30-2021 07:21 PM
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
03-30-2021 07:25 PM
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.
03-30-2021 07:21 PM
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
03-30-2021 07:25 PM
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.
03-31-2021 12:26 PM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide