‎05-01-2012 12:57 AM
Solved! Go to Solution.
‎08-17-2017 03:17 PM
Select tblAssets.AssetName,
tblAssets.AssetUnique,
tblAssets.Domain,
tblADusers.Firstname,
tblADusers.Lastname,
FirstKey.Detect,
SecondKey.Download,
ThirdKey.Install
From tblAssets
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value As Download
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Download') SecondKey On SecondKey.AssetID = tblAssets.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value As Install
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install') ThirdKey On ThirdKey.AssetID = tblAssets.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value As Detect
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect') FirstKey On FirstKey.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Order By tblAssets.AssetUnique
‎05-25-2012 01:53 PM
‎05-24-2012 11:05 PM
‎05-24-2012 09:43 PM
‎05-24-2012 07:31 PM
‎05-24-2012 06:11 PM
‎05-24-2012 04:25 PM
‎05-03-2012 11:41 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblADusers.Firstname, tblADusers.Lastname,
FirstKey.Detect, SecondKey.Download, ThirdKey.Install
From tblComputers Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Value As
Download
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Download') SecondKey On SecondKey.Computername = tblComputers.Computername Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Value As
Install
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install') ThirdKey On ThirdKey.Computername = tblComputers.Computername Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Value As
Detect
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect') FirstKey On FirstKey.Computername = tblComputers.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Order By tblComputers.ComputerUnique
‎05-06-2012 04:22 AM
‎05-16-2012 08:08 PM
‎05-03-2012 06:46 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now