Exported .CSV files comes up empty-CodePudding

I need a quick script to convert device names to Object IDs, so that I can perform a bulk upload in Intune. I have the device names saved as a .csv which I import. After running the script the output BulkObjectID.csv comes up empty (0 kb). I am not sure what I could be doing wrong. Thanks in advance for any help.

connect-azuread

$csv = Import-Csv C:\Tools\NEW.csv
$ObjectID=@()
foreach ($DisplayName in $csv){
    $ObjectID  = get-AzureADDevice -Filter "DisplayName eq '$._DisplayName'" | Select ObjectID 
}
$ObjectID
$ObjectID | export-csv -path 'C:\Tools\BulkObjectID.csv' -append

CodePudding user response：

I tried to reproduce the same in my environment and got below results

I have few Azure AD devices existing in my tenant like below:

enter image description here

I created one csv file with display names of above devices like this:

enter image description here

Now, I ran the same script as you and got same output with empty (0 kb) BulkObjectID.csv file like below:

Connect-AzureAD

$csv = Import-Csv C:\test\new.csv
$ObjectID=@()
foreach ($DisplayName in $csv){
    $ObjectID  = get-AzureADDevice -Filter "DisplayName eq '$._DisplayName'" | Select ObjectID 
}
$ObjectID
$ObjectID | export-csv -path 'C:\test\BulkObjectID.csv' -append

Response:

enter image description here

When I checked the folder, empty (0 kb) BulkObjectID.csv file is present like below:

enter image description here

To resolve this, modify your script by making few changes like below:

Connect-AzureAD

$csv = Import-Csv C:\test\new.csv
$ObjectID=@()
foreach ($DisplayName in $csv)
{
    $name = $DisplayName.DisplayName
    $ObjectID = get-AzureADDevice -Filter "DisplayName eq '$name'" | Select ObjectID
    $ObjectID
    $ObjectID | export-csv -path 'C:\test\ObjectID.csv' -append
}

Response:

enter image description here

When I checked the folder, ObjectID.csv file is present with device IDs like below:

enter image description here