SQL CERTIFICATE MONITORING

How to monitor SQL certificate using port 1433? Do anyone have any custom groovy script to monitor All certificate using any port or any specific port specifically port 1433. We are using the certificate on our SQL server for their encrypted communication & need to check al servers certificate expiration days. Any help would be appreciated.

Sachin Tanwar

Posted 1 year ago·Last reply 1 year ago

2 comments

Cole McDonald

·1 year ago

LM has two SSL dataSources: "SSL_Certificates" and "SSLCerts-" that could be leveraged. You may need to add 1433 to the array that defines common ports, but they work well in our environment for other purposes.

Sachin Tanwar

OP1 year ago

Thanks for the suggestion however, I already tried that but won't work in my case.

1	SUYASH GAIKWAD
2	CH Chris Hasty
3	YA Yuliyan Angelov
4	KP Karsten Petersen
5	DW Darian Wong
6	DM Dhanikachalam Muthusamy