SCCM: Computer collection based on Computer Name

This will list all computers where the name starts with IT or HQ select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Name like “IT%” or SMS_R_System.Name like “HQ%”

Powershell: Rename remote computer with WMI

To rename a computer when Rename-Computer is not¬†available (pre Powershell 4.0) Get-WmiObject Win32_ComputerSystem -ComputerName OLDNAME -Authentication 6 | ForEach-Object {$_.Rename(“NEWNAME”,”PASSWORD”,”USERNAME”)}   You can also mask the password $credential = Get-Credential Get-WmiObject Win32_ComputerSystem -ComputerName OLDNAME -Authentication 6 | ForEach-Object {$_.Rename(“NEWNAME”,$credential.GetNetworkCredential().Password,$credential.Username)}