Login info is stored in tblCPlogoninfo. The example report below lists all admin logins that were scanned in the last 7 days.
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
Archive
This board contains archived posts from the retired Lansweeper Forum and Insiders Community.