06-12-2012 11:28 AM - edited 03-16-2019 11:38 AM
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, tkpatternusage from devicenumplanmap inner join numplan on fknumplan=numplan.pkid where e164mask= "1234567890"
Thanks in advance,
Sharon
Solved! Go to Solution.
06-12-2012 01:30 PM
Hi
You were 80% there:
run sql select dnorpattern, d.description, e164mask, tkpatternusage from devicenumplanmap inner join numplan on fknumplan=numplan.pkid join device d on fkdevice = d.pkid
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
06-12-2012 11:41 AM
Hi Sharon,
I believe you need to add a union command, something like this:
admin: run sql select dnorpattern from numplan union select description from device
Regards,
Tere.
If you find this post helpful, please rate!
06-12-2012 01:30 PM
Hi
You were 80% there:
run sql select dnorpattern, d.description, e164mask, tkpatternusage from devicenumplanmap inner join numplan on fknumplan=numplan.pkid join device d on fkdevice = d.pkid
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
06-12-2012 01:51 PM
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 fknumplan=numplan.pkid join device d on fkdevice = d.pkid where e164mask= "1234567890" "NUMBER"
This saved me several hours in Call Mgr.
Thanks again,
Sharon
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: