This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| vendors:cisco:uc:cucm [2024/05/21 13:51] – [CUCM / VOS install stuck in Installing State] gerardorourke | vendors:cisco:uc:cucm [2024/05/21 13:52] (current) – [CUCM / VOS install stuck in Installing State] gerardorourke |
|---|
| * Proceed with the upgrade. | * Proceed with the upgrade. |
| |
| ===== | ===== SQL to retrieve Certs ===== |
| <code> | <code> |
| run sql select c.serialnumber, c.servername, tcs.name, dist.moniker, c.ipv4address, c.certificate from certificate as c inner join certificateservicecertificatemap as cscm on c.pkid = cscm.fkcertificate inner join typecertificateservice as tcs on cscm.tkcertificateservice = tcs.enum inner join typecertificatedistribution as dist on c.tkcertificatedistribution = dist.enum | run sql select c.serialnumber, c.servername, tcs.name, dist.moniker, c.ipv4address, c.certificate from certificate as c inner join certificateservicecertificatemap as cscm on c.pkid = cscm.fkcertificate inner join typecertificateservice as tcs on cscm.tkcertificateservice = tcs.enum inner join typecertificatedistribution as dist on c.tkcertificatedistribution = dist.enum |