Imports users from csv to SCCM/MECM user collection

SCCM_ImportUsersFromCSV-ToUserCollection.ps1

# Import SCCM module
Import-Module 'C:\Program Files (x86)\Microsoft Endpoint Manager\AdminConsole\bin\ConfigurationManager.psd1'

# Define the Site Code
$SiteCode = ""

# Define the path to the CSV file
$csvPath = ""

# Define the collection ID to which users will be added
$collectionID = ""

# Import the CSV
$users = Import-Csv -Path $csvPath

foreach ($user in $users) {
    # Extract the actual username value
    $userName = $user.UserName.Trim()
    
    # Get the user resource ID
    $userResourceID = Get-CMUser -Name $userName | Select-Object -ExpandProperty ResourceID
    if ($userResourceID) {
        # Add each user to the collection
        Add-CMUserCollectionDirectMembershipRule -CollectionId $collectionID -ResourceID $userResourceID
    } else {
        Write-Host "User $userName not found in SCCM."
    }
}

Write-Host "Users have been added to the collection."