10-07-2010 02:30 PM - edited 03-16-2019 01:13 AM
HI,
Is there anyway to run a report or look at which DN's do not have an external mask configured?
Thanks,
Randall
Solved! Go to Solution.
10-07-2010 03:50 PM
You can create a phone file format that has the external phone number mask, DN, MAC, etc whatever details you need to find the phone and use it with the phone-> export phones -> specific details.
This will give a list of all phones with the data you selected in the format, just look for the ones with that field empty.
If what you want is really just a list of which ones have the field empty then SQL is what you need, the field is e164mask and is in the devicenumplanmap table.
HTH
java
If this helps, please rate
www.cisco.com/go/pdihelpdesk
10-07-2010 02:51 PM
No such a report, but you may run SQL query from CLI to get it.
Sorry I don't have the exact SQL statement. But I believe it's in 'numplan' table.
Michael
10-07-2010 02:54 PM
Hi,
We are on 7.0.2
10-07-2010 03:50 PM
You can create a phone file format that has the external phone number mask, DN, MAC, etc whatever details you need to find the phone and use it with the phone-> export phones -> specific details.
This will give a list of all phones with the data you selected in the format, just look for the ones with that field empty.
If what you want is really just a list of which ones have the field empty then SQL is what you need, the field is e164mask and is in the devicenumplanmap table.
HTH
java
If this helps, please rate
www.cisco.com/go/pdihelpdesk
10-07-2010 03:56 PM
I think both ways may help.
Can you be more specific on how to do each?
Thaanks,
randall
10-07-2010 04:23 PM
I created a file format and I got what i need.
Thanks you very much.
You are the man!!!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide