Expiring certificates

Is it possible to get a list of certificates that are going to expire soon in VM?

Hi @SaanviL ,

Sure, you can perform SQL Report querys to achieve this. You can build your own, or use one of the provided by Rapid7. Take a look of the repo:

insightvm-sql-queries/data-warehouse-sql-queries at master · rapid7/insightvm-sql-queries · GitHub

Maybe this works for you:
insightvm-sql-queries/data-warehouse-sql-queries/SSL-Certs-datawarehouse.sql at master · rapid7/insightvm-sql-queries · GitHub

Best Regards

2 Likes

looks good let me try thanks

edit: it worked thanks