<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>Try this:<br><br>Bulk Administration > Phones > Export<span> Phones > All Details<br><br>this should create a file with all the information you need to parse through.<br><br>I'm trying this now, but it seems to take a while so I can't confirm. I've got over 8000 phones, so it will take a while.<br><br><br><span name="x"></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>Cooking with unix is easy. You just sed it and forget it. <br> - LFJ (with apologies to Mr. Popeil)<br><span name="x"></span><br></span><br><hr id="zwchr"><b>From: </b>"Neal Haas" <nhaas@co.fresno.ca.us><br><b>To: </b>"cisco-voip@puck.nether.net" <cisco-voip@puck.nether.net><br><b>Sent: </b>Tuesday, November 2, 2010 7:10:30 PM<br><b>Subject: </b>[cisco-voip] External Phone Number Mask<br><br><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div class="WordSection1"><p class="MsoNormal">I need to find which phone has the wrong external MASK. I have 1 phone out of 1000 with the wrong external Mask. I don’t want to go through every phone. </p><p class="MsoNormal"> </p><p class="MsoNormal">Do I need to do a SQL query? If so how do I accomplish this, I am on 7.1.3.10000-11 Linux!</p><p class="MsoNormal"> </p><p class="MsoNormal">Thanks</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(31, 73, 125);">Neal </span></p><p class="MsoNormal"> </p></div><br>_______________________________________________<br>cisco-voip mailing list<br>cisco-voip@puck.nether.net<br>https://puck.nether.net/mailman/listinfo/cisco-voip<br></div></body></html>