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 

[Dr Atul - LNG]

HI @Snehal13 

Greetings!!

Might be worth to check

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

[Snehal13]

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

[vermaamit16]

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

[Snehal13]

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