02-22-2019 02:05 PM
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
03-27-2019 12:22 PM
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.
03-28-2019 03:40 AM
03-28-2019 07:18 AM
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.
01-24-2022 02:43 PM
Thank you Jay. This is very helpful. Do you have more sql queries for CER to share?
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: