How to extract Private Key from PKCS 12 (Pfx/P12)

Unlike the Public Key which is visible in the Certificate Details page, the private key wont be visible and can’t be downloaded directly. To download that in a readable format or as a text file follow the steps below,

Download and inst…

Keytool list command

To view the Certificates inside a keystore use the command below,


keytool -list -v -keystore


In the above syntax replace the with the keystore name. The above syntax is for normal certifi…

Error when executing query report

There are scenarios where a custom report or query report fails with the below exception in UI as well as in the logs,

This is due to the limitation of the Query cost configured. To increase that refer the instructions in the link below,


MySQl to PGSQL migration

Support for MySQL database is going to be terminated from June 2017. So we recommend all customers to migrate the database to either PGSQL or MSSQL database.


Step 1: Stop the ManageEngine ServiceDeskPlus-MSP service.
Step 2: Take a

Upgrade failure – 9009 to 9200 – Fix

In some scenarios upgrade fails from 9009 to 9200 with the below mentioned exception,



Problem during installation of patch {0}java.sql.SQLException: Cannot find the object “PgSQLErrorCode” because it doe…

Delete Support Group

Please follow the instructions below to check what could still be hindering the deletion of the Groups:


1.) Execute the below query to find the exact Group Id of the Group that you want to delete:


select qd.queuename “Gr…

How to change the request delimiter

By default the request delimiter will be ##. When you reply to a ticket, the subject line should contain ##ticketid##. Only then the reply will get appended to the parent ticket. If you want to change the delimiter you need to update the same i…