08-23-2012 01:22 AM
09-13-2012 06:36 PM
08-23-2012 02:59 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, tblerrors.CFGname,
tblerrors.ErrorText, tblerrors.Lastchanged, tblFileVersions.Found,
tblFileVersions.FilePathfull, tblFileVersions.FileVersion,
tblFileVersions.CompanyName, tblFileVersions.Filesize,
tblFileVersions.CreationDate, tblFileVersions.LastAccessed,
tblFileVersions.LastModified, tblFileVersions.Lastchanged As Lastchanged1,
TsysLastscan.CFGcode, TsysWaittime.CFGname As CFGname1, TsysLastscan.Lasttime,
TsysLastscan.Scantime, TsysWaittime.Waitdays, TsysWaittime.Trackchanges,
TsysFiles.VersionID, TsysFiles.Searchfile, TsysFiles.Enabled
From tblComputers Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername Left Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Inner Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode,
TsysFiles
Where tblComputers.Computer = 'YourComputer' And TsysWaittime.CFGname = 'FILES'
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now