How to report on upcoming SSL certificate expiry ?

Snehal13 · ‎09-22-2024

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 · ‎09-23-2024

@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

Dr Atul G- LNG · ‎09-22-2024

HI @Snehal13

Greetings!!

Might be worth to check

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0538674

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Snehal13 · ‎09-22-2024

The link you shared provide details of setting up Certificate on the instance. My ask is to report on upcoming SSL certificate expiry so need to know table that holds this data and query it on a report to get details

Amit Verma · ‎09-22-2024

Hi @Snehal13

You can refer below links which makes use of a Scheduled Job to trigger a notification.

https://www.servicenow.com/community/itom-forum/email-notification-for-certificate-expiry/m-p/253864...

https://www.servicenow.com/community/developer-forum/i-want-to-send-mutiliple-notifications-on-certi...

Thanks and Regards

Amit Verma

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

Snehal13 · ‎09-22-2024

The link you shared provide details of setting up email for certificate expiry reminders. My ask is to report (using OOB reporting of ServiceNow) on upcoming SSL certificate expiry so need to know table that holds this data and query it on a report to get details