leeramsay/get_computers_in_sccm_collection.ps1

## readme.md

      
    Raw
  

              readme.md
            
          
    grabbed from here for later:
https://gallery.technet.microsoft.com/scriptcenter/Get-Computers-in-SCCM-948e666f
still todo:

make sure it works
csv export
prompt for collection name
detection of site code if only one
detection of server name from DNS/wherever AD stores it?


## get_computers_in_sccm_collection.ps1
$SiteServer = 'SERVER NAME
$SiteCode = 'SITE CODE'
$CollectionName = 'NAME OF COLLECTION'
$cred = Get-credential
#Retrieve SCCM collection by name
$Collection = get-wmiobject -ComputerName $siteServer -NameSpace "ROOT\SMS\site_$SiteCode" -Class SMS_Collection -Credential $cred  | where {$_.Name -eq "$CollectionName"}
#Retrieve members of collection
$SMSMemebers = Get-WmiObject -ComputerName $SiteServer -Credential $cred -Namespace  "ROOT\SMS\site_$SiteCode" -Query "SELECT * FROM SMS_FullCollectionMembership WHERE CollectionID='$($Collection.CollectionID)' order by name" | select Name
	$SiteServer = 'SERVER NAME
	$SiteCode = 'SITE CODE'
	$CollectionName = 'NAME OF COLLECTION'
	$cred = Get-credential
	#Retrieve SCCM collection by name
	$Collection = get-wmiobject -ComputerName $siteServer -NameSpace "ROOT\SMS\site_$SiteCode" -Class SMS_Collection -Credential $cred \| where {$_.Name -eq "$CollectionName"}
	#Retrieve members of collection
	$SMSMemebers = Get-WmiObject -ComputerName $SiteServer -Credential $cred -Namespace "ROOT\SMS\site_$SiteCode" -Query "SELECT * FROM SMS_FullCollectionMembership WHERE CollectionID='$($Collection.CollectionID)' order by name" \| select Name