04-17-2012 08:24 PM
ID Computername logontime Domain Username ADsite Ipaddress
14466 45 2012-04-17 10:09:19.980 WPBPS user1 NULL 10.132.50.96
14465 45 2012-04-17 10:09:19.790 WPBPS user2 NULL 10.132.50.96
04-18-2012 12:31 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCPlogoninfo.logontime, tblCPlogoninfo.Domain
As Domain1, tblCPlogoninfo.Username, tblCPlogoninfo.ADsite,
tblCPlogoninfo.Ipaddress
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.ComputerUnique Like '%YourPC%'
Order By tblComputers.ComputerUnique, tblCPlogoninfo.logontime Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now