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? 

[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...

[eriqjaffe1]

I can't seem to find the version of this report that is looking at disk capacity instead of free space, does that version of the report really exist?

[Esben_D]

https://www.lansweeper.com/report/windows-11-requirements-audit/ 

The report contains both a free disk space column and a disk space check column

[eriqjaffe1]

Thanks, but I'm only seeing a "Disk Space > 64GB" column, which appears to be looking at free space and not actual disk capacity.  The "fail" on this is a system that has a 256gb SSD, although only 8.7gb free which I think is why it's failing.  I was expecting to see a "pass" there because the disk does meet requirements.

Would it be possible to amend the report to mark systems like that in yellow to indicate that it is capable but needs intervention?

[Esben_D]

Hmm, well this is the subquery used for the disk space. You can use that to verify what the bigger report is using as raw data, any asset listed here should pass the test.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 / 1024 As numeric) As
free,
Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric) As TotalSize,
tblComputersystem.SystemType
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblComputersystem On
tblAssets.AssetID = tblComputersystem.AssetID
Where Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric)
> 64

[TobyLa]

Just in case someone needs an updateded version of the compatibility list including some of the newer supported CPUs: here you go. I formated the list on the Microsoft Site for AMD and Intel with Excel and created a very long list of cpus.

This fixed my problem with some new notebooks which were marked as incompatible. Unfortunately the list exceeds the 40.000 characters allowed in this comment section. But you can simply download it from my gdrive: https://drive.google.com/file/d/1YiN6Xe1l2AtNOUQyoP47R70zfYROGJND/view?usp=sharing

The URL should open a text preview for you where copy/paste the content whithout downloading the sql-file.

Hope this helps

[Esben_D · Accepted solution]

Thanks for the feedback! I've updated the report to ensure it looks at disk capacity instead of free space. I also added free space as one of the columns as I think it's still useful info to have.