→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎04-18-2014 07:08 PM
Solved! Go to Solution.
‎06-12-2014 03:20 PM
Select Distinct Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
Max(tblCPlogoninfo.logontime) As 'last logon'
From tblADusers
Inner Join tblADMembership On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Inner Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Inner Join tblCPlogoninfo On tblCPlogoninfo.Username = tblADusers.Username And
tblCPlogoninfo.Domain = tblADusers.Userdomain
Group By tblADusers.Username,
tblADusers.Userdomain
‎06-27-2014 11:31 PM
‎06-12-2014 03:20 PM
Select Distinct Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
Max(tblCPlogoninfo.logontime) As 'last logon'
From tblADusers
Inner Join tblADMembership On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Inner Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Inner Join tblCPlogoninfo On tblCPlogoninfo.Username = tblADusers.Username And
tblCPlogoninfo.Domain = tblADusers.Userdomain
Group By tblADusers.Username,
tblADusers.Userdomain
‎06-11-2014 09:08 PM
‎05-29-2014 02:22 AM
‎04-23-2014 06:00 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now