02-04-2016 06:04 AM
Hello there,
I try to get my SQL the Line Group out via the AXL API.
I want to specify the device name and get the Line Group.
Can someone to call the SQL string?
Gruß Matthias
02-12-2016 07:40 AM
This might help, from the data dictionary:
SQL something like this:
run sql select lg.name, np.dnorpattern from linegroup lg, linegroupnumplanmap lgnpm, numplan np where lgnpm.fklinegroup = lg.pkid and np.pkid = lgnpm.fknumplan and np.dnorpattern = '3335'
name dnorpattern
======== ===========
LG_Unity 3335
02-16-2016 11:17 PM
Hello,
Thanks for your answer.
Is it alternatively possible to get from the Windows user to the Device Name?
02-17-2016 11:41 PM
I'm not sure I understand your question... Windows user and Device Name are independent, not linked to each other, unless you have your own naming convention.
03-30-2016 03:23 PM
Hi Matthias,
I'm not sure if I understand your question.
Do you want to send an device's name and get the line group who contains the device?
Did you mean that?
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