04-12-2012 04:42 PM
04-12-2012 04:51 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.Username, tblComputers.Userdomain,
Web40OSName.OSname, tblOperatingsystem.Caption, tblComputersystem.SystemType,
tblCPlogoninfo.logontime, tblCPlogoninfo.Domain As Domain1,
tblCPlogoninfo.Username As Username1, tblCPlogoninfo.ADsite,
tblCPlogoninfo.Ipaddress
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputers.ComputerUnique Like '%YourPC%'
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now