I need to generate a list of all my expired app registration (Client Secret)

Question

Hi,

we have around 5000 App registration and for housekeeping purposes i need to generate/export a list of all App registration where the Clients Secret is expired. Would be nice if i can get a list with the state what im currently seeing on portal (like: Expired, Expiring soon, Current). The portal itself can generate a CSV but that only handle 999.

Answer 1

Hi @johndoe-9621 ,

We do have a Powershell script sample for exporting all app registration secrets and certificates expiring beyond a required period:

https://learn.microsoft.com/en-us/entra/identity/enterprise-apps/scripts/powershell-export-apps-with-secrets-beyond-required

We also have a script for exporting all app registrations with expiring secrets and certificates. You can use it to export secrets expiring in the next X days and/or already expired.

https://learn.microsoft.com/en-us/entra/identity/enterprise-apps/scripts/powershell-export-apps-with-expiring-secrets

There are also some unofficial custom ones that others have shared online, but I have not tested these and cannot personally vouch for them.

Let me know if this helps and is what you are looking for!

If the information helped you, please Accept the answer. This will help us as well as others in the community who may be researching similar questions.