06-19-2012 10:30 AM
06-19-2012 07:05 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.LastknownIP, tblComputers.IPNumeric,
tblComputers.Scanserver, tblComputers.OScode, tblComputers.SP,
tblerrors.CFGname, tblerrors.ErrorText, tblerrors.Lastchanged,
tsysDomainPasswords.Username, tsysDomainPasswords.Credtype
From tblComputers Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername Left Join
tsysDomainPasswords On tsysDomainPasswords.Domain = tblComputers.Domain
Order By tblComputers.ComputerUnique, tblerrors.Lastchanged Desc
06-19-2012 11:16 AM
06-19-2012 10:48 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now