Remove pending alerts for exited employees in bulk through backend query.

Client needs to remove the alerts which are pending with managers and POC's and this data is more than 2 years old, The alerts are especially to be removed for terminated employees. Manually identing the records and deleting will not be a feasible option hence will require a query to check pending/awaiting approval transaction of terminated employees and to withdraw them.

Please let us know if there are query which can built or used.

Thanks & Regards

Abhilash Anand