cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

594
Views
0
Helpful
3
Replies
Beginner

CER Queries.

Hello,

 

Does anyone know a couple queries for CER which will show phones it's learned via switch port? With just mac, DN.

 

And unallocated phones?

 

I see the tables via show tech systables. But they don't contain the data I would think. For example.

run sql select * from cerunlocatedphone

 

Only shows about 1/5 of the actual unallocated phones I see from the GUI.

 

Thanks

3 REPLIES 3
Contributor

Re: CER Queries.

I don't think that table is updated in real-time, or at least it's never matched exactly for me with what's listed in ceradmin. You can just use the 'Export' feature at the top right of the 'Unlocated Phones' page. I don't recall when that feature was added, but it's in 11.5.2 for sure.

Highlighted
Rising star

Re: CER Queries.

As Will said, export, or maybe the API to pull a list in XML format.

Beginner

Re: CER Queries.

So this was actually for automation. Export from gui wasn't an option. API either.

 

But in case anyone else runs across this was able to find a query that works.

 

  1. (for switch ports) run sql select erl.name, switch.switchid,switch.switchports from cererl erl,cerswitchport switch where switch.fkerl=erl.erlid
  2. (for unallocated phones) run sql select phones.macaddress, erl.name from cererl erl, cerunlocatedphone phones where phones.fkerl=erl.erlid
CreatePlease to create content
Content for Community-Ad
FusionCharts will render here