How to see the Expired Certificates for Certificate Inventory And Management Discovery for Different Certificate Authority(Godaddy,Digicert,Sectigo,Entrust)

[thiyagu_j]

In the cmdb_ci_certificate ci, the STATE choice list doesn't contain  Expired state. Then how the expired certificates are mapped and how to see the expired certificates?

Expired Certificate Mapping to STATE in cmdb_ci_certificate:

        ISSUED : ('issued', 'valid', 'expired', 'canceled', 'active' )

        The Certificates which are discovered as the above list will be mapped to the ISSUED state.

How to see the Expired certificates?

        There are two ways that can able to see the Expired Certificates

        1.Using Certificate Management Dashboard

                      This Dashboard will provide the list of certificates that are expired and which are certificates going to get expired etc.

        2.Using cmdb_ci_certificate CI

                     Goto cmdb_ci_certificate table, add the query for Valid To field and compare it with the current time. This will provide the list of certificates that are expired.