How to download discovered certificate in .pem or .vfx format via URL based discovery

[Kamini07]

Hello Experts,

My query is on Discovered certificate. The requirement is to download the discovered certificate in pem or vfx format. 

Currently I can find certificates in 2 diff tables: 

sn_disco_certmgmt_cmdb_installed_certificate

And the sys_certificate table (from this I can download the attachment)

Do I need to do any customization to get the discovered certificate download into above 2 formats or do we have any OOTB option available

Awaiting your response!

@Ankur Bawiskar 

Regards

[Community Alums]

Hi @Kamini07 , 

You can find the certificates in sys_certificate table. please add "Format" field to your list view. OOTB two formats are supported option 1 is PEM and option 2 is DER format. 

If you open PEM Format certificate record. In the attachment, you find a certificate in .pfx format as shown below. 

If you open DER Format certificate record. In the related links, you find a Generate certificate in PEM format as shown below. 

Then you get a banner pop up on the form view and scroll down to view the actual PEM Certificate. 

If this solution resolved your issue, please mark it as helpful or accept it as the solution.

Regards, 

Srinija

[Kamini07]

Yeah I agree , but could you please confirm if all the discovered certificates are being stored into sys_certificate table itself. We wont need to make any customisation?

[mike533mike]

To download the discovered certificate in PEM or VFX format, you typically need to use the sys_certificate table, which contains attachments for certificates. If the certificates are not in the desired format, you may need to perform some customization, as out-of-the-box (OOTB) functionality in ServiceNow may not directly support exporting in these specific formats. Custom scripts or tools could be used to convert the certificate data from the system into PEM or VFX format. The sn_disco_certmgmt_cmdb_installed_certificate table is more related to discovery data but may not offer the download in the exact format you need. Customization is likely required unless a new feature or plugin has been introduced in the platform to support this.