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