How to query number of computers in the collection (multiple collection)

If you have multiple device collection with almost similar name, and is trying to get how many devices are assigned to the collection, use get-cmcollection and also get-cmcollectionmember function in powershell instead of going through it manually in SCCM console

$coll = get-cmcollection -name "*Language Pack for Windows 10 1709*"

$total = 0

foreach ($colname in $coll)

{

    #Write-Output $colname.Name

    if ($colname.Name -match "-install") 

    {

        $membercoll = (get-cmcollectionmember -CollectionName $($colname.Name))

        write-host $colname.Name : $membercoll.count

        $total = $total + 1

    }

} 

$total

OUTPUT

Microsoft Language Pack for Windows 10 1709 Chinese Simplified 20180604 zh-CN-install (device) : 35

Microsoft Language Pack for Windows 10 1709 Chinese Traditional 20180612 zh-TW-install (device) : 4

Microsoft Language Pack for Windows 10 1709 Croatian 20180521 hr-HR-install (device) : 2

Microsoft Language Pack for Windows 10 1709 Czech 20180523 cs-CZ-install (device) : 30

Microsoft Language Pack for Windows 10 1709 Danish 20180517-install (device) : 31

Microsoft Language Pack for Windows 10 1709 Dutch 20180517 nl-NL-install (device) : 86

Microsoft Language Pack for Windows 10 1709 Finish 20180523 fi-FI-install (device) : 1

Microsoft Language Pack for Windows 10 1709 French 20180516 fr-FR-install (device) : 118

Microsoft Language Pack for Windows 10 1709 German (Germany) 1.0 de-DE-install (device) : 1

Microsoft Language Pack for Windows 10 1709 German 1.20180511-install (device) : 510

Microsoft Language Pack for Windows 10 1709 Hungarian 20180521-install (device) : 18

Microsoft Language Pack for Windows 10 1709 Italian 20180808-install (device) : 2

Microsoft Language Pack for Windows 10 1709 Norwegian 20180523 nb-NO-install (device) : 26

Microsoft Language Pack for Windows 10 1709 Polish (Poland) 1.0 en-US-install (device) : 1

Microsoft Language Pack for Windows 10 1709 Polish 20180515-install (device) : 175

Microsoft Language Pack for Windows 10 1709 Russian 20180514 ru-RU-install (device) : 193

Microsoft Language Pack for Windows 10 1709 Spanish 20180516 es-ES-install (device) : 35

Microsoft Language Pack for Windows 10 1709 Swedish 20190410 sv-SE-install (device) : 9

Microsoft Language Pack for Windows 10 1709 Universal test 20181113 en-US-install (device) : 0

19