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,

          • 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 ...
          • 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 ...
          • How do I host ServiceDesk Plus MSP on the internet?

            In order to make ServiceDeskPlus – MSP available for users in Internet, let us assume the following scenarios.   Scenario 1: ServiceDesk Plus – MSP is installed in LAN and should be available in LAN and WAN: Assume ServiceDesk Plus – MSP is installed ...