→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
atkinsjd
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
atkinsjd
Engaged Sweeper II
Thanks for the quick response!
Hemoco
Lansweeper Alumni
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