Callmanager 7 search

Answered Question
Aug 27th, 2010

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

Correct Answer by lfulgenzi about 6 years 5 months ago

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

are associated with this CSS.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4.3 (3 ratings)
Loading.
brianschaefer Mon, 08/30/2010 - 05:34

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 Fri, 08/27/2010 - 14:23

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 Mon, 08/30/2010 - 05:43

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 Mon, 08/30/2010 - 08:01

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...

Correct Answer
lfulgenzi Sat, 08/28/2010 - 21:52

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

are associated with this CSS.

Actions

This Discussion

Related Content