→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Alex-IT
Engaged Sweeper II

Hello,

My report is now showing the users in the AD group I want:

Select Top 1000000 tblADusers.Username,
tblADusers.Name,
tblADGroups.Name As ADGroupName,
Case tblADGroups.GroupType
When -2147483646 Then 'Security - Global'
When -2147483644 Then 'Security - Local'
When -2147483643 Then 'Built-in'
When -2147483640 Then 'Security - Universal'
When 2 Then 'Distribution - Global'
When 4 Then 'Distribution - Local'
When 8 Then 'Distribution - Universal'
End As ADGroupType
From tblADusers
Left Join tblADMembership On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Left Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Where tblADGroups.Name = 'GR_EDD_GLO_SEC_RepoBitBucket'
Order By tblADusers.Username,
ADGroupName

Now I need to add the "last computer" of those users in the report.
I think what I need is:

AlexIT_0-1659975063132.png

Am I right?

And the big question:  How to I join this properly to the other tables through the GUI?
I would prefer to understand how to do it instead of asking you to just tell me the working report SQL code answer.

thx in advance!

2 REPLIES 2
Alex-IT
Engaged Sweeper II

UP!

Alex-IT
Engaged Sweeper II

If nobody wants to tell me how to do it I would now accept to get just the report solution.  😞