‎02-09-2012 08:33 PM
‎02-10-2012 02:23 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblUsersInGroup.Admingroup, tblCPlogoninfo.Domain As Domain1, tblCPlogoninfo.Username, tblCPlogoninfo.logontime From tblComputers Inner Join tblUsersInGroup On tblComputers.Computername = tblUsersInGroup.Computername Inner Join tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername Where tblUsersInGroup.Admingroup = '1' And tblCPlogoninfo.logontime > GetDate() - 7 Order By tblCPlogoninfo.logontime Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now