Get Linegroup from Device (name)

[Matthias.assmann1]

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

[istibekesi]

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

[Matthias.assmann1]

Hello,

Thanks for your answer.

Is it alternatively possible to get from the Windows user to the Device Name?

[istibekesi]

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.

[lior look]

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?