import-csv and Check get-msoluser | import-csv and Check get-azuread

Details

You have a .csv file of accounts from somewhere and you need to check if the accounts exist in AD, AAD/EID. But the list doesn't have USERPRINCIPALNAME, it only has the email address.

import-csv .\users.csv |select @{n='userprincipalname';e={$_.email}} |%{get-msoluser -userprincipalname $_.userprincipalname}

import-csv .\users.csv |select @{n='userprincipalname';e={$_.email}} |%{get-azureaduser -objectid $_.userprincipalname}

NOTES:
https://www.youtube.com/watch?v=6GfIU-H2x28&list=PL6D474E721138865A&index=28

Main Menu