Find devices which assigned to a LDAP user group
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.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
svmay
6 years ago
Hello @ridesharing - try this:
Create a new SQL report and enter this at SQL:
| SELECT MACHINE.NAME, MACHINE.USER FROM MACHINE 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 |
cheers
Posted by:
ridesharing
6 years ago
Comments:
-
Hi ridesharing
Sorry, I didn't read the answer before.
I have an error in the SQL code - there is a comma set incorrectly. I fixed the code in the answer above. Please try it again. - svmay 6 years ago