Find Windows 11 Versions using SCCM | SQL Query | CMPivot Query

In this video I will show you 2 methods to Find Windows 11 versions in SCCM or Configuration Manager.
Method 1 - We will run a #SQL Query that lists all the #Windows11 versions based on the build numbers.
Method 2 - We will use the #SCCM CMPivot query to find all Windows 11 versions.

In SCCM, using the SQL query, you can find Windows 11 version number and build number. Once you do that, you can also create a Windows 11 device collection based on either builds or edition.

Before you run the SQL query, ensure you have installed Configuration Manager client agents on Windows 11 computers. The build number of Windows 11 21H2 is 22000.

[jeremybackes]

Have you created a task sequence to remove the WIndows 11 bloatware? If so can you provide me with some insight?

Thanks,

[mdmohiuddinchy]

Hi Prajwal
Good day! Need one suggestion from you. we have secondary site and some remote site with DP, sending package from seconday site server to local DP consumes bandwidth, (example India to Bangladesh) is there any way i can upload the offline package content to site DP manually. Or which content file is for specific application that i can copy and put manually in DP server. your advise please on this regards

[aniketshabu]

@PrajwalDesai
Sir I am a huge fan of yours. Do you have a minute to talk? If yes then please reply.