Expiration Field for Issued Certificates

[KeanuAL]

Hello,

currently i implement an internal CA for my Company. We want notify Certificate Expiration via Mail and Monitoring. I use PostgresSQL as Database and query the Results directly from the Database. But i cant query the column Expiration, because it doesnt exists in the table items. Only the Issue Date is exist. Will it be possible to do a schema update on the xca-Database to get the expiration column?

Actually i have to extract the Issue Date and manipulate with Date Calculation on Linux the Validity Time in Days. It would be more flexible to have this field and i can make one shell script.

Kind of regards

Keanu