Sample Header Ad - 728x90

SSISDB - Certificates expired

0 votes
1 answer
504 views
I was doing an audit of certificates in our environments to find those that have either expired or are expiring in 30 days. I used the following query: SELECT * FROM sys.certificates WHERE expiry_date < DATEADD(DAY,30,GETDATE()); I noticed in SSISDB that there are a large number of expired certificates: enter image description here What are these certificates used for, is it an issue that they have expired? I have not heard any complaints from our development team that SSIS isn't working as expected.
Asked by SE1986 (2182 rep)
May 20, 2021, 01:30 PM
Last activity: Mar 16, 2024, 10:55 AM