Forum Discussion

Larry_Rice_1091's avatar
Larry_Rice_1091
Icon for Nimbostratus rankNimbostratus
Jun 17, 2014

EM - f5em DB access - SSL cert list

I need to pull SSL cert expiration information from the DB and it does not appear to be available in the F5EM-extern DB. Obviously EM has access and the info stored as it can generate the report. I want to pull that info into another DB. What is the best way to do this?

 

BIG-IP Access Policy Manager (APM)
management
security

4 Replies

  • R_Eastman_13667's avatar
    R_Eastman_13667
    Historic F5 Account
    Oct 16, 2014

    This should help you.

     

    https://devcentral.f5.com/questions/script-to-check-for-certificate-expiration

     

  • Larry_Rice_1091's avatar
    Larry_Rice_1091
    Icon for Nimbostratus rankNimbostratus
    Oct 22, 2014

    thank you R Eastman for your suggestion. I have the F5 Enterprise Manager and was looking for a way to get at the data to pull into My Solarwinds Orion implementation we use for our monitoring and alerting. We have a decent amount of Certs not in F5 on appliances and such, thus wanted a single system to act like CMDB, with F5 EM DB being authority for F5 certs. I ended up using the excel report and using MS SQL import wizard to ingest into table.