Showing posts with label powershell. Show all posts
Showing posts with label powershell. Show all posts

Wednesday, July 24, 2019

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

Wednesday, November 8, 2017

How to read XML using powershell command

PS E:\Win10_SAC_1709\Control> [xml]$XmlDocument = get-content .\DriverGroups.xml
PS E:\Win10_SAC_1709\Control> $XmlDocument

groups
------
groups


PS E:\Win10_SAC_1709\Control> $XmlDocument.group
PS E:\Win10_SAC_1709\Control> $XmlDocument.groups

group
-----
{default, hidden, 213E, 18E5...}


PS E:\Win10_SAC_1709\Control> $XmlDocument.groups.group | ft -a

guid                                   enable Name    Comments
----                                   ------ ----    --------
{00000000-0000-0000-0000-000000000000} True   default default folder (root)
{FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF} True   hidden  This folder contains shared source items that have not been ma...
{40e24ed9-1a13-4da2-a434-0219ad4e7105} True   213E    HP EliteBook Folio 1040 G1
{446b6eec-ae81-4060-9cce-0c525865edf6} False  18E5    HP Elitedesk 800 USDT
{42617501-dbd0-427d-b3dc-a2dc550a631c} False  1992    HP ProBook 645 G1
{cf8166ba-5722-45ff-9b30-aa7e58d7ffa4} False  2129    HP Z840 Workstation
{121569dd-0eb4-4771-9838-bf0cdd465da4} True   WinPE
{11d5ca9b-f2be-45ab-82cf-b0dbb11b938a} True   2270    Folio 1040 G2
{f194946d-bf05-4992-9fe5-ba88314f1330} False  1998    EliteDesk 800 G1 SFF
{c6b8ed4f-6828-485c-822a-0d213c9f71a2} False  18E4    EliteDesk 800 G1 TWR
{48859491-2051-44db-986f-298c27aabca2} False  212A    Z640
{d9e064b6-6ed8-4a0b-a33d-d15127ec0f61} False  805B    705 G2 DM
{719c16f4-d227-4230-a903-193159ecb570} False  805A    705 G2 MT
{8da9ed57-15c2-453b-a31b-8f41459c5501} True   807E    745 G3
{49f21b93-880c-41ba-82ec-9ee7d244dcc8} True   8079    840 G3
{b786bada-aa17-4dbc-8e79-3d926f92383b} False  80D5    Zbook15 G3
{efd6946f-e226-4d91-b342-231fb1918a1f} False  8265    705 G3 MT
{3fc61ad6-0381-46cb-9d01-9db5ecc847e3} True   8266    705 G3 DM
{0b54975f-25ea-4503-8db8-1adae5c368ce} False  2253    ZBook 15 G2
{d062542f-7509-4e66-baa0-5447a5c7f28a} False  1909    ZBook 15 G1
{375766cc-8dd4-43b1-975e-c37b8030d33e} True   8236    Elitebook 745 G4
{637b470a-0622-4953-a54c-c197410731e1} True   828C    EliteBook 840 G4
{d9e41914-8758-4070-ab64-d573931119e4} True   827D    x360 1030 G2
{eab7e4c4-b63b-4b40-b9ec-8070f86b458a} True   828B    X2 612 G2


PS E:\Win10_SAC_1709\Control>