ConfigMgr – Page 2 – Anything about IT

Use PowerShell to find all collections where the specified device has a membership

Posted on14 October 20142 January 20194 Comments

Yesterday I deployed a computer with ConfigMgr and then wondered why it got certain software installed. And so another script was born. The Get-CMCollectionOfDevice command retrieves all collections where the specified device has a membership The Script can be downloaded from here

<#
.SYNOPSIS
    Get-CMCollectionOfDevice retrieves all collections where the specified device has a membership

.DESCRIPTION
    The Get-CMCollectionOfDevice retrieves all collections where the specified device has a membership

.PARAMETER Computer
    The name of the computer device

    Example: Client01

.PARAMETER SiteCode
    The Configuration Manager Site Code

    Example: PRI

.PARAMETER SiteServer
    The computer name of the Configuration Manager Site Server

    Example: Contoso-01

.EXAMPLE
    Get-CMCollectionOfDevice -Computer Client01


    CollectionID                  Name                          Commnent                      LastRefreshTime             
    ------------                  ----                          --------                      ---------------             
    SMS00001                      All Systems                   All Systems                   14.10.2014 14:25:57         
    SMSDM003                      All Desktop and Server Cli... All Desktop and Server Cli... 14.10.2014 14:30:02         
    PR100011                      ALL Contoso  Workstation Lim. Limiting collection used f... 14.10.2014 16:37:53         
    PR100014                      Zurich                        Location Zuerich              14.10.2014 14:45:53         


    The above command lists all collections where computer Client01 is a member of. The default
    parameter values for SiteCode and SiteServer defined in the script are used. 

.EXAMPLE
    Get-CMCollectionOfDevice -Computer Client01 -SiteCode PRI -SiteServer Contoso-01
    
    The above command lists all collections where computer Client01 is a member of within the
    Configuration Manager site PRI connecting to Site Server Contoso-01

.NOTES
    Version 1.0 , Alex Verboon
    Credits to Kaido Järvemets and David O'Brien for the code snippets
#>

function Get-CMCollectionOfDevice
{
    [CmdletBinding()]
    [OutputType([int])]
    Param
    (
        # Computername
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=0)]
        [String]$Computer,

        # ConfigMgr SiteCode
        [Parameter(Mandatory=$false,
                   ValueFromPipelineByPropertyName=$true,
                   Position=1)]
        [String]$SiteCode = "PRI",

        # ConfigMgr SiteServer
        [Parameter(Mandatory=$false,
                   ValueFromPipelineByPropertyName=$true,
                   Position=2)]
        [String]$SiteServer = "contoso-01.corp.com"
    )
Begin
{
    [string] $Namespace = "root\SMS\site_$SiteCode"
}

Process
{
    $si=1
    Write-Progress -Activity "Retrieving ResourceID for computer $computer" -Status "Retrieving data" 
    $ResIDQuery = Get-WmiObject -ComputerName $SiteServer -Namespace $Namespace -Class "SMS_R_SYSTEM" -Filter "Name='$Computer'"
    
    If ([string]::IsNullOrEmpty($ResIDQuery))
    {
        Write-Output "System $Computer does not exist in Site $SiteCode"
    }
    Else
    {
    $Collections = (Get-WmiObject -ComputerName $SiteServer -Class sms_fullcollectionmembership -Namespace $Namespace -Filter "ResourceID = '$($ResIDQuery.ResourceId)'")
    $colcount = $Collections.Count
    
    $devicecollections = @()
    ForEach ($res in $collections)
    {
        $colid = $res.CollectionID
        Write-Progress -Activity "Processing  $si / $colcount" -Status "Retrieving Collection data" -PercentComplete (($si / $colcount) * 100)

        $collectioninfo = Get-WmiObject -ComputerName $SiteServer -Namespace $Namespace -Class "SMS_Collection" -Filter "CollectionID='$colid'"
        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "CollectionID" -Value $collectioninfo.CollectionID
        $object | Add-Member -MemberType NoteProperty -Name "Name" -Value $collectioninfo.Name
        $object | Add-Member -MemberType NoteProperty -Name "Commnent" -Value $collectioninfo.Comment
        $object | Add-Member -MemberType NoteProperty -Name "LastRefreshTime" -Value ([Management.ManagementDateTimeConverter]::ToDateTime($collectioninfo.LastRefreshTime))
        $devicecollections += $object
        $si++
    }
} # end check system exists
}

End
{
    $devicecollections
}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

.SYNOPSIS

Get-CMCollectionOfDevice retrieves all collections where the specified device has a membership

.DESCRIPTION

The Get-CMCollectionOfDevice retrieves all collections where the specified device has a membership

.PARAMETER Computer

The name of the computer device

Example: Client01

.PARAMETER SiteCode

The Configuration Manager Site Code

Example: PRI

.PARAMETER SiteServer

The computer name of the Configuration Manager Site Server

Example: Contoso-01

.EXAMPLE

Get-CMCollectionOfDevice -Computer Client01

CollectionID Name Commnent LastRefreshTime

------------ ---- -------- ---------------

SMS00001 All Systems All Systems 14.10.2014 14:25:57

SMSDM003 All Desktop and Server Cli... All Desktop and Server Cli... 14.10.2014 14:30:02

PR100011 ALL Contoso Workstation Lim. Limiting collection used f... 14.10.2014 16:37:53

PR100014 Zurich Location Zuerich 14.10.2014 14:45:53

The above command lists all collections where computer Client01 is a member of. The default

parameter values for SiteCode and SiteServer defined in the script are used.

.EXAMPLE

Get-CMCollectionOfDevice -Computer Client01 -SiteCode PRI -SiteServer Contoso-01

The above command lists all collections where computer Client01 is a member of within the

Configuration Manager site PRI connecting to Site Server Contoso-01

.NOTES

Version 1.0 , Alex Verboon

Credits to Kaido Järvemets and David O'Brien for the code snippets

function Get-CMCollectionOfDevice

{

[CmdletBinding()]

[OutputType([int])]

Param

(

# Computername

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=0)]

[String]$Computer,

# ConfigMgr SiteCode

[Parameter(Mandatory=$false,

ValueFromPipelineByPropertyName=$true,

Position=1)]

[String]$SiteCode = "PRI",

# ConfigMgr SiteServer

[Parameter(Mandatory=$false,

ValueFromPipelineByPropertyName=$true,

Position=2)]

[String]$SiteServer = "contoso-01.corp.com"

)

Begin

{

[string] $Namespace = "root\SMS\site_$SiteCode"

}

Process

{

$si=1

Write-Progress -Activity "Retrieving ResourceID for computer $computer" -Status "Retrieving data"

$ResIDQuery = Get-WmiObject -ComputerName $SiteServer -Namespace $Namespace -Class "SMS_R_SYSTEM" -Filter "Name='$Computer'"

If ([string]::IsNullOrEmpty($ResIDQuery))

{

Write-Output "System $Computer does not exist in Site $SiteCode"

}

Else

{

$Collections = (Get-WmiObject -ComputerName $SiteServer -Class sms_fullcollectionmembership -Namespace $Namespace -Filter "ResourceID = '$($ResIDQuery.ResourceId)'")

$colcount = $Collections.Count

$devicecollections = @()

ForEach ($res in $collections)

{

$colid = $res.CollectionID

Write-Progress -Activity "Processing $si / $colcount" -Status "Retrieving Collection data" -PercentComplete (($si / $colcount) * 100)

$collectioninfo = Get-WmiObject -ComputerName $SiteServer -Namespace $Namespace -Class "SMS_Collection" -Filter "CollectionID='$colid'"

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "CollectionID" -Value $collectioninfo.CollectionID

$object | Add-Member -MemberType NoteProperty -Name "Name" -Value $collectioninfo.Name

$object | Add-Member -MemberType NoteProperty -Name "Commnent" -Value $collectioninfo.Comment

$object | Add-Member -MemberType NoteProperty -Name "LastRefreshTime" -Value ([Management.ManagementDateTimeConverter]::ToDateTime($collectioninfo.LastRefreshTime))

$devicecollections += $object

$si++

}

} # end check system exists

}

End

{

$devicecollections

}

How to identify ConfigMgr collections that take long to refresh

Posted on30 August 201430 August 2014Leave a comment

I’ve put together the below PowerShell script this week to identify collections in ConfigMgr that require the longest time to refresh. If you ever experience a decrease in ConfigMgr collection update performance, you might want to run this script to find potential collections that have a long refresh duration.

Function Get-CMCollectionRefreshDuration
{
<#
.Synopsis
   Get-CMCollectionRefreshDuration displays the duration of Configuration Manager refresh cycles
.DESCRIPTION
   Inefficient queries can cause long collection refresh cycles. Use the Get-CMCollectionRefreshDuration
   cmdlet to identify collections with long refresh cycles. 
.EXAMPLE
   Get-CMCollectionRefreshDuration -DataSource sqlsrv01\instance1 -Database CM_DB1

    Collection                   EvaluationStartTime          LastRefreshTime              Duration
    ----------                   -------------------          ---------------              --------
    Collection1                  30.08.2014 09:20:11          30.08.2014 09:22:45          00:02:33
    Collection2                  30.08.2014 09:27:31          30.08.2014 09:30:05          00:02:33
    Collection3                  30.08.2014 07:01:23          30.08.2014 07:03:56          00:02:33
    Collection4                  30.08.2014 07:20:38          30.08.2014 07:23:11          00:02:33
    Collection5                  30.08.2014 07:05:00          30.08.2014 07:07:33          00:02:33 

.EXAMPLE
   Get-CMCollectionRefreshDuration -DataSource sqlsrv01\instance1 -Database CM_DB1 -ShowTopCollections 100

   Lists the top 100 collections
.PARAMETER DataSource
   The name of the SQL Server that hosts the configuration manager database

   <servername\instance>

.PARAMETER Database
   The database name of the configuration manager database

.PARAMETER ShowTopCollections
   The number of collections to show that have the longers collection refresh cycle duration

#>
    [CmdletBinding()]
    Param
    (
     [Parameter(Mandatory=$false,
     Position=0,
     HelpMessage="Enter the SQL Server datasource name <server\instance>")]
     [string]$DataSource="server01\instance1",
     [Parameter(Mandatory=$false,
     Position=1,
     HelpMessage="The database name of the ConfigMgr database")]
     [string]$Database="CMDB1",
     [Parameter(Mandatory=$false,
     Position=2,
     HelpMessage="The number of top collectons to show")]
     [ValidateRange(1,10000)]
     [int]$ShowTopCollections="5" 
    )

Begin{
    # connecting to SQL server
    Try{
    $Connection = New-Object System.Data.SqlClient.SqlConnection
    $Connection.ConnectionString = "Data Source=$DataSource;Integrated Security=True"
    $Connection.Open()
    }
    Catch [Exception]
    {
        write-output "Unable to connect to $DataSource"
        Write-Output $_.Exception
        Throw
    }
    $query = "
    SELECT TOP $ShowTopCollections
        [CollectionName],
        [EvaluationStartTime],
        [LastRefreshTime],
        CAST([LastRefreshTime] - [EvaluationStartTime] as datetime) as Duration
    FROM [$Database].[dbo].[Collections]
    ORDER BY CAST([LastRefreshTime] - [EvaluationStartTime] as datetime) DESC"

    $command = $connection.CreateCommand()
    $command.CommandText = $query
    $result = $command.ExecuteReader()

    $table = new-object “System.Data.DataTable”
    $table.Load($result)
    $Connection.Close()
}

Process{
    $colupdateduration = @()
    ForEach($cud in $table)
    {
        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "Collection" -Value $cud.Collectionname
        $object | Add-Member -MemberType NoteProperty -Name "EvaluationStartTime" -Value $cud.EvaluationStartTime
        $object | Add-Member -MemberType NoteProperty -Name "LastRefreshTime" -Value $cud.LastRefreshTime
        $object | Add-Member -MemberType NoteProperty -Name "Duration" -Value ($dur = Get-date $cud.Duration -Format "HH:mm:ss")
        $colupdateduration += $object
    }
}

End{
    $colupdateduration
    }
}

100

101

Function Get-CMCollectionRefreshDuration

{

.Synopsis

Get-CMCollectionRefreshDuration displays the duration of Configuration Manager refresh cycles

.DESCRIPTION

Inefficient queries can cause long collection refresh cycles. Use the Get-CMCollectionRefreshDuration

cmdlet to identify collections with long refresh cycles.

.EXAMPLE

Get-CMCollectionRefreshDuration -DataSource sqlsrv01\instance1 -Database CM_DB1

Collection EvaluationStartTime LastRefreshTime Duration

---------- ------------------- --------------- --------

Collection1 30.08.2014 09:20:11 30.08.2014 09:22:45 00:02:33

Collection2 30.08.2014 09:27:31 30.08.2014 09:30:05 00:02:33

Collection3 30.08.2014 07:01:23 30.08.2014 07:03:56 00:02:33

Collection4 30.08.2014 07:20:38 30.08.2014 07:23:11 00:02:33

Collection5 30.08.2014 07:05:00 30.08.2014 07:07:33 00:02:33

.EXAMPLE

Get-CMCollectionRefreshDuration -DataSource sqlsrv01\instance1 -Database CM_DB1 -ShowTopCollections 100

Lists the top 100 collections

.PARAMETER DataSource

The name of the SQL Server that hosts the configuration manager database

<servername\instance>

.PARAMETER Database

The database name of the configuration manager database

.PARAMETER ShowTopCollections

The number of collections to show that have the longers collection refresh cycle duration

[CmdletBinding()]

Param

(

[Parameter(Mandatory=$false,

Position=0,

HelpMessage="Enter the SQL Server datasource name <server\instance>")]

[string]$DataSource="server01\instance1",

[Parameter(Mandatory=$false,

Position=1,

HelpMessage="The database name of the ConfigMgr database")]

[string]$Database="CMDB1",

[Parameter(Mandatory=$false,

Position=2,

HelpMessage="The number of top collectons to show")]

[ValidateRange(1,10000)]

[int]$ShowTopCollections="5"

)

Begin{

# connecting to SQL server

Try{

$Connection = New-Object System.Data.SqlClient.SqlConnection

$Connection.ConnectionString = "Data Source=$DataSource;Integrated Security=True"

$Connection.Open()

}

Catch [Exception]

{

write-output "Unable to connect to $DataSource"

Write-Output $_.Exception

Throw

}

$query = "

SELECT TOP $ShowTopCollections

[CollectionName],

[EvaluationStartTime],

[LastRefreshTime],

CAST([LastRefreshTime] - [EvaluationStartTime] as datetime) as Duration

FROM [$Database].[dbo].[Collections]

ORDER BY CAST([LastRefreshTime] - [EvaluationStartTime] as datetime) DESC"

$command = $connection.CreateCommand()

$command.CommandText = $query

$result = $command.ExecuteReader()

$table = new-object “System.Data.DataTable”

$table.Load($result)

$Connection.Close()

}

Process{

$colupdateduration = @()

ForEach($cud in $table)

{

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "Collection" -Value $cud.Collectionname

$object | Add-Member -MemberType NoteProperty -Name "EvaluationStartTime" -Value $cud.EvaluationStartTime

$object | Add-Member -MemberType NoteProperty -Name "LastRefreshTime" -Value $cud.LastRefreshTime

$object | Add-Member -MemberType NoteProperty -Name "Duration" -Value ($dur = Get-date $cud.Duration -Format "HH:mm:ss")

$colupdateduration += $object

}

End{

$colupdateduration

}

Thanks to Roger Zander and Claude Henchoz for the SQL query to find these collections.

PowerShell Script – Get-CMInstalledSoftware

Posted on8 August 201410 August 2014Leave a comment

ConfigMgr 2012 comes with a lot of build-in reports, but often it just does not contain all the information I want. Creating a custom report takes more time than just writing a script. The Get-CMInstalledSoftware script retrieves all computers that have the specified software installed. Like it? Get your copy of the script from here

<#
.Synopsis
   Get all computers that have the specified software installed
.DESCRIPTION
   Get-CMInstalledSoftware retrieves all computers where the specified software is installed on. 
   The function queries SMS_G_System_INSTALLED_SOFTWARE which contains both 32 and 64 bit software
   installations.

   The following information is collected
   
   Computername,OperatingSystemNameandVersion InstallDate, InstalledLocation, Productname, ProductVersion
   Publisher, UninstallString

.EXAMPLE
   Get-CMInstalledSoftware -ProductName "Client Center for Configuration Manager%"

    Computername                  : Client01
    OperatingSystemNameandVersion : Microsoft Windows NT Workstation 6.1
    Productname                   : Client Center for Configuration Manager 2012
    ProductVersion                : 1.0.1.0
    Publisher                     : Zander Tools
    InstallDate                   : Friday, 1. August 2014 00:00:00
    InstalledLocation             : C:\Program Files\Client Center for Configuration Manager 2012\
    UninstallString               : MsiExec.exe /X{B299EE26-A664-42A2-8D4E-6BF005EB5E75}

.PARAMETER -ProductName
   The Name of the Software. Use % before or after the productname as a wildcard. 
  
#>

Function Get-CMInstalledSoftware
{
    [CmdletBinding()]
    [OutputType([int])]
    Param
    (
        # Software Product Name
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=0)]
        $ProductName,

        [Parameter(Mandatory=$false,
                   ValueFromPipelineByPropertyName=$true,
                   Position=1)]
        $SiteCode = "SR1",

        [Parameter(Mandatory=$false,
                   ValueFromPipelineByPropertyName=$true,
                   Position=2)]
        $SiteServer = "chrv0300.corp.gwpnet.com"
    )


Begin
{
    [string] $Namespace = "root\SMS\site_$SiteCode"
}


Process
{
    $arsw = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT * FROM SMS_G_System_INSTALLED_SOFTWARE where ProductName like '$ProductName'" # and ProductVersion = '11.0.61030.0'"
    $clientswithsw = @()

    ForEach ($res in $arsw)
    {
        $CMResource = (Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name, ResourceID,Active, SMSUniqueIdentifier,OperatingSystemNameandVersion FROM SMS_R_SYSTEM WHERE ResourceID = '$($res.ResourceID)'")

        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "Computername" -Value $cmresource.Name
        $object | Add-Member -MemberType NoteProperty -Name "OperatingSystemNameandVersion" -Value $cmresource.OperatingSystemNameandVersion
        $object | Add-Member -MemberType NoteProperty -Name "Productname" -Value $res.ProductName
        $object | Add-Member -MemberType NoteProperty -Name "ProductVersion" -Value $res.ProductVersion
        $object | Add-Member -MemberType NoteProperty -Name "Publisher" -Value $res.Publisher
        $object | Add-Member -MemberType NoteProperty -Name "InstallDate" -Value ([Management.ManagementDateTimeConverter]::ToDateTime($res.InstallDate).DateTime)
        $object | Add-Member -MemberType NoteProperty -Name "InstalledLocation" -Value $res.InstalledLocation
        $object | Add-Member -MemberType NoteProperty -Name "UninstallString" -Value $res.UninstallString

        $clientswithsw += $object
    }
}

End
{
    $clientswithsw
}
}

.Synopsis

Get all computers that have the specified software installed

.DESCRIPTION

Get-CMInstalledSoftware retrieves all computers where the specified software is installed on.

The function queries SMS_G_System_INSTALLED_SOFTWARE which contains both 32 and 64 bit software

installations.

The following information is collected

Computername,OperatingSystemNameandVersion InstallDate, InstalledLocation, Productname, ProductVersion

Publisher, UninstallString

.EXAMPLE

Get-CMInstalledSoftware -ProductName "Client Center for Configuration Manager%"

Computername : Client01

OperatingSystemNameandVersion : Microsoft Windows NT Workstation 6.1

Productname : Client Center for Configuration Manager 2012

ProductVersion : 1.0.1.0

Publisher : Zander Tools

InstallDate : Friday, 1. August 2014 00:00:00

InstalledLocation : C:\Program Files\Client Center for Configuration Manager 2012\

UninstallString : MsiExec.exe /X{B299EE26-A664-42A2-8D4E-6BF005EB5E75}

.PARAMETER -ProductName

The Name of the Software. Use % before or after the productname as a wildcard.

Function Get-CMInstalledSoftware

{

[CmdletBinding()]

[OutputType([int])]

Param

(

# Software Product Name

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=0)]

$ProductName,

[Parameter(Mandatory=$false,

ValueFromPipelineByPropertyName=$true,

Position=1)]

$SiteCode = "SR1",

[Parameter(Mandatory=$false,

ValueFromPipelineByPropertyName=$true,

Position=2)]

$SiteServer = "chrv0300.corp.gwpnet.com"

)

Begin

{

[string] $Namespace = "root\SMS\site_$SiteCode"

}

Process

{

$arsw = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT * FROM SMS_G_System_INSTALLED_SOFTWARE where ProductName like '$ProductName'" # and ProductVersion = '11.0.61030.0'"

$clientswithsw = @()

ForEach ($res in $arsw)

{

$CMResource = (Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name, ResourceID,Active, SMSUniqueIdentifier,OperatingSystemNameandVersion FROM SMS_R_SYSTEM WHERE ResourceID = '$($res.ResourceID)'")

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "Computername" -Value $cmresource.Name

$object | Add-Member -MemberType NoteProperty -Name "OperatingSystemNameandVersion" -Value $cmresource.OperatingSystemNameandVersion

$object | Add-Member -MemberType NoteProperty -Name "Productname" -Value $res.ProductName

$object | Add-Member -MemberType NoteProperty -Name "ProductVersion" -Value $res.ProductVersion

$object | Add-Member -MemberType NoteProperty -Name "Publisher" -Value $res.Publisher

$object | Add-Member -MemberType NoteProperty -Name "InstallDate" -Value ([Management.ManagementDateTimeConverter]::ToDateTime($res.InstallDate).DateTime)

$object | Add-Member -MemberType NoteProperty -Name "InstalledLocation" -Value $res.InstalledLocation

$object | Add-Member -MemberType NoteProperty -Name "UninstallString" -Value $res.UninstallString

$clientswithsw += $object

}

End

{

$clientswithsw

}

Have a good day

ConfigMgr – How to find the Application Name for a ContentID

Posted on3 June 201412 June 20142 Comments

While reviewing ConfigMgr status messages for clients reporting problems acquiring package content (Message ID 10025) I found some code snippets on sccmfaq.ch that maps the ContentID to the name of the application. As i had to do several lookups, I decided to create a function for it.

function Get-xCMContentIDforApp
{
&lt;#
.Synopsis
    Get-xCMContentIDforApp
.DESCRIPTION
   This function retrieves the Application name for the provided ContentID. 
   Use this when analyzing status messages (10025) for clients reporting problems
   acquiring package content   

.EXAMPLE
    Get-xCMContentIDforApp -SiteServer cmsrv01 -SiteCode lab -ContentID Content_4783c44a-3f5c-4bf3-a130-a89e5520173a, Content_1d336090-12e4-445b-9c15-718ee5ddf40a

    Application                             ContentID                                      
    -----------                             ---------                                      
    Mozilla Firefox_SW10012130              Content_4783c44a-3f5c-4bf3-a130-a89e5520173a   
    Microsoft Excel 2010 x64_SW10011686_V   Content_1d336090-12e4-445b-9c15-718ee5ddf40a   

    The above example retrieves the Application name for each contentID provided. 

.NOTES
 Credits to sccmfaq.ch where i found the code snippets
#http://sccmfaq.wordpress.com/2014/03/11/sccm-2012-get-from-content-id-to-the-name-of-an-application-with-powershell/
 Version 1.0 by Alex Verboon
#&gt;



[CmdletBinding(SupportsShouldProcess=$true)]
    Param
    (
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=0)]
        $SiteServer,
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=1)]
        $SiteCode,
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=2)]
        [string[]]$ContentID
    )

Begin{}
Process
{
    $CIDApps = @()

    ForEach ($cid in $ContentID)
    {

    If ($PScmdlet.ShouldProcess("Retrieving Application Name for  $cid"))
    {
        $ContenId01 = (("$cid").Split("."))[0]
        $ApplicationID = (Get-WmiObject -Namespace root\sms\site_$SiteCode -ComputerName $SiteServer -Class SMS_Deploymenttype -Filter "ContentID = '$ContenId01' and PriorityInLatestApp = '1'").AppModelName
        $App = (Get-WmiObject -Namespace root\sms\site_$SiteCode -ComputerName $SiteServer -Class SMS_Application -Filter "CI_UniqueID like '$ApplicationID%' and IsLatest = 'True'").LocalizedDisplayName

        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "Application" -Value $App
        $object | Add-Member -MemberType NoteProperty -Name "ContentID" -Value $cid
        $CIDApps += $object
        }
    }
}
End
{
    $CIDApps | Select-Object Application, ContentID 
}
}

function Get-xCMContentIDforApp

{

.Synopsis

Get-xCMContentIDforApp

.DESCRIPTION

This function retrieves the Application name for the provided ContentID.

Use this when analyzing status messages (10025) for clients reporting problems

acquiring package content

.EXAMPLE

Get-xCMContentIDforApp -SiteServer cmsrv01 -SiteCode lab -ContentID Content_4783c44a-3f5c-4bf3-a130-a89e5520173a, Content_1d336090-12e4-445b-9c15-718ee5ddf40a

Application ContentID

----------- ---------

Mozilla Firefox_SW10012130 Content_4783c44a-3f5c-4bf3-a130-a89e5520173a

Microsoft Excel 2010 x64_SW10011686_V Content_1d336090-12e4-445b-9c15-718ee5ddf40a

The above example retrieves the Application name for each contentID provided.

.NOTES

Credits to sccmfaq.ch where i found the code snippets

#http://sccmfaq.wordpress.com/2014/03/11/sccm-2012-get-from-content-id-to-the-name-of-an-application-with-powershell/

Version 1.0 by Alex Verboon

[CmdletBinding(SupportsShouldProcess=$true)]

Param

(

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=0)]

$SiteServer,

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=1)]

$SiteCode,

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=2)]

[string[]]$ContentID

)

Begin{}

Process

{

$CIDApps = @()

ForEach ($cid in $ContentID)

{

If ($PScmdlet.ShouldProcess("Retrieving Application Name for $cid"))

{

$ContenId01 = (("$cid").Split("."))[0]

$ApplicationID = (Get-WmiObject -Namespace root\sms\site_$SiteCode -ComputerName $SiteServer -Class SMS_Deploymenttype -Filter "ContentID = '$ContenId01' and PriorityInLatestApp = '1'").AppModelName

$App = (Get-WmiObject -Namespace root\sms\site_$SiteCode -ComputerName $SiteServer -Class SMS_Application -Filter "CI_UniqueID like '$ApplicationID%' and IsLatest = 'True'").LocalizedDisplayName

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "Application" -Value $App

$object | Add-Member -MemberType NoteProperty -Name "ContentID" -Value $cid

$CIDApps += $object

}

End

{

$CIDApps | Select-Object Application, ContentID

}

ConfigMgr – PowerShell Script to list Image Binary Delta Replication Setting

Posted on19 May 2014Leave a comment

Here’s a script that lists all Boot and Operating system images stored within Configuration Manager and shows whether the Binary Delta Replication Setting is enabled or not.

&lt;#
.Synopsis
   List Binary Delta Replication Setting for ConfigMgr Boot and Operating System images
.DESCRIPTION
   This cmdlet Lists ConfigMgr the Boot image and Operating System image Binary Delta Replication Setting
.EXAMPLE

.EXAMPLE
   Another example of how to use this cmdlet
.NOTES
 #http://msdn.microsoft.com/en-us/library/hh948196.aspx
 Version 1.0 by Alex Verboon

#&gt;
function Get-CMImgBDRSetting
{
    [CmdletBinding()]
    Param
    (
        # Param1 help description
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=0)]
        $SiteCode,
        [Parameter(Mandatory=$true,
                   ValueFromPipelineByPropertyName=$true,
                   Position=1)]
        $SiteServer
    )

    Begin
    {
    [string] $Namespace = "root\SMS\site_$SiteCode"
    $allImages = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name, Description, Version,PkgFlags, PackageType  FROM SMS_PackageBaseclass Where PackageType = '258' OR PackageType = '257' "
    $USE_BINARY_DELTA_REP = "0x04000000"
    }
    Process
    {
        $bdr_images = @()
        ForEach ($img in $allImages)
        {
        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "Name" -Value $img.Name
        $object | Add-Member -MemberType NoteProperty -Name "Version" -Value $img.Version
        $object | Add-Member -MemberType NoteProperty -Name "Description" -Value $img.Description
        $object | Add-Member -MemberType NoteProperty -Name "Binary_Delta_Rep" -Value ($ubdr = if($img.PkgFlags -band $USE_BINARY_DELTA_REP) {"Enabled"} Else {"Disabled"})
        $bdr_images += $object
        }
    }
    End
    {
        $bdr_images | Sort-Object Name
    }
}

.Synopsis

List Binary Delta Replication Setting for ConfigMgr Boot and Operating System images

.DESCRIPTION

This cmdlet Lists ConfigMgr the Boot image and Operating System image Binary Delta Replication Setting

.EXAMPLE

Another example of how to use this cmdlet

.NOTES

#http://msdn.microsoft.com/en-us/library/hh948196.aspx

Version 1.0 by Alex Verboon

function Get-CMImgBDRSetting

{

[CmdletBinding()]

Param

(

# Param1 help description

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=0)]

$SiteCode,

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

Position=1)]

$SiteServer

)

Begin

{

[string] $Namespace = "root\SMS\site_$SiteCode"

$allImages = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name, Description, Version,PkgFlags, PackageType FROM SMS_PackageBaseclass Where PackageType = '258' OR PackageType = '257' "

$USE_BINARY_DELTA_REP = "0x04000000"

}

Process

{

$bdr_images = @()

ForEach ($img in $allImages)

{

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "Name" -Value $img.Name

$object | Add-Member -MemberType NoteProperty -Name "Version" -Value $img.Version

$object | Add-Member -MemberType NoteProperty -Name "Description" -Value $img.Description

$object | Add-Member -MemberType NoteProperty -Name "Binary_Delta_Rep" -Value ($ubdr = if($img.PkgFlags -band $USE_BINARY_DELTA_REP) {"Enabled"} Else {"Disabled"})

$bdr_images += $object

}

End

{

$bdr_images | Sort-Object Name

}

Good to know: System Center 2012 Configuration Pack for Microsoft User Experience Virtualization

Posted on14 January 2014Leave a comment

Based on a conversation I had yesterday at the ConfigMgr Community event here , it appears that few people know about the existance of the ConfigMgr pack for Microsoft UE-V. There’s one for UE-V version 1.0 and just a few weeks ago one for UE-V 2.0 was released. System Center 2012 Configuration Pack for Microsoft User Experience Virtualization 2.0 System Center 2012 Configuration Pack for Microsoft User Experience Virtualization 1.0 After Microsoft User Experience Virtualization Read More …

PowerShell – Finding ConfigMgr Collections and Members

Posted on8 January 20148 January 2014Leave a comment

The below script provides a simple and quick method to find ConfigMgr Collections and its members. The script has a -Name parameter that accepts the exact or part of the collection name. Next all collections that match the name are listed. After selecting a collection, its members are listed.

Function Get-CMColContent()
{
&lt;#
.Synopsis
   Get Configuration Manager Collections and Members
.DESCRIPTION
   This script provides an interactive way to find collections and collection members within 
   Configuration Manager. 
.PARAMETER Name
   The exact or partial collection name. 
.EXAMPLE
   Get-CMColContent -Name All
#&gt;


 Param(
    [Parameter(Mandatory=$true,
    ValueFromPipelineByPropertyName=$true,
    HelpMessage="Enter Collection Name or part of collection Name",
    Position=0)]
    [String]$Name
    )

# Change Site Server Name and Site code so it fits your environment
[string] $SiteServer = "servername"
[string] $SiteCode = "010"
[string] $Namespace = "root\SMS\site_$SiteCode"

$CollectionItem = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name,LimitToCollectionName,MemberClassName, MemberCount, CollectionType  FROM SMS_Collection WHERE Name LIKE '%$Name%'" | Select-Object Name,LimitToCollectionName,MemberClassName, MemberCount, CollectionType, ResourceID | Sort-Object CollectionType| Out-GridView -Title "Collections" -OutputMode Single

$CollectionType = $CollectionItem.CollectionType
$CollectionName = $CollectionItem.Name
$MemberClassName = $CollectionItem.MemberClassName


If ($CollectionType -eq 2) # Computer collections
    {
        Write-Output "Please wait, this can take a while..."
        $colcontent = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name, Active, OperatingSystemNameandVersion, ResourceID FROM SMS_R_SYSTEM where ResourceID in (Select ResourceID from $MemberClassName)" | Select-Object Name, Active, OperatingSystemNameandVersion -wait | Sort-Object Name 
        $colcontent = $colcontent | Out-GridView -Title "Collection: $CollectionName Member Class: $MemberClassName" -OutputMode Multiple
        #return $colcontent
    }
Elseif ($CollectionType -eq 1) # User Collections 
    {
       Write-Output "Please wait, this can take a while..."
       $colcontent = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT UserName, UserPrincipalName, ResourceID FROM SMS_R_USER  where ResourceID in (Select ResourceID from $MemberClassName)" | Select-Object Username, UserPrincipalName, ResourceID -wait
       $colcontent = $colcontent | Out-GridView -Title "Collection: $CollectionName Member Class: $MemberClassName" -OutputMode Multiple 
       #return $colcontent
    }
Else
    {
      Write-output "No support for other Collection Type $Collectiontype"
    }

return $colcontent
}

Function Get-CMColContent()

{

.Synopsis

Get Configuration Manager Collections and Members

.DESCRIPTION

This script provides an interactive way to find collections and collection members within

Configuration Manager.

.PARAMETER Name

The exact or partial collection name.

.EXAMPLE

Get-CMColContent -Name All

Param(

[Parameter(Mandatory=$true,

ValueFromPipelineByPropertyName=$true,

HelpMessage="Enter Collection Name or part of collection Name",

Position=0)]

[String]$Name

)

# Change Site Server Name and Site code so it fits your environment

[string] $SiteServer = "servername"

[string] $SiteCode = "010"

[string] $Namespace = "root\SMS\site_$SiteCode"

$CollectionItem = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name,LimitToCollectionName,MemberClassName, MemberCount, CollectionType FROM SMS_Collection WHERE Name LIKE '%$Name%'" | Select-Object Name,LimitToCollectionName,MemberClassName, MemberCount, CollectionType, ResourceID | Sort-Object CollectionType| Out-GridView -Title "Collections" -OutputMode Single

$CollectionType = $CollectionItem.CollectionType

$CollectionName = $CollectionItem.Name

$MemberClassName = $CollectionItem.MemberClassName

If ($CollectionType -eq 2) # Computer collections

{

Write-Output "Please wait, this can take a while..."

$colcontent = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT Name, Active, OperatingSystemNameandVersion, ResourceID FROM SMS_R_SYSTEM where ResourceID in (Select ResourceID from $MemberClassName)" | Select-Object Name, Active, OperatingSystemNameandVersion -wait | Sort-Object Name

$colcontent = $colcontent | Out-GridView -Title "Collection: $CollectionName Member Class: $MemberClassName" -OutputMode Multiple

#return $colcontent

}

Elseif ($CollectionType -eq 1) # User Collections

{

Write-Output "Please wait, this can take a while..."

$colcontent = Get-WmiObject -Namespace $Namespace -ComputerName $SiteServer -Query "SELECT UserName, UserPrincipalName, ResourceID FROM SMS_R_USER where ResourceID in (Select ResourceID from $MemberClassName)" | Select-Object Username, UserPrincipalName, ResourceID -wait

$colcontent = $colcontent | Out-GridView -Title "Collection: $CollectionName Member Class: $MemberClassName" -OutputMode Multiple

#return $colcontent

}

Else

{

Write-output "No support for other Collection Type $Collectiontype"

}

return $colcontent

}

Example: Get-CMColContent -Name “All”

ConfigMgr OSD – Enable .NET Framework 3.5 on Windows 8.1

Posted on14 December 201311 Comments

Windows 8.1 has the .NET Framework 4.5.1 enabled by default. If you need .NET Framework 3.5 which also includes support for .NET 3.0, and 2.0, then you must enable the feature as it is not enabled by default.However to enable it you need access to the content of the Sources\SXS folder that resides on the Windows 8.1 installation media. More details are described in the MSDN article Installing the .NET Framework 3.5 on Windows 8 Read More …

ConfigMgr PowerShell Script to check if Application or Program is allowed to run in TS without being deployed

Posted on8 November 20138 November 20131 Comment

Kind of a long title for a blog post, but I could not come up with something shorter to describe the content of this blog post. The below script shows the status of the “Allow this Application / program to be installed from the Application / program install task sequence action without being deployed” setting.

<#
.Synopsis
    Get Application and Package - Program information regarding Task Sequence support
.DESCRIPTION
   The script checks all applications and packages if they are allowed to be installed from a TS without being deployed
.EXAMPLE
   Get-TSInstallEnabled -Site Lab
.NOTES
    Version 1.0
    Written by Alex Verboon
#>


[CmdletBinding()]


param( 
    # ConfigMgr Site
    [Parameter(Mandatory = $true, ValueFromPipeline=$true)]
    [String[]] $Site
    )

if ($Site.Length -eq 0)
     {    
     Throw "ConfigMgr Site code required"
     } 
Else
    {
    $SiteCode = $Site
    }


function Get-TSInstallEnabled ()
{

# Check that youre not running X64
if ([Environment]::Is64BitProcess -eq $True)
     {    
     Throw "Need to run at a X86 PowershellPrompt"
     } 
# Load ConfigMgr module if it isn't loaded already
if (-not(Get-Module -name ConfigurationManager))
    {        
    Import-Module ($Env:SMS_ADMIN_UI_PATH.Substring(0,$Env:SMS_ADMIN_UI_PATH.Length-5) + '\ConfigurationManager.psd1')
    } 
       
# Change to site
Push-Location
Set-Location ${SiteCode}:


    function Get-AppTSInfo()
    {
    $Apps = @() 
    foreach ($Application in Get-CMApplication)
        {
        $AppMgmt = ([xml][/xml]$Application.SDMPackageXML).AppMgmtDigest
        $AppName = $AppMgmt.Application.DisplayInfo.FirstChild.Title
        $AllowTs =  $AppMgmt.Application.AutoInstall
        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "Application Name" -Value $Appname

        if ($AllowTs -ne "true") {$AllowTs = "false"}

        $object | Add-Member -MemberType NoteProperty -Name "Allowed TS Install" -Value $AllowTs
        $Apps += $object
         }
    $Apps 
    }

    Function Get-PackageTSInfo()
    {
    $Progs = @() 
    foreach ($Prog in Get-CMProgram)
        {
        $ProgName = $Prog.ProgramName
        $PackageName = $prog.PackageName
        $AllowTs = $Prog.ProgramFlags -band [math]::pow(0,0)
        $object = New-Object -TypeName PSObject
        $object | Add-Member -MemberType NoteProperty -Name "Program Name" -Value $ProgName
        $object | Add-Member -MemberType NoteProperty -Name "Package Name" -value $Packagename

        if ($AllowTs -ne "1") {$AllowTs = "false"} Else {$AllowTs = "true"}

        $object | Add-Member -MemberType NoteProperty -Name "Allowed TS Install" -Value $AllowTs
        $Progs += $object
     }
     $progs 
}


Get-AppTSInfo | Format-Table -AutoSize 
Get-PackageTSInfo | Format-Table -AutoSize 
Pop-Location
}

Get-TSInstallEnabled

.Synopsis

Get Application and Package - Program information regarding Task Sequence support

.DESCRIPTION

The script checks all applications and packages if they are allowed to be installed from a TS without being deployed

.EXAMPLE

Get-TSInstallEnabled -Site Lab

.NOTES

Version 1.0

Written by Alex Verboon

[CmdletBinding()]

param(

# ConfigMgr Site

[Parameter(Mandatory = $true, ValueFromPipeline=$true)]

[String[]] $Site

)

if ($Site.Length -eq 0)

{

Throw "ConfigMgr Site code required"

}

Else

{

$SiteCode = $Site

}

function Get-TSInstallEnabled ()

{

# Check that youre not running X64

if ([Environment]::Is64BitProcess -eq $True)

{

Throw "Need to run at a X86 PowershellPrompt"

}

# Load ConfigMgr module if it isn't loaded already

if (-not(Get-Module -name ConfigurationManager))

{

Import-Module ($Env:SMS_ADMIN_UI_PATH.Substring(0,$Env:SMS_ADMIN_UI_PATH.Length-5) + '\ConfigurationManager.psd1')

}

# Change to site

Push-Location

Set-Location ${SiteCode}:

function Get-AppTSInfo()

{

$Apps = @()

foreach ($Application in Get-CMApplication)

{

$AppMgmt = ([xml][/xml]$Application.SDMPackageXML).AppMgmtDigest

$AppName = $AppMgmt.Application.DisplayInfo.FirstChild.Title

$AllowTs = $AppMgmt.Application.AutoInstall

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "Application Name" -Value $Appname

if ($AllowTs -ne "true") {$AllowTs = "false"}

$object | Add-Member -MemberType NoteProperty -Name "Allowed TS Install" -Value $AllowTs

$Apps += $object

}

$Apps

}

Function Get-PackageTSInfo()

{

$Progs = @()

foreach ($Prog in Get-CMProgram)

{

$ProgName = $Prog.ProgramName

$PackageName = $prog.PackageName

$AllowTs = $Prog.ProgramFlags -band [math]::pow(0,0)

$object = New-Object -TypeName PSObject

$object | Add-Member -MemberType NoteProperty -Name "Program Name" -Value $ProgName

$object | Add-Member -MemberType NoteProperty -Name "Package Name" -value $Packagename

if ($AllowTs -ne "1") {$AllowTs = "false"} Else {$AllowTs = "true"}

$object | Add-Member -MemberType NoteProperty -Name "Allowed TS Install" -Value $AllowTs

$Progs += $object

}

$progs

}

Get-AppTSInfo | Format-Table -AutoSize

Get-PackageTSInfo | Format-Table -AutoSize

Pop-Location

}

Get-TSInstallEnabled

Additional Information SMS_Program Server WMI Class (ProgramFlags) Application.AutoInstall Property Application Members

PowerShell Script to detect ConfigMgr Task Sequence unfriendly Software Updates

Posted on6 November 201315 June 20141 Comment

Update: 15 Une 2014 – Added KB2965788 If you’re dealing with ConfigMgr and OS Deployment task sequences you’re probably aware of the KB article recently published by Microsoft called “Task sequence fails in Configuration Manager if software updates require multiple restarts”. Let’s hope the list of KBs causing this issue isn’t going to grow too much over time, in any case we’ve decided that we would continue to review the article whenever we add new Read More …

Category: ConfigMgr

Use PowerShell to find all collections where the specified device has a membership

Like this:

How to identify ConfigMgr collections that take long to refresh

Like this:

PowerShell Script – Get-CMInstalledSoftware

Like this:

ConfigMgr – How to find the Application Name for a ContentID

Like this:

ConfigMgr – PowerShell Script to list Image Binary Delta Replication Setting

Like this:

Good to know: System Center 2012 Configuration Pack for Microsoft User Experience Virtualization

Like this:

PowerShell – Finding ConfigMgr Collections and Members

Like this:

ConfigMgr OSD – Enable .NET Framework 3.5 on Windows 8.1

Like this:

ConfigMgr PowerShell Script to check if Application or Program is allowed to run in TS without being deployed

Like this:

PowerShell Script to detect ConfigMgr Task Sequence unfriendly Software Updates

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this: