Could you please extend following report with the "LastLogon" column - so that we can see the last logon time of a user (the last logon server information is not necessary)
Select Top 1000000 tblADusers.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Displayname,
tblADusers.email,
tblADusers.Department
From tblADMembership
Left Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Right Join tblADusers On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Where tblADusers.Username Not Like '_demo%' And tblADGroups.Name Like
'G_desktop'
Order By tblADusers.Userdomain,
tblADusers.Username,
tblADGroups.Name
Thank you!
BR
Ref
