How to report on upcoming SSL certificate expiry ?

[Snehal13]

How to report on upcoming SSL certificate expiry ? what table holds this data and how to query it.

I do not have other paid module on the customer instance apart from ITSM basic and OOB reporting to work on. want to show a report on upcoming SSL certificate expiry so I know that not fixing these will impact instance 

[Amit Verma · Accepted solution]

@Snehal13 

As you don't have the Certificate Inventory and Management application from ServiceNow available, I will suggest you the below approach :

1) Extend cmdb_ci table to create a new table to store certificate data. It can hold records of Certificate and certificate installed on which servers data.

2) Also add installation date and the expiration date in the table created and make your report on this table to get about to expire certificates.

[Snehal13]

I did point 1 but how to get certificate data into the new table created as per point 1

[Amit Verma]

@Snehal13 

You can refer below link for the step by step process. Basically, you need to make use of import set for loading data in the table. 

@Snehal13 

You can refer below link for the step by step process. Basically, you need to make use of import set for loading data in the table. 

https://www.servicenow.com/community/developer-forum/how-to-load-data-to-table-from-excel/m-p/145186...

[Snehal13]

Amit, I am not getting this. I need reporting on upcoming expiring SSL certificates on the instance.

[Amit Verma]

Hi Snehal

To prepare the report, you will need the data to be uploaded to the table on which you will prepare your report. You can follow my earlier response to load the data first to the instance followed by report development.