Need Assistance with a Registry key report

[Ben-rutherford]

Good Afternoon, 

I am trying to get a report to let me know which channels office is set to update off of, 

I can report on the Key - That is working. But i want to make it easier by replacing the key values with Easily readable values, Or atleast have it in a column 
Here is the report: 

elect Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblRegistry.Valuename,
  tblRegistry.Value
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Valuename = 'UpdateChannel' And tblRegistry.regkey =
  'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration' And
  tblAssetCustom.State = 1

And this is what i want to incorperate 

  Case 
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6" Then 'Monthly Enterprise Channel'
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60" Then 'Current Channel'
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be" Then 'Current Preview'
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114" Then 'Semi Annual Enterprise Channel'
  Else 'Unknown'
  End As [Update Channel] 

[KevinA-REJIS · Accepted solution]

Give this a try, you could remove the tblRegistry.Valuename and tblRegistry.Value if want/need:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblRegistry.Valuename,
  tblRegistry.Value,
Case 
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6" Then 'Monthly Enterprise Channel'
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60" Then 'Current Channel'
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be" Then 'Current Preview'
  When tblRegistry.value = "http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114" Then 'Semi Annual Enterprise Channel'
  Else 'Unknown'
  End As [Update Channel]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Valuename = 'UpdateChannel' And tblRegistry.regkey =
  'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration' And
  tblAssetCustom.State = 1

[Ben-rutherford]

This worked perfectly! Thankyou very much for your assistance!