SCCM Query based on current Windows 10 CU

[nathan_bird]

Hi All,

 

Apologies if I've missed it elsewhere (Numerous Google searches drew a blank too) but has anybody got a query for the Current CU Level of a Windows 10 build?

 

The version displayed in "winver"

 

I know I can do a search on the KB Article via Quick Fix Engineering in WMI but if a machine has multiple CU's installed it shows in more than one collection. I want individual collections based on the CU OS Build Number.

 

i.e 14393.105 (Windows 10 1607 with KB317493)

 

Any pointers would be appreciated.

 

Cheers!

 

 

[GarthMJ]

To be clear, are you looking for a CM query (aka for a collection) or CM report? if you are looking for a Collection query, I have to ask why...

[nathan_bird]

GarthMJ, on 12 Sept 2016 - 3:37 PM, said:

To be clear, are you looking for a CM query (aka for a collection) or CM report? if you are looking for a Collection query, I have to ask why...

 

Either. If I can give my security manager a list of W10 machines and their current CU Level each month he's happy. If its a collection I can pull the members for each via PowerShell. If its a SQL Query then i'll build a simple report.

[GarthMJ]

Have you looked at using the Version number listed under the OS node within Resource Explorer?

A report will be allot easier to create.

[nathan_bird]

Have you looked at using the Version number listed under the OS node within Resource Explorer?

A report will be allot easier to create.

Yes Garth but that doesn't give the me the current Build Number (as listed on release info TechNet page) I'll plug away at it, there has to be a way

 

https://technet.microsoft.com/en-gb/windows/mt679505.aspx?ocid=wc-ext-aka

[GarthMJ]

I just checked and it is listed twice within the class.

 

[anyweb]

have you seen my blog post here ?

 

https://www.niallbrady.com/2016/05/13/how-can-i-use-powershell-to-populate-windows-10-cb-cbb-ltsb-and-insider-preview-collections-in-system-center-configuration-manager-current-branch/