Is Not Null Andįull text was too big for this message, so I've attached it instead. The report below provides a list of all Windows 11 and Windows Server 2022 devices that have KB5015814/KB5015827 or higher installed by looking at the. When CPU.AssetID = tblAssets.AssetID And TPM. When SubQuery1.Value Is Not Null And SubQuery1.Value = '1' Then 'Yes'Īnd finally refined the background to include yellow for those PCs with the key set that are otherwise compatible. = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =Īnd displayed the result of the registry key evaluation (SubQuery1.Valuename Is Not Null And SubQuery1.Value = '1')) And be activated using Windows 11 Professional Key Code Activation Online Win 11. Then pulled its results in to make the compatibility assessment Lansweeper cannot recover Microsoft MAK keys, as these are not stored on. TblRegistry.Valuename = 'AllowUpgradesWithUnsupportedTPMOrCPU') SubQuery1 Where tblRegistry.Regkey Like '%SYSTEM\Setup\MoSetup' And Left Join (Select Top 1000000 tblRegistry.AssetID, I added the following left join of the registry scan table 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.Įven 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. Additionally, you can find all our built-in reports and some community reports in the Reports Center here on the forum. Since there are many free online courses which teach the basics of SQL we generally advice people interested in custom reports to try those. I have added the registry key, but the Lansweeper report does not take this into account and the PC still shows as non-compatible. Lansweeper reports are made in a standard SQL editor. Im hoping the list of processors the readiness report uses is early and incomplete. The MS general requirement says '1 gigahertz (GHz) or faster with 2 or more cores on a compatible 64-bit processor'. 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. I ran the report and found 4 out of 142 Windows 10 PCs ready to upgrade to Win 11. I have made some enhancements and refinements to a number of reports and wanted to share them here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |