Powershell Azure Active Directory - Need Numbers from Names of Devices

Ok gang,

I have a CSV of Device Names in Azure AD, I want to get a list of DeviceID or ObjectId for each of the names on the list.

I have tried the following
#
$CHGList = Import-Csv -path C:\Users\username\desktop\CHGList.csv

get-msoldevice -name $CHGList | Select-Object ObjectID | Export-CSV -Path "C:\Users\username\desktop\AzureDeviceID.csv"
#

I have tried piping over results and running it that way
I have tried changing the Custom Object  to a String
I have tried

#
$CHGList = Import-Csv -path C:\Users\username\desktop\CHGList.csv
$Modification = $null
$Modification = $CHGList -join ","
get-msoldevice -name $Modification | Select-Object ObjectID | Export-CSV -Path "C:\Users\username\desktop\AzureDeviceID.csv"
#

I've looked at trying to loop through the CSV file and it's making no sense.

Can I get some help?

Thanks all for your time.
Chris BushSr Systems EngineerAsked:
Who is Participating?
 
Vasil Michev (MVP)Connect With a Mentor Commented:
Assuming you have a column "Name" in the CSV file, try this:

Import-Csv .\CHGList.csv | % {Get-MsolDevice -Name $_.Name | select ObjectId,DeviceId}

Open in new window


If everything runs OK, add the Export-CSV part at the end.
0
 
Chris BushSr Systems EngineerAuthor Commented:
That did it. Thank you SO much!
0
 
Vasil Michev (MVP)Commented:
No worries, PowerShell is not that hard when you get the hang of it :) Dont forget to mark the answer.
0
 
Vasil Michev (MVP)Commented:
If you feel this question wasn't answered or should be closed differently, post an objection. The moderators will review all objections and close it as they feel fit.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.