arjancornelissen · July 23, 2019 20:12
diff --git a/where-objectLargeDataset.ps1 b/where-objectLargeDataset.ps1
 $msolusers = Get-MsolUser -All | Select-object ObjectId, WhenCreated, LastPasswordChangeTimestamp, @{n="mfaenabled";e={$_.StrongAuthenticationMethods.Count -gt 0}}
 $users = Get-AzureADUser -All $true | Select-Object ObjectId, UserPrincipalName, DisplayName, @{n="onpremDN";e={$_.ExtensionProperty.onPremisesDistinguishedName}}, CompanyName, AccountEnabled, UserType
 foreach($user in $users)
 {
  $msoluser = $msolusers | where-object {$_.ObjectID -eq $user.ObjectID}
  # do something with this data
 }
	$msolusers = Get-MsolUser -All \| Select-object ObjectId, WhenCreated, LastPasswordChangeTimestamp, @{n="mfaenabled";e={$_.StrongAuthenticationMethods.Count -gt 0}}
	$users = Get-AzureADUser -All $true \| Select-Object ObjectId, UserPrincipalName, DisplayName, @{n="onpremDN";e={$_.ExtensionProperty.onPremisesDistinguishedName}}, CompanyName, AccountEnabled, UserType
	foreach($user in $users)
	{
	$msoluser = $msolusers \| where-object {$_.ObjectID -eq $user.ObjectID}
	# do something with this data
	}