Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
1119
Views
15
Helpful
20
Replies

CFB Clean Up

mightyking
Level 6
Level 6

‎07-09-2013 12:35 PM - edited ‎03-16-2019 06:17 PM

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,

MK          

Labels:
0 Helpful
20 Replies 20

brmeade
Level 4
Level 4
In response to mightyking

‎07-12-2013 08:41 AM

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.

0 Helpful

mightyking
Level 6
Level 6
In response to brmeade

‎07-12-2013 09:14 AM

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

MK

0 Helpful

brmeade
Level 4
Level 4
In response to mightyking

‎07-12-2013 09:22 AM

Perhaps you should look into hiring a consultant?

0 Helpful

mightyking
Level 6
Level 6
In response to brmeade

‎07-12-2013 09:29 AM

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.

MK

0 Helpful

mightyking
Level 6
Level 6
In response to mightyking

‎07-12-2013 11:12 AM

Tony,

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.

Thanks,

MK

0 Helpful

mightyking
Level 6
Level 6
In response to mightyking

‎07-14-2013 09:05 AM

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

Thanks,

MK

0 Helpful
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:

Customers Also Viewed These Support Documents