Automation of CMDB Attestations -1

[nameisnani]

Hi Team , 

can anyone please help me on this requriment 

The ARC Assessment needs to be completed by the person who manages the Business Application every 12 Months - The intension of this request is to set up a way of reminding the Manager of the Business Application that the ARC assesment is due to be completed 1 month ahead of the yearly anniversary of the assessment - First write a query that identifies all the business applications that are due for an ARC assessment reminder letter

In other words the query Returns all the Business Application values where
(Today) = "ARC Assessment Date" + 11 Months
For those Business Applications generate an email to the "Managed By" person to remind them that their ARC assessment is due in the next 30 Days
This job should run on a schedule which is to be defined - I suggest daily

[Mark Manders]

Create a flow that runs on your schedule, do a look up to all the business applications and trigger the notification from the flow (create it as 'triggered' and on the business application table, so you have all the fields you need for it).