Broadcast check for disabled email in AD group before sending

We currently have a situation where when we add a user to a subscription/schedule in YF and then when that user leaves our trust, they would still receive those subscriptions because we use multiple domain emails. These emails stay with the user, so if they go to another trust the email will get associated to that new trust’s domain and will still receive emails from our subscriptions. Should the nhs.net email not be used for a period of 9 months or more then it automatically deletes, but should a user access their email account within the 9-month period, then from that day the 9-month timescale resets.

To address this issue, we manually remove those leavers from subscriptions in YF and SSRS on a monthly basis. This is a cumbersome task that could be automated.

The solution would be for us to convert to AD for logging into YF and using AD groups in YF, the intention would be that YF would detect a disabled account in the group that IT automatically implement when staff leave the trust and then not send subscription emails to that user. This then means that should the user continue to use their email on leaving this trust or if they retire for example and decide to access their email accounts within the 9-month period, then they would not have received our subscriptions as of the day they had their accounts removed.