Powershell - Get a list of AzureAD users created in the last 2 months

Question

Powershell - Get a list of AzureAD users created in the last 2 months

Joel Chambers 0

Trying to get a list of users exported to CSV for users created in the last 2 months.

It's coming up completely blank, even though there are users going back to 2021 if I omit the "| where {$_.ext1 -ge $tempdate} |" section, but there are definitely users created in the last 60 days.... so I'm missing something.

$tempdate=(Get-Date).AddDays(-60)

Write-Host "Looking for users created after" $tempdate

$aadUsers = Get-AzureADUser | Select DisplayName, ObjectID
$aadUsersExt = @()

ForEach ($aadUser in $aadUsers) {
    $user = Get-AzureADUser -ObjectId $aadUser.ObjectId | Select ObjectId, DisplayName, UserPrincipalName
    $userDetail = Get-AzureADUser -ObjectId $aadUser.ObjectId | Select -ExpandProperty ExtensionProperty
    $ext1 = $userDetail.createdDateTime

    $obj = [pscustomobject]@{"DisplayName"=$user.DisplayName; "UserPrincipalName"=$user.UserPrincipalName; "Created Date"=$ext1}
    $aadUsersExt += $obj
    }


$aadUsersExt | Where {$_

1 answer

Your answer

Answer 1

Pierre Audonnet - MSFT 10,191 Microsoft Employee

The AzureAD module will be soon deprecated. You can use the MgGraph module instead. Reference: https://learn.microsoft.com/en-us/powershell/microsoftgraph/migration-steps?view=graph-powershell-1.0

Here is an example using the MgGraph module:

$date = Get-Date (Get-Date).AddDays(-60) -Format O
Connect-MgGraph -Scopes 'User.Read.All'
Get-MgUser -Filter "createdDateTime ge $date" -Property Id,DisplayName,UserPrincipalName,CreatedDateTime | `
    Select-Object Id,DisplayName,UserPrincipalName,CreatedDateTime | `
    ConvertTo-Csv -NoTypeInformation | `
    Out-File -FilePath C:\temp\myusers.csv

James Richardson 5 Reputation points

2023-02-10T10:22:16.7933333+00:00

Not to hijack things, but can I incorporate this into a custom attribute for users? I have a custom boolean attribute that is assigned to my account as a test, I'd like it to check how old the account is and then assign true or false based on the result

Share via

Powershell - Get a list of AzureAD users created in the last 2 months

1 answer

Your answer