Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

CFB Clean Up

Unanswered Question
Jul 9th, 2013
User Badges:

Hello NetPros,

We have about 300 sites, 40000+ users, 700+ GWs and 7 clusters. We believe our CFB resources are not adequately distributed. I need to audit all GWs, find available CFB resources, find the number of heads and configure the correct number for Maximum session under dspfarm profile. The assumption is only 5% of the users at a given site will need CFB.

I guess the manual approach would be to go to:

-     Pub of each cluster

-     Open each and every configured Device Pool (1000+)

-     Select the Dependency Record on the right corner of the page

-     Take on note the number of the phones registered to each DP

-     Click on the Conference Bridge on the same Dependency Record page

-     Take the IP address of the GW

-     Log in to the GW, go to dspfarm profile and take on note the maximum session configured

-     Do the calculation for 5% of the users in each site that will need conference

-     Assign the right number to the Maximum sessions under dspfarm profile

Is there any easier way of accopmlishing this task?

Your help would be much appreciated,


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (3 ratings)
Carlo Poggiarelli Tue, 07/09/2013 - 14:34
User Badges:
  • Green, 3000 points or more


Try to use RealTime Monitoring Tool and navigate "Performance" --> "Cisco Hardware Conference Bridge" -->> "Resource Available"

This should help




Please rate all helpful posts

"The more you help the more you learn"

Jonathan Schulenberg Wed, 07/10/2013 - 04:39
User Badges:
  • Super Bronze, 10000 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

One step to add to your manual process above: You need to run the DSP Calculator to see whether the router has sufficient DSP capacity available to even increase the maximum sessions. IOS will allow you to oversubscribe the DSPs so just relying on the range shown when you question mark the max sessions command isn't viable.

As for automating parts of it, a few clever SQL queries from the CLI could probably show you the data you're collecting in the first half of the process. You would need to do a few join statements but I'm not strong enough in SQL to give you a final command. Perhaps one of the others will; if not here is the database dictionary at least.

Please remember to rate helpful responses and identify helpful or correct answers.

mightyking Wed, 07/10/2013 - 08:47
User Badges:

Thanks Carlos and Jonathan,

Anyone with SQL knowledge or any other automating approach who can make the life easier for me? I really don't want to start the manual process cause it is going to be long and cumbersome.



afmmanicke Wed, 07/10/2013 - 09:58
User Badges:

I skimmed through my notes and modified one query to come up with this:

run sql SELECT COUNT(Device.name) FROM device, devicepool WHERE devicepool.pkid = Device.fkdevicepool AND devicepool.name = "LEC_DP"

This should get you started.


mightyking Wed, 07/10/2013 - 11:44
User Badges:

Thanks Tony,

The output of the SQL query will show the device pools and the devices within the device pool. is that right?


brmeade Wed, 07/10/2013 - 12:18
User Badges:
  • Silver, 250 points or more

That query shows the count of number of devices in the device pool named "LEC_DP".

afmmanicke Wed, 07/10/2013 - 12:18
User Badges:

I thought you were looking for the count of phones in a given device pool which is what would be returned from the above query.

To find out which phones are under a given device pool you could run this:

run sql SELECT Device.name devicepool.name FROM device, devicepool WHERE  devicepool.pkid = Device.fkdevicepool ORDER BY devicepool.name

Altough its the same info that's provided on the conference bridge page you could get a condensed version of what conference bridge is in what device pool with this query:

run sql SELECT d.name, d.description, dp.name, tp.name FROM device as d, devicepool as dp, typeproduct as tp WHERE dp.pkid = d.fkdevicepool AND d.tkmodel = tp.tkmodel AND tp.name LIKE "%Conference%" ORDER BY tp.name

mightyking Wed, 07/10/2013 - 14:18
User Badges:

Thanks for your help Tony,

I don't think with those commands I can accomplish the task mentioned above. It still requires a lot of manual implications.

Followings are the fileds that I need the value for:

Device Pool Name

Media Resource Groupe List

Media Resource Group

Count of IP Phones in each DP

CFB name configured under MRG

Gateway containing the DSP for conferencing (name or IP)

Maximum sessions configured in the dspfarm profile.


James Hawkins Wed, 07/10/2013 - 14:26
User Badges:
  • Blue, 1500 points or more

It might be worth looking at a tool like Variphy to see whether it could generate the reports you are looking for.


It is a pretty good solution and could be of use managing your CUCM estate in lots of ways.

mightyking Thu, 07/11/2013 - 10:22
User Badges:


Is there any SQL query which will show the MRGL, MRG and the CFB configured within a given Device Pool?

Also the first command in your second reply displays error message.



afmmanicke Thu, 07/11/2013 - 10:52
User Badges:

To find out which phones are under a given device pool you could run this:

run  sql SELECT Device.name, devicepool.name FROM device, devicepool WHERE   devicepool.pkid = Device.fkdevicepool ORDER BY devicepool.name   Looks like I missed a comma there.

To get a listing of all CFBs configured within your system you could run this:

run sql SELECT d.name, d.description, dp.name, tp.name FROM device as d, devicepool as dp, typeproduct as tp WHERE dp.pkid = d.fkdevicepool AND d.tkmodel = tp.tkmodel AND tp.name LIKE "%Conference%" ORDER BY dp.name

To find what MRGL is assigned to a device pool you could run this:

run sql SELECT dp.name, mrgl.name, mrgl.clause FROM devicepool as dp, mediaresourcelist as mrgl WHERE dp.fkmediaresourcelist = mrgl.pkid

A MRGL is just an assignment and order of MRGs which is what the clause will show you.


mightyking Fri, 07/12/2013 - 08:08
User Badges:

Thanks Tony, very usefull :-)

Is there a way we can ajust the last command (MRGL) to see the Conference bridges assigned to each MRG in the same output?

Your help is very much appreciated,


mightyking Fri, 07/12/2013 - 08:35
User Badges:

Thanks Brian,

I will definitely do that but for now don't have time to go through about 900 pages.



brmeade Fri, 07/12/2013 - 08:41
User Badges:
  • Silver, 250 points or more

What do you think he's doing every time he makes you one of those queries?  No one has these tables memorized.  You just do a search for the type of information you're looking for and build a query from that.

mightyking Fri, 07/12/2013 - 09:14
User Badges:

Let's see if Tony or anybody else can help me with that. I have a very limited time to accomplish the above task.


brmeade Fri, 07/12/2013 - 09:22
User Badges:
  • Silver, 250 points or more

Perhaps you should look into hiring a consultant?

mightyking Fri, 07/12/2013 - 09:29
User Badges:

Thank you for the offer, I will let you know if we need one. For now let me see if I can get the SQL command.


mightyking Fri, 07/12/2013 - 11:12
User Badges:


Would that be possible for you to share with me the last SQL command I asked. I tried to go through the document Brian sent but no luck.  The problem is I don't have much time left.



mightyking Sun, 07/14/2013 - 09:05
User Badges:

Can anybody please help to put together a SQL query which displays the following in the same output.

-     Name of Divice Pool (DP)

-     MRGL within the DP

-     MRG within MRGL

-     Confenrence Bridge name within MRG




This Discussion