How do I convert the database from PGSQL to MSSQL?
Step 1: Stop ManageEngine ServiceDeskPlus – MSP service.
Step 2: Take a backup of the existing data and configuration under PGSQL database.
Open CMD as an admin and execute command to start the data backup.
This backup will be stored under the Backup folder in ServiceDeskPlus – MSP Home directory.
Step 3: Open database setup wizard using the below command,
Step 4: Provide the details of the SQL server (i.e.) Host name, username and password and click Test, By doing this, we will be able to check the connectivity with the SQL server. The message should say connection established. Then click Save.
Step 5: Start and stop the ServiceDeskPlus – MSP service once.
NOTE: A database called ServiceDesk would be created in the SQL server.
Step 6: Now open the restore process wizard using below command,
The data should now be restored under your MSSQL server instance. Follow the on screen instructions to restore the latest backup data performed in step 2.
Step 7: Start ManageEngine ServiceDeskPlus – MSP service once the restore process is complete.
How do I convert the database from MSSQL to PGSQL ?
Kindly plan to perform this process ONLY during Non Operational hours. You can do this process in the same server that you have SDP MSP installed. Step 1: Stop the application and Take a backup of the existing data in the application. Navigate to ...
Query to show Average response time for Category
PGSQL: SELECT accountdefinition.org_name "Account",cd.categoryname "Category", TO_CHAR(((avg(wo.respondedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Response Time" FROM workorder wo LEFT JOIN workorderstates wos ON ...
Query to show the time taken between created time and first technician assigned time _PGSQL
Go to Reports-New Query Report and execute this query. PGSQL: SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",LONGTODATE(wo.createdtime) "Created Time", LONGTODATE(wo.COMPLETEDTIME) "Completed Time", LONGTODATE(MIN(woh.OPERATIONTIME)) ...
Move database from one machine to another
Following is the procedure to migrate your ServiceDesk Plus – MSP database from one MSSQL to another. Step 1: Stop ManageEngine ServiceDesk Plus – MSP service. Step 2: Take a backup of the existing data and configuration under MSSQL database. From ...
Connect to default PGSQL database remotely
1. To be able to reach the server remotely you have to add the following line into the file: ManageEngine/ServiceDeskPlus-MSP/pgsql/data/postgresql.conf: listen_addresses = '*' 2. PostgreSQL, by default, refuses all connections it receives from ...