Windows 11 compatibility report

[AlexKrietsch]

Lansweeper published this great report template that checks your Windows assets for Windows 11 compatibility. 
Windows 11 Requirements Audit - Lansweeper IT Asset Management

However, there is a flaw in this report in that it is marking an asset as failing the "Disk Space > 64 GB" if it detects that there is less than 64 GB of available free space. The actual Windows 11 requirement is that the disk be 64 GB or larger, and the amount of free space you need is highly dependent on several factors.

Whoever built this report decided to check for free space instead, so that means we have several workstations that are marked as failing the compatibility check when they would otherwise update to Windows 11 just fine. For example, a workstation with a 256 GB drive with 60 GB available free space. Obviously available disk space can be a worry in certain situations, but marking machines that have 30,40,50, or 60 GB of free space as incompatible doesn't seem to be the way to go. 

Is there a version of this report that looks at the disk size instead? Or can anyone provide an edited version that does so? 

[tchan]

Recently, I found that some CPU types are supported but not included in the original SQL. I can add them manually.

But I’m encountering a problem with duplicate entries of computer names. It seems that one entry shows a BIOS scan pass, while the second entry shows a BIOS scan fail. Any clues on why these duplicate lines are appearing?

[Esben_D]

BIOS type is determined based on the boot partition type. If you have a duplicate because of that, it might be that you have a boot partitions with mixed types, both "Installable File System" and "GPT" for example.

[BelcoCCU]

The link is no longer working. I'm seeing a "this site can't be reached" error message. Is someone able to fix the link so that this report can be accessed?

[Mister_Nobody]

Try again

[kdunnett1]

When I copy the report from the above page into LS,  I get the following error:

Invalid SELECT statement. Unexpected token ";" at line 35, pos 71.

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysIPLocations.IPLocation,
tblProcessor.Name As CPU,
diskspace.Caption as [Drive Letter],
diskspace.free as [Free Disk Space(GB)],
Case
When CPU.AssetID = tblAssets.AssetID And (TPM.[TPM Version] Is Not Null and TPM.[TPM Version] = 'Pass')
And BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =
diskspace.AssetID Then 'Yes'
Else 'No'
End As [W11 Compatible],
Case
When CPU.AssetID = tblAssets.AssetID Then 'Pass'
Else 'Fail'
End As [CPU Compatible],
Case
When TPM.[TPM Version] Is Null Then 'Fail'
Else TPM.[TPM Version]
End As [TPM Version 2.0],
BIOS.[BIOS Type] As [BIOS Type EUFI],
Case
When SecureBoot.Value = 0 Then 'No'
When SecureBoot.Value = 1 Then 'Yes'
Else 'RegKey not found'
End As [Secure Boot Enabled],
RAM.RAM As [RAM > 4GB],
Case
When tblAssets.AssetID = diskspace.AssetID and diskspace.TotalSize > 64

[Mister_Nobody]

Select by mouse and copy via native copy function. Remove any ; at the end of query

Copy button in report library corrupts sql code. 

[kdunnett1]

This worked.  Thanks!

[Esben_D]

A fix has been implemented. Copy button should work again now.

[Esben_D]

I have forwarded it to the website team. Its the > sign that gets transformed into the text version when you use the copy button...