‎06-26-2012 09:59 PM
‎06-29-2012 01:27 PM
‎06-27-2012 01:54 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.Scanserver, tblComputers.OScode,
tblComputers.SP, tblComputersystem.SystemType, TsysWaittime.CFGname,
TsysLastscan.Lasttime, TsysLastscan.Scantime, tblRegistry.Regkey,
tblRegistry.Valuename, tblRegistry.Value, tblRegistry.Lastchanged,
tblerrors.CFGname As CFGname1, tblerrors.ErrorText, tblerrors.Lastchanged As
Lastchanged1
From tblComputers Left Join
tblRegistry On tblComputers.Computername = tblRegistry.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where TsysWaittime.CFGname = 'registry'
Order By tblComputers.ComputerUnique, tblRegistry.Regkey
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now