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