Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

CER 2.4 Unlocated Phones report

Does anyone know a sql query I can run in the CLI to return all unlocated phones?  I am supporting a customer with a large amount of unlocated phones, but the GUI doesn't offer a way to export to a .csv or list more than 20 per page.  Any help is appreciated!

Thanks!

Everyone's tags (3)
9 REPLIES
Cisco Employee

Re: CER 2.4 Unlocated Phones report

What is the version of CER you're running?  There is no version 2.4.

Community Member

Re: CER 2.4 Unlocated Phones report

I'm sorry ... it's CER 2.0.4.

I would imagine the sql statement would be the same for 2.x and 7.x.

Thanks!

Cisco Employee

Re: CER 2.4 Unlocated Phones report

I don't have a CER 2.0.4 to check the list of tables. However, I checked in a CER 7.1.1 server, and found that the 'cerunlocatedphone' table saves the information about Unlocated Phones on CER.

You can SSH to the CER server and run the following command :

run sql select * from cerunlocatedphone

Hope this helps.

- Sriram

Community Member

CER 2.4 Unlocated Phones report

How do you get the list of tables?

Cisco Employee

Re: CER 2.4 Unlocated Phones report

Hi,

The 'show tech systables' would give you the list of tables in the sysmater - this option will not be available on 2.0.4 CER. You can run sql queries on the database for the tables other than the cdr_deltatab and sys entries.

admin:

admin:show version active

Active Master Version: 8.5.1.10000-7

Active Version Installed Software Options:

No Installed Software Options Found.

admin:

admin:show tech systables

-------------------- show tech systables --------------------

System Tables

tabname

==============================

GL_COLLATE

GL_CTYPE

VERSION

applicationuser

applicationusertousergroupmap

cdr_deltab_000001

cdr_deltab_000002

cdr_deltab_000003

cdr_deltab_000004

cdr_deltab_000005

cdr_deltab_000006

cdr_deltab_000007

cdr_deltab_000008

cdr_deltab_000009

cdr_deltab_000010

cdr_deltab_000011

cdr_deltab_000012

cdr_deltab_000013

cdr_deltab_000014

cdr_deltab_000015

cdr_deltab_000016

cdr_deltab_000017

cdr_deltab_000018

cdr_deltab_000019

cdr_deltab_000020

cdr_deltab_000021

cdr_deltab_000022

cdr_deltab_000023

cdr_deltab_000024

cdr_deltab_000025

cdr_deltab_000026

cdr_deltab_000027

cdr_deltab_000028

cdr_deltab_000029

cdr_deltab_000030

cdr_deltab_000031

cdr_deltab_000032

cdr_deltab_000033

cdr_deltab_000034

ceraniextmapping

cercallhistory

cerccmclusterattributes

cerccmlist

cerdiscoveryengine

ceremergencynumber

cererl

cererlaudit

ceripsubnets

cerlicenses

cermanualentryphones

cerremote

cersecuritycontact

cerseedswitches

cerserver

cerservergroup

cersnmpcmtystring

cerswitchport

cerswitchportlocation

cerswitchporttableview

cersystemparameters

cerunlocatedphone

cervhmphones

dblschemaorder

functionrole

functionroletoresourcemap

functionroletousergroupmap

intradoelinstatus

offpremiseslocation

offpremiseslocationassociation

sysaggregates

sysams

sysattrtypes

sysblobs

syscasts

syschecks

syscolattribs

syscolauth

syscoldepend

syscolumns

sysconstraints

sysdefaults

sysdepend

sysdirectives

sysdistrib

sysdomains

syserrors

sysfragauth

sysfragments

sysindexes

sysindices

sysinherits

syslangauth

syslogmap

sysobjstate

sysopclasses

sysopclstr

sysprocauth

sysprocbody

sysproccolumns

sysprocedures

sysprocplan

sysreferences

sysroleauth

sysroutinelangs

sysseclabelauth

sysseclabelcomponentelements

sysseclabelcomponents

sysseclabelnames

sysseclabels

syssecpolicies

syssecpolicycomponents

syssecpolicyexemptions

syssequences

syssurrogateauth

syssynonyms

syssyntable

systabamdata

systabauth

systables

systraceclasses

systracemsgs

systrigbody

systriggers

sysusers

sysviews

sysviolations

sysxadatasources

sysxasourcetypes

sysxtddesc

sysxtdtypeauth

sysxtdtypes

typeapplication

typeresource

usergroup

admin:

- Sriram

Please rate helpful posts !

Community Member

Re: CER 2.4 Unlocated Phones report

Thanks for the quick response.  That helped.  However I also did the "run sql select * from cerunlocatedphone" and it only came up with a couple of phones.  Not the 8000+ phones that show up when I run the unlocated phone report in the QUI.  Is there another command that will just show me phones in the Default ERL?  I searched through the different tables and couldnt find any.

Community Member

Hello Aaron,

Hello Aaron,

Did you ever find a query for phones in the default? Having the same issue.

Community Member

Sorry Jay I can't remember.

Sorry Jay I can't remember.  I have moved off that group and no longer support IP phones.  Maybe I opened a TAC case?  I tried to go back and look at my old cases and it won't let me anymore.

To be honest I forgot I had an account still.  Chrome saved my password from 5 years ago.

Hope you find what you need.

Community Member

Thanks for responding and

Thanks for responding and taking a look. Thought I'd give it a shot.

920
Views
3
Helpful
9
Replies
CreatePlease to create content