Need assistance on Bursting report for Visa and Passport expiration

Summary:

Hi,

Our requirement:

The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days.

Currently Alert composer is not working with Alert Schedulers.

Alternatively we need to progress the requirement by trigger the Alert via bursting report.

please share the sample query.

Thanks in Advance,

Ram

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):