When it comes time to rolling SSL certificates on web servers, nothing beats checking the server to see what is actually being served.
To start with, a disclaimer: I’m not a SQL person. No, not at all. I just find myself supporting services that use MSSQL as a backend. Here are a few functions I’ve recently written to help keep my sanity.
RSA Authentication Manager exports the list of users and SecurID fobs in a text format with multiline records. Moreover, if the user does not have a SecurID, the number of fields displayed is truncated. Fortunately, .CSV will gladly accept 'short' records. Here is a way to convert the User.DMP file that lists all users in the RSA Authentication Manager DB, and their fobs if present.
Quick and dirty wrapper for LogParser to download Event Logs