Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Hi there,Does anyone have full sql which will return the DN, External Phone Mask, and Description of Phone? I get close with the sql command below, but still cannot get the description to appear.admin:run sql select dnorpattern, e164mask, tkpatternu...
Aaron,Thanks so much for your feedback. It worked great. Here's the sql command used since I was looking for a particular number.run sql select dnorpattern, d.description, e164mask, tkpatternusage from devicenumplanmap inner join numplan on fknum...