SSL & persistence configurations from qkview or UCS files

The following script will produce a list of certificates with their expiration dates (from memory I just run this as a script from the BIG-IQ). Think I found it here on DevCentral a while ago and saved it.

#!/bin/bash
certs=$(tmsh list sys file ssl-cert | grep "sys file ssl-cert" | awk '{print $4}')
for cert in $certs; do
    expiration=$(tmsh list sys file ssl-cert $cert | grep expiration | awk '{print $2, $3, $4, $5, $6}')
    echo "Certificate: $cert expires on: $expiration"
done

Output will be similar to that shown below:

Certificate: DigiCert-chain.crt expires on: 1916438399   

"Sep 23 23:59:59 2030 GMT"

Certificate: DigiCert_Global_G2_TLS_RSA_SHA256_2020_CA1 expires on: 1916438399   

"Sep 23 23:59:59 2030 GMT"

Will probably need further tidying up before you put it into Excel but it is a starting point.