export objectid of users listed in *.csv file

Question

export objectid of users listed in *.csv file

kitsbee 21

Hi ,

trying to extract objectid for list of users from csv. Csv file contains header with UPN . This does not seem to be working.

import-csv -path "C:\test1.csv" |
foreach {
Get-Msoluser -Userprinicpalname $_.UPN | Select-Object -Property ObjectID
} | Export-CSV -Path "C:\test9.csv"

Get-MsolUser : A parameter cannot be found that matches parameter name 'Userprinicpalname'.

Can you advise do i need to change the header. what valueUserprinicpalname'. is looking ?

Accepted answer

2 additional answers

Your answer

Answer 1

Rich Matheisen 47,901

Well, there isn't a parameter named "-Name". That's pretty clear in both the error message and the help text for the cmdlet.

You can use the -UserPrincipalName, or the -SearchString parameters. Or you can use something like this:

import-csv -path C:\test1.csv |
    ForEach-Object{
        $Name = $_.Name
        Get-MsolUser -All |
            Where-Object {$_.Name -eq $Name} |
                Select-Object @{n=Name;e={$Name}},@{n=ObjectID;e={$_.ObjectID}}
    } | Export-CSV --Path C:\test9.csv -NoTypeInformation

kitsbee 21 Reputation points

2020-08-05T23:49:09.033+00:00

this isnt working. so csv has list of UPN with header "name"
Rich Matheisen 47,901 Reputation points

2020-08-06T02:12:27.083+00:00
You didn't mention that your CSV contained the UserPrincipalName in its "Name" column. That makes the script a lot more efficient and doesn't require the use of calculated properties to get meaningful headers into the output CSV.

import-csv -path C:\test1.csv | ForEach-Object{ Get-MsolUser -UserPrincipalName $_.Name | Select-Object UserPrincipalName, ObjectID } | Export-CSV -Path C:\test9.csv -NoTypeInformation

Note that the script does not check for errors. If your "Name" isn't a valid UPN the CSV will contain nothing for those rows in the input CSV. It will, however, run more efficiently since it's not returning all users for every row in the input CSV.

In the previous script the same was true except that the "name" calculated property wasn't taken from the real user object, but from your input CSV.
kitsbee 21 Reputation points

2020-08-06T16:01:38.71+00:00

Great.This works.

Answer 2

AmanpreetSingh-MSFT 56,871 Moderator

Hi @kitsbee

Please find below the script that you can use for this purpose:

$users = Import-Csv -Path C:\test1.csv  
$loop = foreach ($user in $users) {  
Get-MsolUser -UserPrincipalName $user.upn | Select-Object UserPrincipalName, ObjectID  
}   
$loop | Export-CSV -Path C:\test9.csv -NoTypeInformation

Below is how my input file test1.csv looks like:

-----------------------------------------------------------------------------------------------------------

Please "Accept the answer" if you find the information helpful. This will help us and others in the community as well.

kitsbee 21 Reputation points

2020-08-06T16:02:37.017+00:00

Thanks this too works.
ROHIT HOODA 0 Reputation points

2023-02-23T07:18:56.2866667+00:00

Import-Csv -Path C:\Users\rh041\OneDrive\Desktop\mfa.csv | foreach { Get-MsolUser -UserPrincipalName $_.UPN | Select-Object UserPrincipalName, ObjectID } | Export-CSV -Path C:\test7.csv -NoTypeInformatio
Alexander Varela 0 Reputation points

2023-03-24T10:46:13.43+00:00

Thanks!

Answer 3

Alfredo Revilla - Upwork Top Talent | IAM SWE SWA 27,526 Moderator

UserPrincipalName is mispelled (Userprinicpalname). Also, it's recommended to use the (newer) AzureAD powershell module:

   Get-AzureADUser -Filter "userPrincipalName eq '$_.UPN'"

Share via

export objectid of users listed in *.csv file

2 additional answers

Your answer