How to migrate data from SDP MSP to SDP ?

How to migrate data from SDP MSP to SDP ?

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

1) You can export request data from ServiceDesk Plus MSP (SDP MSP) 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 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 )






          • 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 ...
          • Export accounts from the SDP MSP application

            Way to export the accounts configured in the SDP MSP application. Login as an Admin and click on the "Reports"icon . Then, click on "New query report" and run the below query: select adef.org_name "Account ...
          • 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 ...
          • SCP, SDP and MSP Differences

            Though ManageEngine has multiple HelpDesk applications, they are developed and targeted for Different markets. Here are few cases to understand the difference between them. HelpDesk Applications in ManageEngine (ME) are as follows :  1. SupportCenter ...
          • Linux to Windows server migration

            For migrating the server from Linux to Windows refer the steps Please take a backup of the Linux installation and restore it on the Windows Server. If you are using MSSQL, install the same version of the application on the Windows and update the SQL ...