It's possible this question will get moved onto another StackExchange site, but I'll supply an answer nonetheless.
Little bit of PowerShell magic should make this fairly simple. PowerShell can navigate the certificate store as if it were any other drive (like navigating the file system.)
To list all certificates on the system:
Get-ChildItem -Path Cert:\ -Recurse
If you only want the certs installed as the Current user, just change the 'directory':
Get-ChildItem -Path Cert:\CurrentUser -Recurse
(Note that the above commands return the 'folder' name followed by all the contained certs, which depending on what you're doing it could get messy.)
I assume from your question that you're only really worried about SSL Server Authentication Certs, so you can specifically get only those (and limit the output to only show the Subject, Path and Expiry of the Certs):
Get-ChildItem -Path Cert:\ -Recurse -SSLServerAuthentication | Select Subject, PSParentPath, NotAfter
You can then look at things like exporting the list to a CSV file (or database or whatever other method you want to use to collect them) and then onto running these on the remote servers from one central workstation and collect all the info locally.