Hi
I am not aware of any OOTB, but you can write a custom service that uses API:-
Link:- https://docs.adobe.com/content/docs/en/cq/5-6-1/javadoc/com/day/cq/dam/commons/util/DamUtil.html
findExpiringAssets(Session session, Calendar lowerBound, Calendar upperBound)
Find all dam assets which are getting expired between lowerBound and upperBound.
Option 2:-
Please have a look at this documentation: -
Link: - https://docs.adobe.com/docs/en/aem/6-1/author/assets/managing-assets-touch-ui/drm.html#Search expired assets
//Here you can get alert via email
To enable the Assets console to display the referencing compound assets along with the expired subassets, configure an Adobe CQ DAM Expiry Notification workflow in AEM Configuration Manager.
From the Rail, select Tools > Web Console to display AEM Configuration Manager.
Choose Adobe CQ DAM Expiry Notification. By default, Time based Scheduler is selected, which schedules a job to check at a specific time whether an asset has expired subassets. After the job completes, assets that have expired subassets and referenced assets are displayed as expired in search results.
To run the job periodically, clear the Time Based Scheduler Rule field and modify the time in seconds in the Periodic Scheduler field. For example, the example expression '0 0 0 * * ?' triggers the job at 00 hrs.
Select send email to receive emails when an asset expires.
I hope this would helpful.
Thanks and Regards
Kautuk Sahni