Refined Report - OS: Windows 11 Requirements Audit

[TVBanks98]

I have made some enhancements and refinements to a number of reports and wanted to share them here.  

This report was introduced here:  https://www.lansweeper.com/itam/is-your-business-ready-for-windows-11/

I have a single computer that is just barely below the supported CPU and have considered using the registry override from the following article to upgrade and see how well it plays.  

https://www.theverge.com/22644194/microsoft-windows-11-minimum-system-requirements-processors-change...

I have added the registry key, but the Lansweeper report does not take this into account and the PC still shows as non-compatible.   I enhanced the report to look for the registry key (Lansweeper registry scan required), but now the report shows whether or not the key exists, and changes the status to "yes" and colors the asset yellow.  

Even if you do not plan to use this method to force upgrade on an unsupported asset, it might make sense to know if any PCs have the key set.  

So here you go........

I added the following left join of the registry scan table

  Left Join (Select Top 1000000 tblRegistry.AssetID,
      tblRegistry.Regkey,
      tblRegistry.Valuename,
      tblRegistry.Value,
      tblRegistry.Lastchanged
    From tblRegistry
    Where tblRegistry.Regkey Like '%SYSTEM\Setup\MoSetup' And
      tblRegistry.Valuename = 'AllowUpgradesWithUnsupportedTPMOrCPU') SubQuery1
    On SubQuery1.AssetID = tblAssets.AssetID

Then pulled its results in to make the compatibility assessment

  Case
    When (CPU.AssetID = tblAssets.AssetID Or
      (SubQuery1.Valuename Is Not Null And SubQuery1.Value = '1')) And
      (TPM.[TPM Version] Is Not Null And TPM.[TPM Version] = 'Pass') And
      BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =
      freespace.AssetID Then 'Yes'
    Else 'No'
  End As [W11 Compatible],

And displayed the result of the registry key evaluation

  Case
    When SubQuery1.Value Is Not Null And SubQuery1.Value = '1' Then 'Yes'
    Else 'No'
  End As [Unsupported CPU/TPM Allowed],

And finally refined the background to include yellow for those PCs with the key set that are otherwise compatible. 

  Case
    When CPU.AssetID = tblAssets.AssetID And TPM.[TPM Version] Is Not Null And
      BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =
      freespace.AssetID Then '#d4f4be'
    When (CPU.AssetID = tblAssets.AssetID Or
      (SubQuery1.Valuename Is Not Null And SubQuery1.Value = '1')) And
      (TPM.[TPM Version] Is Not Null And TPM.[TPM Version] = 'Pass') And
      BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =
      freespace.AssetID Then '#FFD580'
	  Else '#ffadad'
  End As backgroundcolor

Full text was too big for this message, so I've attached it instead.  I hope you find this useful !!

[Mercedes_O]

Thank you for sharing!