Get-PartnerSignInActivity issue

[kevinbasoftcat]

Steps to reproduce

https://docs.microsoft.com/en-us/powershell/module/partnercenter/get-partnerusersigninactivity?view=partnercenterps-2.0

What steps can reproduce the defect?
With the latest version .4 we are now getting all user's returned when using the Get-PartnerUser however when running the second part of the sign in activity commands we are getting the below error.

Get-PartnerUserSignInActivity : Code: generalException
Message: An error occurred sending the request.
At line:1 char:31

• ... rs.ForEach({Get-PartnerUserSignInActivity -StartDate (Get-Date).AddDa ...

•             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : NotSpecified: (:) [Get-PartnerUserSignInActivity], ServiceException
  • FullyQualifiedErrorId : Microsoft.Graph.ServiceException,Microsoft.Store.PartnerCenter.PowerShell.Commands.GetPartnerUserSignInActivity

Please share the setup, commandline for vstest.console, sample project, target
framework etc.

Expected behavior

Share the expected output

Actual behavior

What is the behavior observed?

Diagnostic logs

Please share test platform diagnostics logs.
The logs may contain test assembly paths, kindly review and mask those before sharing.

Environment

Please share additional details about your environment.
Version 2.0.1911.4

[ghost]

@kevinbasoftcat would you mind sharing the details on how you authenticating and actual commands you running to get this error?

[kevinbasoftcat]

Hi Isaiah, I am authenticating using my global admin username and password that is an admin agent in our partner account. The commands I am running are from Example 6 in the below. https://docs.microsoft.com/en-us/powershell/module/partnercenter/get-partnerusersigninactivity?view=partnercenterps-2.0 Thanks, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 20 November 2019 15:17 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> would you mind sharing the details on how you authenticating and actual commands you running to get this error? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXNBOA7PQUYPUB5XOYDQUVIGDA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEESKEGY#issuecomment-556048923>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXJDVHM4NTMZ6ZW7MRLQUVIGDANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat thank you for the quick response. Just to confirm you are running Connect-PartnerCenter without any parameters when connecting correct?

If that is the case, then this issue for certain is not caused by authentication. Which means that Microsoft Graph is throwing an error in your circumstance, that is not being handled. To help isolate this error would you be able to run Fiddler to capture the request and full error when making this request?

[kevinbasoftcat]

Hi Isaiah, I am wandering if the issue was me running this in the background while doing other things on the same machine. I have just spun up an Azure VM to run it from and am running fiddler alongside the command to record the logs. As we have 4000+ users the command takes a long time to run and error so I will update you once it completes or errors with the fiddler logs. Thanks, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 20 November 2019 15:25 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> thank you for the quick response. Just to confirm you are running Connect-PartnerCenter without any parameters when connecting correct? If that is the case, then this issue for certain is not caused by authentication. Which means that Microsoft Graph is throwing an error in your circumstance, that is not being handled. To help isolate this error would you be able to run Fiddler<https://www.telerik.com/fiddler> to capture the request and full error when making this request? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXJMGKH22DR2CXCCF23QUVJEFA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEESLDIY#issuecomment-556052899>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXM6INPXGRX7KUDWHP3QUVJEFANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat thank you for helping troubleshoot this, and smart thinking on using a virtual machine. There should not be an impact of you doing operations in the background, but it will be interesting to see what you discover.

[kevinbasoftcat]

Hi Isaiah, The command started to error so I stopped it and saved the fiddler log which is available in the attached. Please let me know If you need anything else. Kind Regards, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 20 November 2019 15:52 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> thank you for helping troubleshoot this, and smart thinking on using a virtual machine. There should not be an impact of you doing operations in the background, but it will be interesting to see what you discover. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXMJDAHZYFOO5OYDB4TQUVMIJA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEESOZBI#issuecomment-556067973>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXNOS7WXAZCG2QM45SLQUVMIJANCNFSM4JPUDLAQ>.

[ghost]

Hi @kevinbasoftcat, thank you for you helping with this. It does not look like the attachment came through. Can you email it to isaiah.williams@microsoft.com?

[kevinbasoftcat]

Hi Isaiah, Just sent them over using a shared link from my One Drive so that should come through to your email address any issues let me know. Thanks, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 20 November 2019 16:45 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) Hi @kevinbasoftcat<https://github.com/kevinbasoftcat>, thank you for you helping with this. It does not look like the attachment came through. Can you email it to isaiah.williams@microsoft.com<mailto:isaiah.williams@microsoft.com>? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXMVX4SJWSS65BT227DQUVSPNA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEESU3LQ#issuecomment-556092846>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXLRPWONOGDFEQJFFQLQUVSPNANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat I just released version 2.0.1911.5 that contains a handful of enhancements. When you get an opportunity can you update to this version and try again?

[kevinbasoftcat]

Hi Isaiah, I installed the latest version and ran the commands again with fiddler also running. Below is the link to the fiddler logs and the Resolve-PartnerError command as the errors started appearing after about 20-30 minutes. Please let me know if you need anything else. Kind Regards, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 22 November 2019 19:12 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> I just released version 2.0.1911.5<https://www.powershellgallery.com/packages/PartnerCenter/2.0.1911.5> that contains a handful of enhancements. When you get an opportunity can you update to this version and try again? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXPQXTECU2RSR2EGGDDQVAVJDA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEE6SXGA#issuecomment-557656984>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXN53HD2LQJ2JFP5C4LQVAVJDANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat I having issue accessing the link you shared. Would it be possible for you to email the zip file to isaiah.williams@microsoft.com?

[ghost]

@kevinbasoftcat thank you for sharing the details with me. I have been digging into this further and discovered what I believe to be the root cause for the issue. The required code changes have been made and the hope is to have an update available through the PowerShell gallery before the end of the year.

[kevinbasoftcat]

Hi Isaiah, Thank you for the updates. Based on the below I assume the new version 3.0 will still have the same issues so should I wait for the new code to be released or try using the version 3.0 release? Kind Regards, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 08 December 2019 05:28 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> thank you for sharing the details with me. I have been digging into this further and discovered what I believe to be the root cause for the issue. The required code changes have been made and the hope is to have an update available through the PowerShell gallery before the end of the year. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXL3UXRSW7CVBRFR6S3QXSAVDA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEGGWJNQ#issuecomment-562914486>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXLYC3NQOAIE7CQLJHTQXSAVDANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat version 3.0.1 of the module has been released. It includes a handful of enhancements that should resolve the root cause of this issue. Would you be able to update and try the following?

1. Run the command as you have been. I am interested to know if you are still encountering the thread pool starvation issue
2. If you encounter issues with the above restart the machine and try the details documented below
3. Run the following command

Get-PartnerUserSignInActivity -StartDate (Get-Date).AddDays(-7)

Thank you for helping us test and validate everything is working as excepted.

[kevinbasoftcat]

Thanks Isaiah I have downloaded the new version and am testing on my Azure machine now. Will let you know how it goes. From: Isaiah Williams <notifications@github.com> Sent: 11 December 2019 17:36 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> version 3.0.1<https://www.powershellgallery.com/packages/PartnerCenter/3.0.1> of the module has been released. It includes a handful of enhancements that should resolve the root cause of this issue. Would you be able to update and try the following? 1. Run the command as you have been. I am interested to know if you are still encountering the thread pool starvation issue 2. If you encounter issues with the above restart the machine and try the details documented below 3. Run the following command Get-PartnerUserSignInActivity -StartDate (Get-Date).AddDays(-7) Thank you for helping us test and validate everything is working as excepted. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXJWQJLR55LB7ESFXJTQYEQJNA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEGT6UDI#issuecomment-564652557>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXLCBY7S3XGHFQ3ZH3LQYEQJNANCNFSM4JPUDLAQ>.

[kevinbasoftcat]

Hi Isaiah, Checking after lunch and the errors have returned. I then tried your other command but get the general exception error for that as well see below. Please let me know if you need me to grab any fiddler logs. Thanks, Kevin Barlow [cid:image002.png@01D5B0EE.0D636360] From: Kevin Barlow Sent: 12 December 2019 11:52 To: microsoft/Partner-Center-PowerShell <reply@reply.github.com>; microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Mention <mention@noreply.github.com> Subject: RE: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) Thanks Isaiah I have downloaded the new version and am testing on my Azure machine now. Will let you know how it goes. From: Isaiah Williams <notifications@github.com<mailto:notifications@github.com>> Sent: 11 December 2019 17:36 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com<mailto:Partner-Center-PowerShell@noreply.github.com>> Cc: Kevin Barlow <KevinBa@softcat.com<mailto:KevinBa@softcat.com>>; Mention <mention@noreply.github.com<mailto:mention@noreply.github.com>> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> version 3.0.1<https://www.powershellgallery.com/packages/PartnerCenter/3.0.1> of the module has been released. It includes a handful of enhancements that should resolve the root cause of this issue. Would you be able to update and try the following? 1. Run the command as you have been. I am interested to know if you are still encountering the thread pool starvation issue 2. If you encounter issues with the above restart the machine and try the details documented below 3. Run the following command Get-PartnerUserSignInActivity -StartDate (Get-Date).AddDays(-7) Thank you for helping us test and validate everything is working as excepted. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXJWQJLR55LB7ESFXJTQYEQJNA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEGT6UDI#issuecomment-564652557>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXLCBY7S3XGHFQ3ZH3LQYEQJNANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat I have good news, the root cause for this issue has been identified. Through issue #230 I was able to isolated what was happening. Currently I am trying to wrap up the solution needed to resolve this issue

[kevinbasoftcat]

Hi Isaiah, Perfect thank you for the update. If you could let me know when you want me to test I can carry out testing for you. Kind Regards, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 18 December 2019 16:30 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> I have good news, the root cause for this issue has been identified. Through issue #230<#230> I was able to isolated what was happening. Currently I am trying to wrap up the solution needed to resolve this issue — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXKELE6HQYHR7GSUKBLQZJFZXA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEHGWGAA#issuecomment-567108352>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXIHHSF4KIEDAQZVUC3QZJFZXANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat version 3.0.2 was just released. The only change included in that release was an update that addressed the root cause of this issue. Before I close this issue I was hoping that you could test to verify that everything is working as expected for you.

[kevinbasoftcat]

Hi Isaiah, Thank you for the update I have tested and the command is now working without generating any errors so thank you for your persistence in getting this resolved. I do however have 1 further query as the line after the logon activities are obtained to display API activities without MFA returns blank even though we have API calls being made without MFA. Is this expected behaviour? https://docs.microsoft.com/en-us/powershell/module/partnercenter/get-partnerusersigninactivity?view=partnercenterps-2.0 $activities | ? {$_.AuthenticationDetails | ? {$_.Succeeded -eq $true}} | ? {$_.MfaDetail -eq $null} | ? {$_.ResourceId -eq 'fa3d9a0c-3fb0-42cc-9193-47c7ecd2edbd'} Kind Regards, Kevin Barlow From: Isaiah Williams <notifications@github.com> Sent: 19 December 2019 18:00 To: microsoft/Partner-Center-PowerShell <Partner-Center-PowerShell@noreply.github.com> Cc: Kevin Barlow <KevinBa@softcat.com>; Mention <mention@noreply.github.com> Subject: Re: [microsoft/Partner-Center-PowerShell] Get-PartnerSignInActivity issue (#194) @kevinbasoftcat<https://github.com/kevinbasoftcat> version 3.0.2<https://www.powershellgallery.com/packages/PartnerCenter/3.0.2> was just released. The only change included in that release was an update that addressed the root cause of this issue. Before I close this issue I was hoping that you could test to verify that everything is working as expected for you. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#194?email_source=notifications&email_token=ALYGVXONIDUZGKYEBDTYQF3QZOZCBA5CNFSM4JPUDLA2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEHKNQRQ#issuecomment-567597126>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALYGVXPA3C4QA7KKN23X2L3QZOZCBANCNFSM4JPUDLAQ>.

[ghost]

@kevinbasoftcat this is particular interesting question because it will depend on a number of factors. This type of result could be due to one of the following scenarios

1. Your integration has not perform any operations in the last seven days
2. Your integration is leveraging a persistent token cache, which the token is being updated when expired instead of regenerated. This type of event is not available through the sign-in activities
3. Your integration is leveraging the Secure Application Model, which is similar to behavior described in scenario two
4. Your integration is leveraging app-only authentication (this is where a client identifier and secret key are used to get an access token), this type authentication is not captured in the sign-in activity logs.

If you the above scenarios do not apply to your integration, then it would be worth looking at the sign-in activities in Azure AD for the an account you know that is being used. That way you can verify that there is not an issue.

[ghost]

If you have further concerns or issues please let us know.