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