How to migrate data from SDP to SDP MSP.

How to migrate data from SDP to SDP MSP.

Below are the only details which can be exported from SDP and imported to SDP MSP application.

1) You can export request data from ServiceDesk Plus (SDP) using XLS format.

Requests -> Goto Admin -> Reports -> New custom report -> Tabular reports -> All requests -> Proceed to Report wizard
Select the Available columns and choose needed data and dates from Filter options and run the report.
Now you can export the data into a XLS format.


Please note conversations , Notes , attachments cannot be exported.
SLA , Business rules, admin configurations and other automations , scripts needs to be recreated.

2) Solutions can be exported using the below article.

3) Assets needs to be scanned again from SDP MSP separately.
As its a new scan, in case if any of your existing tickets is associated with assets , then the mapping will not be available.

4) Assets - Contracts can be imported using CSV from contracts tab.

5) Requesters can be exported using the below article

or if you have Active directory , use the same and import users. Refer here for more details.

6) Contracts can be exported using Custom report and import it from SDP user interface.
Basic details can be imported.

Exporting Category,Subcategory,Item 

Execute the below query from Reports -> New Query :

select cd.CATEGORYNAME "Category", scd.NAME "Subcategory", icd.NAME "Item" from (  (select * from categorydefinition where categorydefinition.isdeleted=false) cd left join (select * from subcategorydefinition where subcategorydefinition.isdeleted=false) scd on cd.categoryid=scd.categoryid left join (select * from itemdefinition where itemdefinition.isdeleted=false) icd on icd.subcategoryid=scd.subcategoryid )






                  New to ADSelfService Plus?

                    • Related Articles

                    • How to import requests data into ServiceDesk Plus MSP ?

                      You can import your existing helpdesk Requests (tickets) into ServiceDesk Plus MSP (SDP MSP) using XLS format. Requests can be migrated to SDP MSP with basic details. Assets data can be scanned again through SDP MSP windows domain scan or using ...
                    • Syntax for SDP MSP migration to Linux

                      While migrating to different database you can use backupdataold.bat. Here backup will be in .data format and this can be restored in across DB platform. Note: Backup from taken from a particular build can be restored only on the same build. Example: ...
                    • Steps to migrate ServiceDeskPlus – MSP from One Linux server to another Linux server.

                      Following are the steps to move ServiceDeskPlus – MSP from One Linux server to another Linux server. Steps to take data backup in Linux machine is given below, 1.Go to the installation folder. [The default installation folder is ...
                    • How DC agents or RAE push data to SDP MSP ?

                      Here is the scenario and the design : 1. DC MSP directly sends to SDP MSP. a. DC MSP gets workstation scanned details from its DC agents and send the data to SDP MSP. This is normal integration model. To make it work , 2 rules is to be satisfied : ...
                    • Migration failure for Postgres Database with a blank space in it

                      Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...