Request needs to be created for certificates which are about to expiry

[suuriyas]

HI Community,

I have a requirement, in sys certificate table we have few certificate records without any valid from and expires details (its empty) so expires in days field is also empty.

For these records we have decided, it should generate a request and send notification about the expiry.

When this records are created then created date plus 11 months from this time a request needs to be generated.

For example: when a record is created on jan 3rd then request needs to created automatically on nov 3rd.

How can we achieve this

Thanks in Advance

[Ram Devanathan1]

hope you know there is an ITOM app for this already, called TLS/SSL certificate inventory and management? is this an effort to build the same?

Ram

Director, ITOM Products

[Bhuvan]

@suuriyas 

Why not create After BR if 'valid_from' and 'expires' field are empty, set valid_from to current date/time and expires to 11 months from valid_from field and use out of box notifications.

This will simplify the logic and would help to avoid schedule jobs or custom validations to check 11 months from record creation date to trigger the request and notifications.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[suuriyas]

HI @Bhuvan  ,

Thanks for replying,

But we don't want this approach.