ODBC DSN and wildcards, stackoverflow.com/questions/61398748

test.ps1

Get-OdbcDriver |
% { 
    $id = [guid]::NewGuid().Guid.Split('-')[0]
    $name = $_.Name
    try {
        Invoke-CimMethod -ClassName MSFT_OdbcDsnTask `
                         -Namespace ROOT\Microsoft\Windows\Wdac `
                         -MethodName 'Add' `
                         -Arguments @{
                             Name       = "test_$id"
                             DsnType    = 'User'
                             Platform   = $_.Platform
                             DriverName = $name
                         } `
                         -ErrorAction Stop | Out-Null
        @{ Result = 'Success'; Name = $Name }
    }
    catch {
        @{ Result = 'Failure'; Name = $Name }
    }
} |
% {[pscustomobject]$_} |
Sort-Object Result