Certificate Management | How to Add a Self-Signed Certificate to the Bulk Certificate Upload TemplateSummary<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } This article serves as a guide on how to add a self-signed certificate to the Certificate Bulk Upload Template and covers the following topics. How to export the certificate to a fileWhere to download the template fromHow to get the property values from a certificate fileHow to appropriately set the certificate values to the template Facts<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Self-Signed Certificate: A self-signed certificate is created and authenticated by its creator instead of a trusted third-party CA, with the issuer and subject being the same entity. While it removes external validation requirements, it poses security risks due to increased vulnerability to spoofing or man-in-the-middle attacks, especially in internal/test environments. If the certificate you want to add to the Bulk Upload Template is not a Self-Signed Certificate then please follow the below article instead. KB2640214: Certificate Management | How to Add Certificates from a Certificate Chain to the Bulk Certificate Upload Template Bulk Certificate Upload Template: The Bulk Upload Template can be downloaded from your instance following the below procedure. Navigate to All > Certificate Management > Bulk Upload Certificates.From the Bulk Upload page, select Download Template File (.xlsx) link to download the sample_cmdb_ci_certificate.xlsx file.Open the downloaded sample_cmdb_ci_certificate.xlsx file. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Certificate Inventory and Management version 1.2.0 and later Instructions<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } I. Export the Certificate from a Web Browser Note: The below procedure is using Chrome, steps will be similar but may vary in other web browsers. A quick Google search on "how to export ssl certificate from <web browser name>" should return exact steps. Open Chrome browser and navigate to the website for which you want to export the certificate. Click the padlock icon in the URL bar. Click Connection is secure and then Certificate is valid. A certificate viewer window will appear. Click the Details tab. Click the Export button at the bottom. In the Certificate Export Wizard, choose the format Base64 encoded ASCII, single certificate and click Next. Name the file ending with .pem, select a location, and click Save. II. Get the Certificate Properties from the Certificate file The below columns from the Bulk Upload Template are mandatory fields that must be filled in on the template. root_issuerissuersubject_common_nameissuer_common_namefingerprintissuer_distinguished_namesubject_distinguished_namefingerprint_algorithmvalid_to: Cannot be less than valid_fom. By milliseconds. For example, 1586789478000 represents 13 April 2020 14:51:18valid_from: By milliseconds. For example, 1586789478000 represents 13 April 2020 14:51:18signature_algorithmkey_sizestate: issued, installed, revoked, retired, or other If you're not sure where to get these certificate properties from in the certificate then you can follow either of the two below KB articles depending on what OS the computer you're implementing this from is running. UNIX/Linux OS with openssl installed: KB2624956: Certificate Management | openssl Commands to Get Field Data From an SSL Certificate File for Populating the Template to Bulk Upload Certificates Windows OS: KB2631375: Certificate Management | PowerShell Commands to Get Field Data from an SSL Certificate File for Populating the template to Bulk Upload Certificates III. Add the Self-Signed Certificate to The Bulk Upload Template 1. Add any of the below properties that you collected from the Self-Signed Certificate to the Bulk Upload Template. fingerprint, fingerprint_algorithm, is_ca, issuer_common_name, issuer_distinguished_name, key_size, valid_to, valid_from, version, serial_number, signature_algorithm, subject_common_name, subject_distinguished_name, subject_organization, subject_organizational_unit, subject_email, subject_country, subject_state, subject_locality, subject_alternative_name 2. For Self-Signed Certificates the issuer and the root_issuer columns must have the same value as the certificate's fingerprint. Example: If the certificate's fingerprint is 1dfc1605fbad358d8bc844f76d15203fac9ca5c1a79fd4857ffaf2864fbebf96 Then the certificates issuer will also be 1dfc1605fbad358d8bc844f76d15203fac9ca5c1a79fd4857ffaf2864fbebf96 And the certificates root_issuer field will also be 1dfc1605fbad358d8bc844f76d15203fac9ca5c1a79fd4857ffaf2864fbebf96 3. Set the state column to the appropriate value from below choices. issued, installed, revoked, retired, or other 4. Save the Bulk Upload Template xlsx file. 5. Navigate to Certificate Management > Bulk Upload Certificates. 6. Select Browse File and choose the Bulk Upload Template xlsx file. 7. Select Upload. Related Links<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } ServiceNow Product Documentation - Use bulk certificate upload