‎07-31-2012 11:00 PM
‎08-01-2012 11:27 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.Scanserver, TsysWaittime.CFGCode,
TsysWaittime.CFGname, TsysLastscan.Lasttime, TsysLastscan.Scantime,
TsysWaittime.Waitdays, Web40OSName.OSname, Web40OSName.SP, Web40OSName.OScode,
tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged
From tblComputers Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Where TsysWaittime.CFGname = 'SOFTWARE' And tblComputers.Computer = 'YourComputer'
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now