Converting Exported Certificate Information From Sybase DB to Readable .cer file

  • 7017256
  • 12-Feb-2016
  • 21-Mar-2016


Novell ZENworks Configuration Management 11


For troubleshooting purposes where the certificate information from the database is needed in the .cer file format.


1. Open a text editor with a blank new file.

2. Copy and paste the following into the open file:



3. Do the following query to get the certificate information: " SELECT * from zCertificate; " (this will pull on all certificates in that table along with other info)

4.  Use the "Copy from Cell" right click option on the desired 'Certificate' information and paste that in between the begin and end statement

5. Save file as .cer file


The way ZENworks stores certificate information includes end of line statements (\x0a, \x0d). It also contains single quotes at the beginning and end. Furthermore it does not contain the begin and end statements as found in valid certificates.