topic Re: Get Linegroup from Device (name) in Management

Get Linegroup from Device (name)

Matthias.assmann1 — Thu, 04 Feb 2016 14:04:46 GMT

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

Re: Get Linegroup from Device (name)

istibekesi — Fri, 12 Feb 2016 15:40:00 GMT

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

Re: Get Linegroup from Device (name)

Matthias.assmann1 — Wed, 17 Feb 2016 07:17:29 GMT

Hello,

Thanks for your answer.

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

Re: Get Linegroup from Device (name)

istibekesi — Thu, 18 Feb 2016 07:41:02 GMT

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.

Re: Get Linegroup from Device (name)

lior look — Wed, 30 Mar 2016 22:23:26 GMT

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?