SSL & persistence configurations from qkview or UCS files

Hi, 
You can review it in iHealth portal on F5 by uploading your Qkview file, 
you can get all info about expired Certificates and which Client ssl profile uses it as well then map it to Virtual servers. 

also you can get the persistence configs from iHealth as well. 

But I believe no tool to grap them in excel file, you need a python script to fetch the needed data and I think it's complex, so do it manually, 
you will find ssl expired certificates in Diagnostics tap inside iHealth portal, and put the info inisde Word docs or excel if you need. 

Also, you can do some bash shell scripts on BIGIP Cli to grap the certs and Virtual server names in Excel format. 

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.