How to report on upcoming SSL certificate expiry ?

Go to solution
Snehal13
Kilo Sage

‎09-22-2024 10:07 PM - edited ‎09-22-2024 10:08 PM

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 

0 Helpfuls
  • 1,531 Views
1 ACCEPTED SOLUTION

Go to solution
Amit Verma
Kilo Patron
Kilo Patron
In response to Snehal13

‎09-23-2024 12:34 AM

@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.


Please mark this response as correct and helpful if it assisted you with your question.

View solution in original post

0 Helpfuls
12 REPLIES 12

Go to solution
Snehal13
Kilo Sage
In response to Amit Verma

‎09-26-2024 12:40 AM

I get the idea but where to load the data from in my custom table. 

0 Helpfuls

Go to solution
Amit Verma
Kilo Patron
Kilo Patron
In response to Snehal13

‎09-26-2024 01:05 AM

You can take the certificate dump in an excel and load it in the custom table.


Please mark this response as correct and helpful if it assisted you with your question.
0 Helpfuls

Go to solution
Snehal13
Kilo Sage
In response to Amit Verma

‎09-27-2024 07:38 PM

From where I can get the upcoming expiring certification dump ? Can I not query the table itself which hold certificate related info ?

0 Helpfuls