 Rank: Administration Groups: Administration, Premium Users
Posts: 10,379
|
Login info is stored in tblCPlogoninfo. The example report below lists all admin logins that were scanned in the last 7 days. Quote: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
|
