Find devices which assigned to a LDAP user group
10/25/2017 511 views
I have an user LDAP label that I filter from my AD. It has 5 users. Let say the LDAP label name is 'Label1'
In Label Management, I can see 5 users, each has at least one assigned device. Four users has one assigned devices, one user has four assigned devices
I want to create a report that show a list of devices which users of "Label1" are assigned to.
I contact TechSupport and they said it is a custom report with SQL.
If any expert out there has with SQL experience, I appreciate your suggestion.
Community Chosen Answer
Please log in to answer
Hello @ridesharing - try this:
Create a new SQL report and enter this at SQL:
JOIN USER U1 on U1.USER_NAME = MACHINE.USER
JOIN USER_LABEL_JT L1 on L1.USER_ID = U1.ID
JOIN LABEL L2 on L2.ID = L1.LABEL_ID
WHERE L2.NAME = 'Label1'
ORDER BY USER ASC
Answered 11/02/2017 by: svmay