SQL CERTIFICATE MONITORING

Question

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 &amp; need to check al servers certificate expiration days. Any help would be appreciated.

sachin-tanwar · Answer

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

cole_mcdonald · Answer

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

Forum Discussion

SQL CERTIFICATE MONITORING

Related Content

SQL Certificates

Pulling all certificates from internal CA

SQL Server Services Status

Pulling SSL certs from a local Certificate store

Stop SQL instance monitoring

Recent Discussions

Datapoints configuration Discussion

Freqency of Alerts

SQL CERTIFICATE MONITORING

CERTIFICATES - GET ALL CERTIFICATES FROM SERVER

Programmatic Ping Alert