Auto creation service catalog when certificate expires

[dvass0107]

Team,

I am new to core development and scripting.

I have a task to check daily on sys_certificate table and if 'Warn in expire days' is 90 days (difference btw expires date and current date ) then map the following fields to the service catelog and create below 2 tasks.

Mapping fields to service catelog:

Name
Valid from
Expires
Expire in Days
Ownership Team
Certificate Type
Task 1:Update Certificate

 variable group to pull the Ownership Team from the certificate form and team will update the certificate and close the task.

Task2:Validate Certificate Inventory

 Certificate management group will verity the updated record and close the ticket.
Your help is highly appreciated

Regards,

Srinivas

[Kieran Anson]

My recommendation would be to use a flow which runs daily and uses a relative query to find all records that will expire in 90 days. You can then use the catalog item flow action to raise a request

[dvass0107]

Hi Kieran,

I did not work on flow designer , would you mind helping in detail please

Regards,

Srinivas