Multiple Registry Key Report

[atkinsjd]

My company uses a program that contains several software components which do not appear in the Add/Remove Programs list. The versions of these software components are stored in the registry. I have created the appropriate keys under custom scanning and lansweeper is pulling the data successfully. However, I need to develop a report that displays the software versions for each computer in a single line/row.

Computer_A | RegVal_1 | RegVal_2 | RegVal_3
Computer_B | RegVal_1 | RegVal_2 | RegVal_3
Computer_C | RegVal_1 | RegVal_2 | RegVal_3

Any help you could provide would be appreciated.

[atkinsjd]

Thanks for the quick response!

[Hemoco · Accepted solution]

An example can be seen below. Replace what we've marked in bold.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
SubQuery.Value As Value1,
SubQuery1.Value As Value2,
SubQuery2.Value As Value3
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where tblRegistry.Valuename = 'Valuename1') SubQuery On SubQuery.AssetID =
tblAssets.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where tblRegistry.Valuename = 'Valuename2') SubQuery1 On SubQuery1.AssetID =
tblAssets.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where tblRegistry.Valuename = 'Valuename3') SubQuery2 On SubQuery2.AssetID =
tblAssets.AssetID
Order By tblAssets.Domain,
tblAssets.AssetName