cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
684
Views
3
Helpful
4
Replies

Get Linegroup from Device (name)

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

4 Replies 4

istibekesi
Level 1
Level 1

This might help, from the data dictionary:

Capture.PNG

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

Hello,

Thanks for your answer.

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

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

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?

Getting Started

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: