PostgreSQL
How to connect to DB - 8121
Connect to PostgreSQL Server in Windows: Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt. -> C:\> cd ManageEngine\SupportCenter\pgsql\bin Enter the command: psql.exe -U postgres -p 65432 -h 127.0.0.1 supportcenter -> C:\> cd ...
How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine Supportcenter Plus service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup. ...
How to Change default password on PGSQL database
Please do follow the below steps which would assist you in changing the default Postgres password. 1. Stop the application services. 2. Please take a trimmed backup <OR> take a Snapshot of the Server 3. Open Command Prompt with Admin Privileges ...
How to connect to Database in Version 11.0? PGSQL
1.Open a cmd with admin privileges 2.navigate to ManageEngine\SupportCenterPlus\pgsql\bin and enter the below command: psql.exe -U scpadmin -p 65432 -h 127.0.0.1 supportcenter For example: SupportCenterPlus\pgsql\bin>psql.exe -U scpadmin -p 65432 -h ...
How to Connect to SCP Database ? (from 11000 builds)
In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command 1. If the database is PGSQL (Default database) psql -h localhost -U scpadmin -p 65432 -d ...
Support Center Schema - 8 series
To populate the WorkOrder/Request information, the tables that need tobe populated are : WorkOrder WorkOrderStates WorkOrder_Threaded WorkOrderToDescription WorkOrder_Fields (If there are any WorkOrder Addl Fields) To map Account and SubAccount to a ...
How to restore the database of supportcenter plus in a new instance? (Applicable from 11.0 version)
1. Find out the build number of the live server. You can know it from About Product (inside ? icon)in the top right of the user interface. 2. Download the same version from the below link * http://archives.manageengine.com/support-center/ ...