Free Readiness MEMCM / SCCM Windows 11 Report

Benoit LecoursAugust 26 20213 Min Read

Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 8 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intune deployments.

Benoit Lecours

President

SCD Collaborators

Windows 11 was officially announced on June 24th, 2021, and the first ISO was released last week. Windows 11 is coming, and as an SCCM administrator, you must get ready to deploy this new OS. We released a complete post on everything you need to know about this significant OS release. This blog post will focus on Windows 11 readiness. How can you ensure your device is ready to install Windows 11? The best solution as of today is to build an SCCM Windows 11 report to list which device is prepared and which needs attention.

Windows 10 was specifically designed to run on older hardware; Windows 11 requires new hardware, and you’ll not be able to install it on older PCs. Most PCs built in 2019 or later will work with Windows 11, although some exceptions exist. Older hardware is less likely to pass Windows 11’s prerequisite checks. PCs purchased in 2016 or earlier are almost sure to be unsupported.

Windows 11 also requires a Trusted Platform Module (TPM), UEFI firmware (no legacy BIOS allowed) and Secure Boot. Virtually all PCs designed and built since 2015 include TPM 2.0 support, but you might have to go into the firmware settings to enable it.

Here are Microsoft’s official requirements for Windows 11

Processor:	1 gigahertz (GHz) or faster with 2 or more cores on a compatible 64-bit processor or System on a Chip (SoC)
RAM:	4 gigabyte (GB)
Storage:	64 GB or larger storage device
System firmware:	UEFI, Secure Boot capable
TPM:	Trusted Platform Module (TPM) version 2.0
Graphics card:	Compatible with DirectX 12 or later with WDDM 2.0 driver
Display:	High definition (720p) display that is greater than 9” diagonally, 8 bits per colour channel

As you can see, a couple of checks exist to install Windows 11. If you have SCCM installed, you can build a report to find your compliant devices. We have good news for you: We made it for you, and it’s available for free!

Windows 11 Readiness Report

Updated 2023/11/16 :

#1 – Tweaking SQL queries
#2 – Resolving a lot of known issues like CPU, Model, TPM, etc
#3 – The latest Windows 10 version added
#4 – Revamp header experience
#5 – Changing colours and details

Updated 2022/02/17 :

#1 – Supported Intel CPUs included – based on Microsoft compatible list
#2 – Fix pie chart display

Based on Microsoft’s recommendations, we built this report to list which machines could or couldn’t install Windows 11.

Here are the detailed specifications of the report :

List: Device Name, UserName, Client Status, Client Version, OS Edition, OS Version, OS Branch, CPU Speed, Supported Intel CPU, RAM, Free Space, Device Manufacturer, Device Model, Secure Boot Status, UEFI Bios status, TPM version and status.

6 comprehensive pie charts to list a count of compliant devices in each category

Red highlight if a component did not match Microsoft’s minimum requirement

You can scope the report using a Collection or enter a device name to show its status. You can also choose to display only non-compliant devices.

Download the SCCM Windows 11 report

The report is available for free on our shop website. You only need to download the report and install it on your reporting server. You can read our blog post on how to install a report if you need clarification.

We hope this report is helpful. Please share your comments if you have any ideas to improve it!

Comments (20)

11.09.2023 AT 12:25 PM

I was wondering if it is possible for you to update this report for Windows 11 22H2 min?

Hide replies

1 0

Nicolas Pilon

11.10.2023 AT 08:41 AM

Hello JC, Yes we are working on it and planning to release a major update on Windows 11 Readiness report. Thank you Nick

0 0

Pingback: https://jorgep.com/blog/windows-11-compatibility-for-businesses/

Pingback: https://hiddenshard.com/deploy-refresh-and-upgrade-windows-11-sccm-memcm/

Pingback: https://hiddenshard.online/deploy-refresh-and-upgrade-windows-11-sccm-memcm/

mayur4690

05.31.2022 AT 07:39 AM

I have modified the report to add the 8 GB RAM settings but am getting an error "Invalid length Parameter passed to LEFT or SUBSTRING function " any help appreciated. thanks

René Kierstein

04.21.2022 AT 01:39 AM

Great report, would it be possible to extend it to support AMD cpu names? Right now they are just shown as N/A regards

Steve

09.10.2021 AT 04:46 PM

Thank you for the awesome report. Only issue I'm having with it is that the "CPU- More than 1Ghz" graphic for "Yes", which is all of the clients in my environment, is represented in red instead of green. "Yes" for all the other graphics is in green, including "RAM - Moe than 4GB" which is also all of my clients.

stevecoxsanmar

09.10.2021 AT 04:34 PM

This report is awesome, except the "CPU - more than 1Ghz" graphic is displaying "yes" in red. It's pretty obvious, but kind of throws a viewer off at first look.

Sylvester37

09.08.2021 AT 08:39 PM

Thanks great report, I did make a few tweaks to it. I move the “TPM.SpecVersion0 != 'Not Supported'” from the where statement to the join statement. I have some PCs that TPM is disabled in BIOS and were not showing on the report. Deleting it from the where and adding it to the join now all the PCs show up. I know most of the PCs with TPM disabled won’t run Win 11 but my boss will still want to see them on the report. The join looks like this now. LEFT JOIN v_GS_TPM as TPM on TPM.ResourceID = S.ResourceID AND TPM.SpecVersion0 != 'Not Supported' For the CPU generation number I know you can’t really add this to the report but maybe this will help someone else. For mine I’ve created a separate DB with tables of different things I use in a lot of reports (Win 10 build numbers, Office build numbers, PC Types…) . I went thru our CPU list and created a table matching the CPUKey field with the generation number. So the table has the CPUKey field, then the name field (Kaby Lake, Comet Lake, Tiger Lake…) and then the Gen (7th Gen, 8th Gen, 9th Gen…) It took an afternoon of googling to get a good list but now I can easy join that remote DB table to my report to have the generation number in a column. I also added a graph to show 8th gen and higher as yes and the rest as no.

richard.ward

09.02.2021 AT 02:38 AM

Thank you for this report, it is going to be very helpful when we start our migration to Windows 11! The only problem I am having with the legacy version is that both the "SecureBoot Enabled" and "UEFI" Enabled are returning #Error as the value. Is there anything I need to change / enable to get these values returning a Yes or No? I had a look at the Query in the report builder and it seems fine to me, but I may be missing something.

09.03.2021 AT 06:30 AM

I have just received the updated report files and it is working perfectly! Thank you for the quick fix.

jborgschulte2

08.31.2021 AT 03:19 PM

Would it be possible to get a version that's compatible with older versions of SSRS?

09.01.2021 AT 03:57 PM

Just got the update with the legacy version. Huge thanks for all you do!

Brandon

08.27.2021 AT 02:37 PM

I echo the previous comment, this report is really helpful. What are the possibilities of getting data on the supported CPU generation? This report would be 100% comprehensive if it could report back on that. Right now I'm using device collection queries in ConfigMgr which is sloppy, at best.

doug

08.27.2021 AT 08:12 AM

Actually, I just realized what is going on. For that chart, there are no systems that have a value of No. That means Yes is the only value, so yes gets assigned the first color in the color set, which is red. Somewhat confusing at first look.

08.27.2021 AT 08:06 AM

This is a great report! It does have one formatting problem: the SecureBoot Enabled pie chart shows Yes as red and No as green. All the other charts show Yes as green and No as red.

Azulol

10.20.2023 AT 05:03 AM

Hey, did you find out where to change it? The TPM Version pie chart shows as red and not green.

11.10.2023 AT 08:42 AM

Hello Azulol, We are currently updating the report and this request will be take care of during the update. Thanks

11.16.2023 AT 04:16 PM

We update the Asset - Windows 11 Readiness report. You can download from our website. Thanks Give it a try!

Free Readiness MEMCM / SCCM Windows 11 Report

Table of Content

Share

Windows 11 Readiness Report

Download the SCCM Windows 11 report

Share