Next Control Attestation date

Arnaud Bretz1
Tera Contributor

Hi everyone !

 

My customer would like to report on the next attestation date of his controls. Unfortunately, there is no existing OOTB data or field that provides this information. However, we can estimate the next attestation date by considering the control's frequency and the date of the last attestation (recorded in the "take on" field of the assessment instance).

 

For example, let's consider a control with an annual frequency that was attested on June 19, 2023. Based on this frequency, ServiceNow will automatically re-attest this control on June 19, 2024.

 

Now, I'm seeking your expertise on how we can fetch and include this next assessment date in a report. Any ideas or suggestions would be greatly appreciated!

 

Arnaud,

 

 

 

Do you have any idea how I could fetch this next assessment date in a report ? 

1 REPLY 1

dmathur09
Kilo Sage
Kilo Sage

Hi Arnaud,

 

You would be required to create a new date field as new attestation date, which would be populated based on your taken on and the frequency. In your calculation you can define the frequency choices as your number of days.

 

Regards,

Deepankar Mathur