PoshCode Archive  Artifact [5adb19e62e]

Artifact 5adb19e62e44ada202399e54228f955511c87a9264f2d91473a7a5b123c1874e:

• File Documenting-Collections.ps1 — part of check-in [df608b09f0] at 2018-06-10 13:58:04 on branch trunk — Small script to export a CSV file containing a collections ID, Name and Limiting collection ID. This can be used as is to import into Microsoft Visio Org Chart wizard to produce a graphical representation of your collection structure. (user: Brian Skinner size: 2263)

# encoding: ascii
# api: powershell
# title: Documenting Collections
# description: Small script to export a CSV file containing a collections ID, Name and Limiting collection ID. This can be used as is to import into Microsoft Visio Org Chart wizard to produce a graphical representation of your collection structure.
# version: 1.0
# type: script
# author: Brian Skinner
# license: CC0
# x-poshcode-id: 5617
# x-archived: 2014-12-13T19:26:25
# x-published: 2014-12-01T15:26:00
#
# Change $servername and $sitecode to match your environment
#
###################################################################
# Script:     Configuration Manager Collection Tree Documenter    #
# Description Creates a CSV file detailing collectionid, name and #
#             limittocollectionid fields in a suitable format to  #
#             import into Microsoft Visio as an org chart         #
# Last Update 01/12/2014                                          #
# Version     1.0 			
###################################################################

function DocumentCollectionTree
{
    param($LimitCollectionID)
    $info=@()
    $subcollections = Get-WmiObject `
                        -ComputerName $siteserver `
                        -namespace root\sms\site_$sitecode `
                        -query "select * from SMS_Collection where LimitToCollectionID = '$LimitCollectionID'"

    if ($subcollections -ne $null)
    {
        foreach ($subcoll in $subcollections)
        {
            $object = New-Object -TypeName PSObject
            $object | Add-Member -MemberType NoteProperty  -Name CollectionID -Value $subcoll.collectionid
            $object | Add-Member -MemberType NoteProperty  -Name CollectionName -Value $subcoll.name
            $object | Add-Member -MemberType NoteProperty  -Name LimitingCollectionID -Value $LimitCollectionID
            $info += $object
            DocumentCollectionTree $subcoll.collectionid
        }
    }
    $info | export-csv -path "c:\temp\collections.csv" -NoTypeInformation -Append -Force
 }


$collectionid = Read-Host "Enter the root collection id to search from" 
$siteserver = "ServerName"
$sitecode = "sitecode"

DocumentCollectionTree $collectionid