List Collection Membership with Powershell

[SRed]

Hey all,

 

I'm looking to use Powershell to list all collections a particular Computer is a member of.

 

I have a way of listing all the members of a particular collection, but I don't have the reverse, which would be listing all the collections a member is in. I'll post what I've got.

 

PS C:\> (get-command Get-CollectionMember).ScriptBlock
Param($CollName)
$SiteCode="ATL"
  $SCCMServer="SCCM"

# Get a list of collections and find the object to build the collection list.
$Collection = Get-WmiObject -ComputerName $SCCMServer  -Namespace `
"root\sms\site_$SiteCode" -Class 'SMS_Collection'
$MyCollection = $Collection | Where-Object { $_.Name -eq $CollName }
# Grab the Resource ID of the collection
$MyCollectionMembers = Get-WmiObject  -ComputerName $SCCMServer -Namespace `
"root\sms\site_$SiteCode"  -Query "select * from SMS_CM_RES_COLL_$($MyCollection.CollectionID)"
#Echo member of the collections to screen
Foreach ($member in $MyCollectionMembers) {
  $oldErrCount = $error.Count
 $Name = $member.Name.ToString()
$Name
 }

 

I found this code somewhere online and modified it to fit. Now, this will list all of the members of a specified collection, but can't be used to find all the collections a member is in. Anyone have any ideas?

[Harvey]

I don't know much about Powershell but If you want to script, you can create one that queries the DB directly instead of using a WMI query.

 

The table is dbo.CollectionMembers. You can search it by name or Machine ID but ID would give more exact if you recently imaged same named systems where the old entry still exists.

[Kaido1000]

Here is the code that you need: http://depsharee.blo...membership.html

[SRed]

@Kaido, can you download the script from that site? I can't.

[Kaido1000]

The link was broken. Now it should work

[BlakeZ]

Hi Kaido, the link is broken again. Any chance of a fix? Thanks