07-10-2012 10:35 PM
07-12-2012 01:05 PM
07-11-2012 07:08 PM
07-11-2012 01:28 PM
Select Distinct tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.Scanserver, Web40OSName.OSname,
Web40OSName.SP, TsysWaittime.CFGname, TsysLastscan.CFGcode,
TsysLastscan.Lasttime, TsysLastscan.Scantime, TsysWaittime.Waitdays,
tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value,
tblRegistry.Lastchanged, tblerrors.CFGname As CFGname1, tblerrors.ErrorText,
tblerrors.Lastchanged As Lastchanged1
From tblComputers Inner Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblRegistry On tblComputers.Computername = tblRegistry.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where TsysWaittime.CFGname = 'REGISTRY' And tblComputers.Computer = 'YourComputer'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now