Callmanager 7 search

[brianschaefer]

Hi,

is there any easy way to search for all phone numbers that are assigned to a specific calling search space? I don't care if it's through a search or an export, I just need to verify what numbers are assigned to a particular calling search space

thanks

-Brian

[Jaime Valencia]

You can do an export all details using BAT and then just order by the CSS field in a spreadsheet editor.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

[brianschaefer]

could you be a little more specific? on the 'bulk administration' tab, I didn't know where to go from there. Just to be clear I have phones profiles in CSS, ext. mobility profiles with lines in CSS, and phones with assigned lines in CSS.

[jtesar]

Brian,

Just to confirm, you're interested to find directory numbers with a partiticular Calling Search Space assigned at the line/DN, not a list of DN/Partitions that are contained within a particular CSS.

If it is the former, the following sql query can be used to find DNs that have been assigned to CSS :

run sql select dnorpattern from numplan n, callingsearchspace c where n.fkcallingsearchspace_sharedlineappear = c.pkid and c.name = ''

This query should work in 6.x and above.  You can change the name to match the CSS name of interest and give it a shot.

-jt

[brianschaefer]

right, all directory numbers with a particular CSS

I have never issued sql commands to call manager, to do that, do I need to install a plugin? "application"-->"plugins" ?

[Aaron Harrison]

Hi

Just connect to the server via SSH using Putty or a similar client, and paste in the 'run sql ...' line as a command. Set Putty to log printable output to a text file, and you can then import the text to Excel as a .tsv file for further manipulation.

Regards

Aaron

Please rate helpful posts...

[lfulgenzi · Accepted solution]

Under related links, you can chose Dependancy Records. This will provide a list of DNs or patterns that

are associated with this CSS.