Database Schema of MSP

Database Schema of MSP

The database schema is accessible from within the ServiceDesk Plus MSP application.

Navigate to Reports -> New Query report -> Here you can click on the two icons available to view the Schema like shown below,




For more details on the important table details, please refer the link below,

      New to ADSelfService Plus?

        Resources

            • Related Articles

            • How to Connect to SDP MSP Database ?

              1. In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command                                     From SDP MSP version 10.6 , please use the below method.     ...
            • Remote read only access to database for Postgres customers

              Use case: Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to ...
            • How do I convert the database from PGSQL to MSSQL?

              1. Stop ManageEngine ServiceDeskPlus – MSP 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. ...
            • 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 ...
            • Error While connecting default Postgres Database

              If you are getting the below error while connecting the postgresDB , please follow the steps below : Error : psql: FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “servicedesk”,SSL off     Please open pg_hba.conf under ...