Forum Discussion
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.
- You 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_GrossSilver 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 GomezBrass 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 MishraCopper 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>