SQL query for tomcat certs in CUCM 8.6

[Troy Jones]

I have a query to see the server names and serial numbers, but I'm trying to expand that a bit. I want to look for a specific serial number. Here's my command:

run sql select pkid,servername,serialnumber, from certificate where serialnumber =

‘265dbfdf27ea2d9561c214de959f3c8596a221c00f6a5a5e63258c2356781308’

I keep getting a syntax error.

I'd also like to be able to view the expiration dates of the tomcat certs, and I'm not sure where to begin with that one. Any help is appreciated! 

[Aaron Harrison · Accepted solution]

Hi

Correct syntax would be:

run sql select pkid, servername, serialnumber from certificate where serialnumber =

‘265dbfdf27ea2d9561c214de959f3c8596a221c00f6a5a5e63258c2356781308’

Mainly there should not be a , after the field list (i.e on the end of 'serialnumber').

You can do this to see other properties in the table:

run sql select * from certificate where serialnumber =

‘265dbfdf27ea2d9561c214de959f3c8596a221c00f6a5a5e63258c2356781308’

Note that there is no experiation date shown in the table, though that would be part of the encoded certificate in the 'certificate' column.

Aaron