Weekly Tip 57

PowerShell Script to Get Whether Deployments are Device or User-Based

Here’s a PowerShell script that will pull whether deployments are device based or user based. Insert your a location to save a CSV file, your primary site server name, and site code at the top.

$csv = <path to CSV file>

$siteServer = <site server name>

$siteCode = <site code>

$deployments = get-wmiobject -computername $siteServer -namespace root\sms\site_$siteCode -class SMS_DeploymentInfo

$collections = get-wmiobject -computername $siteServer -namespace root\sms\site_$siteCode -class SMS_Collection

add-content $csv “DeploymentName,CollectionID,CollectionType,CollectionName”

ForEach ($deployment in $deployments) {

$deploymentName = $deployment.DeploymentName

$collID = $deployment.CollectionID

$collName = $deployment.CollectionName

$collectionType = ($collections | where-object -filterscript {$_.CollectionID -eq $collID}).CollectionType

If ($collectionType -eq “0”) {$f_collectiontype = “Other”}

If ($collectionType -eq “1”) {$f_collectiontype = “User”}

If ($collectionType -eq “2”) {$f_collectiontype = “Device”}

add-content $csv “$deploymentname,$collID,$f_collectionType,$collName”

}