Forum Discussion
Carlos Gomez
Aug 31, 2017Brass Contributor
Get all users subscribed to the self-service password reset service
Hi, Is there a way to get the list of users already subscribed for the SSPR or the ones that are still not joined to the service? Regards.
- Aug 31, 2017You are correct, I recently ran into this same issue with one of my clients.
This is just another example of needing to fully understand the capabilities and limitations of the tools while trying to keep up with the changes.
I would not be surprised to see these limits increased in the future.
Dean_Gross
Aug 31, 2017Silver Contributor
There are many reports available for that type of info, see https://docs.microsoft.com/en-us/azure/active-directory/active-directory-passwords-reporting.
The SSPR Funnel in the Azure AD Content Pack for Power BI may also be helpful, see https://docs.microsoft.com/en-us/azure/active-directory/active-directory-reporting-power-bi-content-pack-how-to
- Carlos GomezAug 31, 2017Brass Contributor
Thanks Dean,
I'm looking for more historical data, not for the last 30 days that AAD reporting provides, but it seems the we are the ones that should have stared collecting the historical data at our side, since I have not found any other solution.
"
Reporting API data retrieval limitations
Currently, the Azure AD Reports and Events API retrieves up to 75,000 individual events of the SsprActivityEvent and SsprRegistrationActivityEvent types, spanning the last 30 days.+
If you need to retrieve or store data beyond this window, we suggest persisting it in an external database and using the API to query the deltas that result. Our recommendation is to begin retrieving this data when you start using SSPR in your organization, persist it externally, and then continue to track the deltas from this point forward.
"
Regards.
- Satyavrat MishraJun 26, 2018Copper Contributor
You can try below powershell script to get the SSPR registered users:
Get-Msoluser -All | where {$_.StrongAuthenticationUserDetails -ne $null} | Export-CSV -path <path to CSV file>
- JonasBackDec 04, 2018Steel Contributor
That indeed shows which users that have registered for MFA. But is this the same as SSPR? In any way, in the new Converged registration for SSPR and MFA, this might all be the same.
- Dean_GrossAug 31, 2017Silver ContributorYou are correct, I recently ran into this same issue with one of my clients.
This is just another example of needing to fully understand the capabilities and limitations of the tools while trying to keep up with the changes.
I would not be surprised to see these limits increased in the future.- VasilMichevAug 31, 2017MVP
If you really need that data, there are 3rd party products, just saying :)