How to auto-notify stakeholders before integration client credentials expire?

[entcenginee]

Hi all,

I need to automate credential expiry notifications for our SAM Pro integrations (OAuth, Connection & Credential Aliases, etc.).

Goal: Detect credentials expiring within 30 days and automatically:

• Email mapped stakeholders
• Create a tracking task
• (Ideally) test connection post-update

My plan: A scheduled Flow Designer flow that checks a small registry table with integration name, credential alias, expiry date, and owner.

Questions:

1. Is there an OOTB feature or best practice for this?
2. Where does ServiceNow normally store expiry_date for OAuth or aliases?
3. Has anyone built this before and could share a step-by-step outline or lessons learned?
   

Thanks in advance for any guidance or examples!