We write a script to extract from Get-EntraUser the signInActivity property. We expand this property to get the lastSignInDateTime, lastSuccessfulSignInDateTime, and lastNonInteractiveSignInDateTime values. The script we use is:
Connect-Entra -Scope 'User.Read.All'
$allactivemembers = Get-EntraUser -Filter "accountEnabled eq true and userType eq 'Member'” -Limit 10 -Property displayName,userPrincipalName, onPremisesSamAccountName, onPremisesImmutableId, signInActivity
$allactivemembers | Select-Object -ExpandProperty 'signInActivity' | Export-Csv -Path “sampleoutput.csv"
When running the same PowerShell script on MacOS and on Windows, we get different results in the output. Specifically, in MacOS we get three non-printable characters in a date/time string, between the seconds and the AM or PM designator. They are: 0xE2 0x80 0xAF.
Thanks for reporting the bug. Please ensure you've gone through the following checklist before opening an issue:
- Make sure you can reproduce this issue using the latest released version of
Microsoft.Entra or Microsoft.Entra.Beta.
- Please search the existing issues to see if there has been a similar issue filed.
Describe the bug
To Reproduce
Steps to reproduce the behavior:
- Run the following script on a Mac:
Connect-Entra -Scope 'User.Read.All'
$allactivemembers = Get-EntraUser -Filter "accountEnabled eq true and userType eq 'Member'” -Limit 10 -Property displayName,userPrincipalName, onPremisesSamAccountName, onPremisesImmutableId, signInActivity
$allactivemembers | Select-Object -ExpandProperty 'signInActivity' | Export-Csv -Path “sampleoutput.csv"
- Using a binary editor / od -cx from the command line on a Mac, inspect the output CSV file, and you will see the extraneous characters:
0000400 l e I d " \n " 6 / 1 6 / 2 0 2 6
656c 6449 0a22 3622 312f 2f36 3032 3632
0000420 4 : 4 3 : 0 5 ** ** P M " , "
3420 343a 3a33 3530 80e2 50af 224d 222c
0000440 a d d 0 9 5 4 b - b 1 1 8 - 4 c
6461 3064 3539 6234 622d 3131 2d38 6334
0000460 a 9 - b 7 5 1 - 7 f 9 d 8 9 2 5
3961 622d 3537 2d31 6637 6439 3938 3532
0000500 7 5 0 0 " , " 6 / 1 7 / 2 0 2 6
3537 3030 2c22 3622 312f 2f37 3032 3632
0000520 1 2 : 4 6 : 5 8 ** ** P M " ,
3120 3a32 3634 353a e238 af80 4d50 2c22
0000540 " a d d 0 9 5 4 b - b 1 1 8 - 4
6122 6464 3930 3435 2d62 3162 3831 342d
0000560 c a 9 - b 7 5 1 - 7 f 9 d 8 9 2
6163 2d39 3762 3135 372d 3966 3864 3239
0000600 5 7 5 0 0 " , " 6 / 1 7 / 2 0 2
3735 3035 2230 222c 2f36 3731 322f 3230
0000620 6 1 2 : 4 6 : 5 8 ** ** P M "
2036 3231 343a 3a36 3835 80e2 50af 224d
0000640 , " f 7 e 5 0 b f 7 - 2 3 d 9 -
222c 3766 3565 6230 3766 322d 6433 2d39
0000660 4 a 5 6 - b f 3 b - b a f 7 3 e
6134 3635 622d 3366 2d62 6162 3766 6533
- Run the same script on a PC, and the extraneous characters are not present.
Expected behavior
The output should be the same on a PC or Mac (with, perhaps, the lack of \r on a Mac at line ends)
Debug Output
⚠ ATTENTION: Be sure to remove any sensitive information that may be in the logs.
Debug Output
DEBUG: ============================ TRANSFORMATIONS ============================
DEBUG: Method : GET
DEBUG: Uri : /v1.0/users/?$select=displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity&$top=10&$Filter=accountEnabled eq true and userType eq 'Member'
DEBUG: =========================================================================
DEBUG: GET /v1.0/users/?$select=displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity&$top=10&$Filter=accountEnabled%20eq%20true%20and%20userType%20eq%20'Member' HTTP/1.1
HTTP: graph.microsoft.com
User-Agent: PowerShell/7.6.3 EntraPowershell/1.0.12 Get-EntraUser
DEBUG: GET https://graph.microsoft.com/v1.0/users/?$select=displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity&$top=10&$Filter=accountEnabled%20eq%20true%20and%20userType%20eq%20'Member'
HTTP/1.1 200 OK
Cache-Control: no-cache
Transfer-Encoding: chunked
Vary: Accept-Encoding
Strict-Transport-Security: max-age=31536000
request-id: cfe9c58f-3f89-4938-9b01-05fa34b7f1a3
client-request-id: aefb7bd5-7ba6-45c6-94bd-0e6ff668bfed
x-ms-ags-diagnostic: {"ServerInfo":{"DataCenter":"West US 2","Slice":"E","Ring":"4","ScaleUnit":"000","RoleInstance":"CO1PEPF00016241"}}
x-ms-resource-unit: 1
OData-Version: 4.0
Date: Thu, 18 Jun 2026 16:57:44 GMT
Content-Type: application/json; odata.metadata=minimal; odata.streaming=true; IEEE754Compatible=false; charset=utf-8
Content-Encoding: gzip
{"@odata.context":"https://graph.microsoft.com/v1.0/$metadata#users(displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity)","@odata.nextLink":"https://graph.microsoft.com/v1.0/users/?$select=displayName%2cuserPrincipalName%2conPremisesSamAccountName%2conPremisesImmutableId%2csignInActivity&$top=10&$Filter=accountEnabled+eq+true+and+userType+eq+%27Member%27&$skiptoken=RFNwdAoAAQAAAAAAAAAAFAAAAEafF8mAgldOlr30ecd_1f8BAAAAAAAAAAAAAAAAAAAXMS4yLjg0MC4xMTM1NTYuMS40LjIzMzEGAAAAAAABUTnyiO8afEWg00Bm8rbXOQH_AAAAAQEAAAA","value":[{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"yCes/D+i7kOlMFT3dJsjvg==","id":"281a6583-b6d1-42ba-9012-d6f6383b4af9","signInActivity":{"lastSignInDateTime":"2026-06-17T18:07:04Z","lastSignInRequestId":"5e7f2752-4c25-4162-9439-0e4382c47400","lastNonInteractiveSignInDateTime":"2026-06-18T09:04:35Z","lastNonInteractiveSignInRequestId":"7a4fdcc1-29a7-475b-b8bc-4da8df698c00","lastSuccessfulSignInDateTime":"2026-06-18T09:04:35Z","lastSuccessfulSignInRequestId":"7a4fdcc1-29a7-475b-b8bc-4da8df698c00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"wJ2zqzr1aEiIVydU7MVuYQ==","id":"b3fafa6a-fccc-4051-9517-f65696975fee","signInActivity":{"lastSignInDateTime":"2026-06-18T07:48:51Z","lastSignInRequestId":"acf8cc9a-3b62-486f-a47a-b58e778a1700","lastNonInteractiveSignInDateTime":"2026-06-18T09:07:54Z","lastNonInteractiveSignInRequestId":"bfabc4eb-8fc5-4579-b2b6-d6ef451f8100","lastSuccessfulSignInDateTime":"2026-06-18T09:07:54Z","lastSuccessfulSignInRequestId":"bfabc4eb-8fc5-4579-b2b6-d6ef451f8100"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"t+uUF4ouXEiG2L1nViWhdA==","id":"4832b9a7-1d56-4c29-be82-74445f0f9469","signInActivity":{"lastSignInDateTime":"2026-06-18T06:27:28Z","lastSignInRequestId":"ed9df889-d494-4817-830d-5dbc86a12a00","lastNonInteractiveSignInDateTime":"2026-06-18T04:13:56Z","lastNonInteractiveSignInRequestId":"fae9fef5-02fd-4d01-926a-6c5b82e00200","lastSuccessfulSignInDateTime":"2026-06-18T06:27:28Z","lastSuccessfulSignInRequestId":"ed9df889-d494-4817-830d-5dbc86a12a00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"CjGNPPtqRkupO/taILUzag==","id":"3b12f7a5-7c25-4db2-9ef8-57fe417cf60b","signInActivity":{"lastSignInDateTime":"2026-06-17T13:53:46Z","lastSignInRequestId":"6372965d-63c1-464a-b347-a6aa70267b00","lastNonInteractiveSignInDateTime":"2026-06-18T09:05:35Z","lastNonInteractiveSignInRequestId":"2f46bc52-20cc-4c03-82c8-73f061d87600","lastSuccessfulSignInDateTime":"2026-06-18T09:05:35Z","lastSuccessfulSignInRequestId":"2f46bc52-20cc-4c03-82c8-73f061d87600"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"5uEakYyHeUaV5qqIob+nMg==","id":"85381f31-91f3-463d-9c83-9607333c9235","signInActivity":{"lastSignInDateTime":"2026-06-11T11:02:49Z","lastSignInRequestId":"3aa8c8b6-f1aa-4523-aaed-6c49263e5e00","lastNonInteractiveSignInDateTime":"2026-06-11T11:29:14Z","lastNonInteractiveSignInRequestId":"a819e14b-b039-4c32-a3c5-7ecf95e74b00","lastSuccessfulSignInDateTime":"2026-06-11T11:29:14Z","lastSuccessfulSignInRequestId":"a819e14b-b039-4c32-a3c5-7ecf95e74b00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"5cDmmPesaUqyE3A8WmUPJw==","id":"d8524af1-5735-4a22-8694-d3639c52c15f","signInActivity":{"lastSignInDateTime":"2026-05-17T17:02:18Z","lastSignInRequestId":"81515eba-1e0e-4023-be30-50b1fb0b0a00","lastNonInteractiveSignInDateTime":"2026-06-15T08:25:25Z","lastNonInteractiveSignInRequestId":"4f776d8e-04e1-4141-9b41-2e2efb741e00","lastSuccessfulSignInDateTime":"2026-06-15T08:25:25Z","lastSuccessfulSignInRequestId":"4f776d8e-04e1-4141-9b41-2e2efb741e00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"eIrWG4zky0WWpNfPM6+Dqg==","id":"4b594721-8c22-43fd-bdea-4ec477624031","signInActivity":{"lastSignInDateTime":"2026-06-17T15:40:47Z","lastSignInRequestId":"625b1b91-17f2-4dc7-b899-d878ddb77100","lastNonInteractiveSignInDateTime":"2026-06-18T09:03:35Z","lastNonInteractiveSignInRequestId":"ef59895e-3828-4187-b757-d072c4e31d00","lastSuccessfulSignInDateTime":"2026-06-18T09:03:35Z","lastSuccessfulSignInRequestId":"ef59895e-3828-4187-b757-d072c4e31d00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"xGk7mWOWlkuq5p3eeC2CRA==","id":"b9c357b5-01b7-4ba1-b212-3961918ae16c","signInActivity":{"lastSignInDateTime":"2026-06-17T12:31:18Z","lastSignInRequestId":"58a53220-6e2a-4b77-abae-422097323000","lastNonInteractiveSignInDateTime":"2026-06-18T09:00:00Z","lastNonInteractiveSignInRequestId":"3bb5b8ef-f92b-4f49-bba2-547554561a00","lastSuccessfulSignInDateTime":"2026-06-18T09:00:00Z","lastSuccessfulSignInRequestId":"3bb5b8ef-f92b-4f49-bba2-547554561a00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"W2em94G+6UKaQJLg3OjXJQ==","id":"bb0fe74f-f6e6-4866-97b6-cf8ac8795d4f","signInActivity":{"lastSignInDateTime":"2026-06-16T13:24:03Z","lastSignInRequestId":"05aa5df3-988a-453a-bf88-b72d1b981300","lastNonInteractiveSignInDateTime":"2026-06-18T09:00:42Z","lastNonInteractiveSignInRequestId":"36d7b7ad-9789-43e5-93c2-2a5daff17000","lastSuccessfulSignInDateTime":"2026-06-18T09:00:42Z","lastSuccessfulSignInRequestId":"36d7b7ad-9789-43e5-93c2-2a5daff17000"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"MBVLYvlfoUaigWeOg7oxLA==","id":"bd16d126-d187-4eb8-acb5-a2045788f7dc","signInActivity":{"lastSignInDateTime":"2026-06-18T08:55:49Z","lastSignInRequestId":"b801bfb9-908e-4c35-8730-22914ea50100","lastNonInteractiveSignInDateTime":"2026-06-18T09:04:06Z","lastNonInteractiveSignInRequestId":"719ce8db-f7f1-4051-bcb6-b96e9cc78d00","lastSuccessfulSignInDateTime":"2026-06-18T09:02:03Z","lastSuccessfulSignInRequestId":"aa940005-35a2-4d69-976b-dc25b53e9800"}}]}
$allactivemembers | Select-Object -ExpandProperty 'signInActivity' -Debug
Produces the data, but if you inspect it, it shows the extraneous, non-printable characters. The command od -cx reveals them:
0000000 \n l a s t N o n I n t e r a c t
6c0a 7361 4e74 6e6f 6e49 6574 6172 7463
0000020 i v e S i g n I n D a t e T i m
7669 5365 6769 496e 446e 7461 5465 6d69
0000040 e : 6 / 1 8 / 2 0 2 6 9
2065 3a20 3620 312f 2f38 3032 3632 3920
0000060 : 0 4 : 3 5 ** ** A M \n l a s t
303a 3a34 3533 80e2 41af 0a4d 616c 7473
0000100 S i g n I n R e q u e s t I d
Module Version
ModuleType Version PreRelease Name ExportedCo
mmands
Script 1.0.12 Microsoft.Entra.Authentication {Add-Entr…
Script 1.0.12 Microsoft.Entra.Users {Get-Entr…
Environment Data
Name Value
PSVersion 7.6.3
PSEdition Core
GitCommitId 7.6.3
OS macOS 26.5.1
Platform Unix
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion 2.4
SerializationVersion 1.1.0.1
WSManStackVersion 3.0
Screenshots
N/A
Additional context
We have verified this is a MacOS-only issue. Data is "clean" on Wimdows.
We write a script to extract from Get-EntraUser the signInActivity property. We expand this property to get the lastSignInDateTime, lastSuccessfulSignInDateTime, and lastNonInteractiveSignInDateTime values. The script we use is:
Connect-Entra -Scope 'User.Read.All'
$allactivemembers = Get-EntraUser -Filter "accountEnabled eq true and userType eq 'Member'” -Limit 10 -Property displayName,userPrincipalName, onPremisesSamAccountName, onPremisesImmutableId, signInActivity
$allactivemembers | Select-Object -ExpandProperty 'signInActivity' | Export-Csv -Path “sampleoutput.csv"
When running the same PowerShell script on MacOS and on Windows, we get different results in the output. Specifically, in MacOS we get three non-printable characters in a date/time string, between the seconds and the AM or PM designator. They are: 0xE2 0x80 0xAF.
Thanks for reporting the bug. Please ensure you've gone through the following checklist before opening an issue:
Microsoft.EntraorMicrosoft.Entra.Beta.Describe the bug
To Reproduce
Steps to reproduce the behavior:
Connect-Entra -Scope 'User.Read.All'
$allactivemembers = Get-EntraUser -Filter "accountEnabled eq true and userType eq 'Member'” -Limit 10 -Property displayName,userPrincipalName, onPremisesSamAccountName, onPremisesImmutableId, signInActivity
$allactivemembers | Select-Object -ExpandProperty 'signInActivity' | Export-Csv -Path “sampleoutput.csv"
0000400 l e I d " \n " 6 / 1 6 / 2 0 2 6
656c 6449 0a22 3622 312f 2f36 3032 3632
0000420 4 : 4 3 : 0 5 ** ** P M " , "
3420 343a 3a33 3530 80e2 50af 224d 222c
0000440 a d d 0 9 5 4 b - b 1 1 8 - 4 c
6461 3064 3539 6234 622d 3131 2d38 6334
0000460 a 9 - b 7 5 1 - 7 f 9 d 8 9 2 5
3961 622d 3537 2d31 6637 6439 3938 3532
0000500 7 5 0 0 " , " 6 / 1 7 / 2 0 2 6
3537 3030 2c22 3622 312f 2f37 3032 3632
0000520 1 2 : 4 6 : 5 8 ** ** P M " ,
3120 3a32 3634 353a e238 af80 4d50 2c22
0000540 " a d d 0 9 5 4 b - b 1 1 8 - 4
6122 6464 3930 3435 2d62 3162 3831 342d
0000560 c a 9 - b 7 5 1 - 7 f 9 d 8 9 2
6163 2d39 3762 3135 372d 3966 3864 3239
0000600 5 7 5 0 0 " , " 6 / 1 7 / 2 0 2
3735 3035 2230 222c 2f36 3731 322f 3230
0000620 6 1 2 : 4 6 : 5 8 ** ** P M "
2036 3231 343a 3a36 3835 80e2 50af 224d
0000640 , " f 7 e 5 0 b f 7 - 2 3 d 9 -
222c 3766 3565 6230 3766 322d 6433 2d39
0000660 4 a 5 6 - b f 3 b - b a f 7 3 e
6134 3635 622d 3366 2d62 6162 3766 6533
Expected behavior
The output should be the same on a PC or Mac (with, perhaps, the lack of \r on a Mac at line ends)
Debug Output
⚠ ATTENTION: Be sure to remove any sensitive information that may be in the logs.
Debug Output
DEBUG: ============================ TRANSFORMATIONS ============================
DEBUG: Method : GET
DEBUG: Uri : /v1.0/users/?$select=displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity&$top=10&$Filter=accountEnabled eq true and userType eq 'Member'
DEBUG: =========================================================================
DEBUG: GET /v1.0/users/?$select=displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity&$top=10&$Filter=accountEnabled%20eq%20true%20and%20userType%20eq%20'Member' HTTP/1.1
HTTP: graph.microsoft.com
User-Agent: PowerShell/7.6.3 EntraPowershell/1.0.12 Get-EntraUser
DEBUG: GET https://graph.microsoft.com/v1.0/users/?$select=displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity&$top=10&$Filter=accountEnabled%20eq%20true%20and%20userType%20eq%20'Member'
HTTP/1.1 200 OK
Cache-Control: no-cache
Transfer-Encoding: chunked
Vary: Accept-Encoding
Strict-Transport-Security: max-age=31536000
request-id: cfe9c58f-3f89-4938-9b01-05fa34b7f1a3
client-request-id: aefb7bd5-7ba6-45c6-94bd-0e6ff668bfed
x-ms-ags-diagnostic: {"ServerInfo":{"DataCenter":"West US 2","Slice":"E","Ring":"4","ScaleUnit":"000","RoleInstance":"CO1PEPF00016241"}}
x-ms-resource-unit: 1
OData-Version: 4.0
Date: Thu, 18 Jun 2026 16:57:44 GMT
Content-Type: application/json; odata.metadata=minimal; odata.streaming=true; IEEE754Compatible=false; charset=utf-8
Content-Encoding: gzip
{"@odata.context":"https://graph.microsoft.com/v1.0/$metadata#users(displayName,userPrincipalName,onPremisesSamAccountName,onPremisesImmutableId,signInActivity)","@odata.nextLink":"https://graph.microsoft.com/v1.0/users/?$select=displayName%2cuserPrincipalName%2conPremisesSamAccountName%2conPremisesImmutableId%2csignInActivity&$top=10&$Filter=accountEnabled+eq+true+and+userType+eq+%27Member%27&$skiptoken=RFNwdAoAAQAAAAAAAAAAFAAAAEafF8mAgldOlr30ecd_1f8BAAAAAAAAAAAAAAAAAAAXMS4yLjg0MC4xMTM1NTYuMS40LjIzMzEGAAAAAAABUTnyiO8afEWg00Bm8rbXOQH_AAAAAQEAAAA","value":[{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"yCes/D+i7kOlMFT3dJsjvg==","id":"281a6583-b6d1-42ba-9012-d6f6383b4af9","signInActivity":{"lastSignInDateTime":"2026-06-17T18:07:04Z","lastSignInRequestId":"5e7f2752-4c25-4162-9439-0e4382c47400","lastNonInteractiveSignInDateTime":"2026-06-18T09:04:35Z","lastNonInteractiveSignInRequestId":"7a4fdcc1-29a7-475b-b8bc-4da8df698c00","lastSuccessfulSignInDateTime":"2026-06-18T09:04:35Z","lastSuccessfulSignInRequestId":"7a4fdcc1-29a7-475b-b8bc-4da8df698c00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"wJ2zqzr1aEiIVydU7MVuYQ==","id":"b3fafa6a-fccc-4051-9517-f65696975fee","signInActivity":{"lastSignInDateTime":"2026-06-18T07:48:51Z","lastSignInRequestId":"acf8cc9a-3b62-486f-a47a-b58e778a1700","lastNonInteractiveSignInDateTime":"2026-06-18T09:07:54Z","lastNonInteractiveSignInRequestId":"bfabc4eb-8fc5-4579-b2b6-d6ef451f8100","lastSuccessfulSignInDateTime":"2026-06-18T09:07:54Z","lastSuccessfulSignInRequestId":"bfabc4eb-8fc5-4579-b2b6-d6ef451f8100"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"t+uUF4ouXEiG2L1nViWhdA==","id":"4832b9a7-1d56-4c29-be82-74445f0f9469","signInActivity":{"lastSignInDateTime":"2026-06-18T06:27:28Z","lastSignInRequestId":"ed9df889-d494-4817-830d-5dbc86a12a00","lastNonInteractiveSignInDateTime":"2026-06-18T04:13:56Z","lastNonInteractiveSignInRequestId":"fae9fef5-02fd-4d01-926a-6c5b82e00200","lastSuccessfulSignInDateTime":"2026-06-18T06:27:28Z","lastSuccessfulSignInRequestId":"ed9df889-d494-4817-830d-5dbc86a12a00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"CjGNPPtqRkupO/taILUzag==","id":"3b12f7a5-7c25-4db2-9ef8-57fe417cf60b","signInActivity":{"lastSignInDateTime":"2026-06-17T13:53:46Z","lastSignInRequestId":"6372965d-63c1-464a-b347-a6aa70267b00","lastNonInteractiveSignInDateTime":"2026-06-18T09:05:35Z","lastNonInteractiveSignInRequestId":"2f46bc52-20cc-4c03-82c8-73f061d87600","lastSuccessfulSignInDateTime":"2026-06-18T09:05:35Z","lastSuccessfulSignInRequestId":"2f46bc52-20cc-4c03-82c8-73f061d87600"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"5uEakYyHeUaV5qqIob+nMg==","id":"85381f31-91f3-463d-9c83-9607333c9235","signInActivity":{"lastSignInDateTime":"2026-06-11T11:02:49Z","lastSignInRequestId":"3aa8c8b6-f1aa-4523-aaed-6c49263e5e00","lastNonInteractiveSignInDateTime":"2026-06-11T11:29:14Z","lastNonInteractiveSignInRequestId":"a819e14b-b039-4c32-a3c5-7ecf95e74b00","lastSuccessfulSignInDateTime":"2026-06-11T11:29:14Z","lastSuccessfulSignInRequestId":"a819e14b-b039-4c32-a3c5-7ecf95e74b00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"5cDmmPesaUqyE3A8WmUPJw==","id":"d8524af1-5735-4a22-8694-d3639c52c15f","signInActivity":{"lastSignInDateTime":"2026-05-17T17:02:18Z","lastSignInRequestId":"81515eba-1e0e-4023-be30-50b1fb0b0a00","lastNonInteractiveSignInDateTime":"2026-06-15T08:25:25Z","lastNonInteractiveSignInRequestId":"4f776d8e-04e1-4141-9b41-2e2efb741e00","lastSuccessfulSignInDateTime":"2026-06-15T08:25:25Z","lastSuccessfulSignInRequestId":"4f776d8e-04e1-4141-9b41-2e2efb741e00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"eIrWG4zky0WWpNfPM6+Dqg==","id":"4b594721-8c22-43fd-bdea-4ec477624031","signInActivity":{"lastSignInDateTime":"2026-06-17T15:40:47Z","lastSignInRequestId":"625b1b91-17f2-4dc7-b899-d878ddb77100","lastNonInteractiveSignInDateTime":"2026-06-18T09:03:35Z","lastNonInteractiveSignInRequestId":"ef59895e-3828-4187-b757-d072c4e31d00","lastSuccessfulSignInDateTime":"2026-06-18T09:03:35Z","lastSuccessfulSignInRequestId":"ef59895e-3828-4187-b757-d072c4e31d00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"xGk7mWOWlkuq5p3eeC2CRA==","id":"b9c357b5-01b7-4ba1-b212-3961918ae16c","signInActivity":{"lastSignInDateTime":"2026-06-17T12:31:18Z","lastSignInRequestId":"58a53220-6e2a-4b77-abae-422097323000","lastNonInteractiveSignInDateTime":"2026-06-18T09:00:00Z","lastNonInteractiveSignInRequestId":"3bb5b8ef-f92b-4f49-bba2-547554561a00","lastSuccessfulSignInDateTime":"2026-06-18T09:00:00Z","lastSuccessfulSignInRequestId":"3bb5b8ef-f92b-4f49-bba2-547554561a00"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"W2em94G+6UKaQJLg3OjXJQ==","id":"bb0fe74f-f6e6-4866-97b6-cf8ac8795d4f","signInActivity":{"lastSignInDateTime":"2026-06-16T13:24:03Z","lastSignInRequestId":"05aa5df3-988a-453a-bf88-b72d1b981300","lastNonInteractiveSignInDateTime":"2026-06-18T09:00:42Z","lastNonInteractiveSignInRequestId":"36d7b7ad-9789-43e5-93c2-2a5daff17000","lastSuccessfulSignInDateTime":"2026-06-18T09:00:42Z","lastSuccessfulSignInRequestId":"36d7b7ad-9789-43e5-93c2-2a5daff17000"}},{"displayName":"XXXXX","userPrincipalName":"XXXXX@zimmerbiomet.com","onPremisesSamAccountName":"XXXXX","onPremisesImmutableId":"MBVLYvlfoUaigWeOg7oxLA==","id":"bd16d126-d187-4eb8-acb5-a2045788f7dc","signInActivity":{"lastSignInDateTime":"2026-06-18T08:55:49Z","lastSignInRequestId":"b801bfb9-908e-4c35-8730-22914ea50100","lastNonInteractiveSignInDateTime":"2026-06-18T09:04:06Z","lastNonInteractiveSignInRequestId":"719ce8db-f7f1-4051-bcb6-b96e9cc78d00","lastSuccessfulSignInDateTime":"2026-06-18T09:02:03Z","lastSuccessfulSignInRequestId":"aa940005-35a2-4d69-976b-dc25b53e9800"}}]}
$allactivemembers | Select-Object -ExpandProperty 'signInActivity' -Debug
Produces the data, but if you inspect it, it shows the extraneous, non-printable characters. The command od -cx reveals them:
0000000 \n l a s t N o n I n t e r a c t
6c0a 7361 4e74 6e6f 6e49 6574 6172 7463
0000020 i v e S i g n I n D a t e T i m
7669 5365 6769 496e 446e 7461 5465 6d69
0000040 e : 6 / 1 8 / 2 0 2 6 9
2065 3a20 3620 312f 2f38 3032 3632 3920
0000060 : 0 4 : 3 5 ** ** A M \n l a s t
303a 3a34 3533 80e2 41af 0a4d 616c 7473
0000100 S i g n I n R e q u e s t I d
Module Version
ModuleType Version PreRelease Name ExportedCo
mmands
Script 1.0.12 Microsoft.Entra.Authentication {Add-Entr…
Script 1.0.12 Microsoft.Entra.Users {Get-Entr…
Environment Data
Name Value
PSVersion 7.6.3
PSEdition Core
GitCommitId 7.6.3
OS macOS 26.5.1
Platform Unix
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion 2.4
SerializationVersion 1.1.0.1
WSManStackVersion 3.0
Screenshots
N/A
Additional context
We have verified this is a MacOS-only issue. Data is "clean" on Wimdows.