08-27-2012 11:15 PM
08-28-2012 12:12 PM
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Lasttried,
tblComputers.Lasttriggered, tblComputers.LastScheduled,
tblComputers.LastActiveScan, tblComputers.LastLsPush, tblComputers.Scanserver,
Web40OSName.OSname, Web40OSName.SP, Web40OSName.OScode, TsysLastscan.CFGcode,
TsysWaittime.CFGname, TsysLastscan.Lasttime, TsysLastscan.Scantime,
TsysWaittime.Waitdays, tblSerialnumber.Product, tblSerialnumber.ProductID,
tblSerialnumber.ProductKey, tblSerialnumber.Lastchanged
From tblComputers Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode Left Join
tblSerialnumber On tblComputers.Computername = tblSerialnumber.Computername
Where TsysWaittime.CFGname = 'SERIALNUMBER'
Order By tblComputers.ComputerUnique, tblSerialnumber.Product
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now