Export accounts from the SDP MSP application

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 Name",ci.description,adef.Login_uri,adef.Login_weburi,adef.Support_email,adef.Sendername,imp.name "Business Impact",aaapost.door_no "Door Number",aaapost.street "Street",aaapost.city "City",aaapost.state "State",aaapost.country "Country",aaapost.postalcode "Postal code",aaapost.landmark "Landmark",aaacont.emailid "Email",aaacont.landline,aaacont.mobile,aaacont.fax,aaacont.web_url from accountdefinition adef left join ci on ci.ciid=adef.ciid left join baseelement be on be.ciid=ci.ciid left join impactdefinition imp on imp.impactid=be.impactid left join sdorganization sdo on sdo.org_id=adef.org_id left join sdorgpostaladdr sdopost on sdopost.org_id=sdo.org_id left join aaapostaladdress aaapost on aaapost.postaladdr_id=sdopost.postaladdr_id left join sdorgcontactinfo sdocont on sdocont.org_id=sdo.org_id left join aaacontactinfo aaacont on aaacont.contactinfo_id=sdocont.contactinfo_id


 After build 10600:


select adef.org_name "Account Name",ci.description,adef.Login_uri,adef.Login_weburi,adef.Support_email,adef.Sendername,imp.name "Business Impact",aaapost.door_no "Door Number",aaapost.street "Street",aaapost.city "City",aaapost.state "State",aaapost.country "Country",aaapost.postalcode "Postal code",aaapost.landmark "Landmark",aaacont.emailid "Email",aaacont.landline,aaacont.mobile,aaacont.fax,aaacont.web_url from accountdefinition adef 
left join portalaccounts pa on adef.org_id = pa.accountid
left join ci on pa.ciid = ci.ciid 
left join baseelement be on be.ciid=ci.ciid 
left join impactdefinition imp on imp.impactid=be.impactid 
left join sdorganization sdo on sdo.org_id=adef.org_id 
left join sdorgpostaladdr sdopost on sdopost.org_id=sdo.org_id 
left join aaapostaladdress aaapost on aaapost.postaladdr_id=sdopost.postaladdr_id 
left join sdorgcontactinfo sdocont on sdocont.org_id=sdo.org_id 
left join aaacontactinfo aaacont on aaacont.contactinfo_id=sdocont.contactinfo_id
        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • 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 ...
            • 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 ...
            • Best practices for managing old accounts and sites.

              When dealing with old accounts/sites in Service Desk Plus MSP (SDP MSP), it's essential to follow best practices to maintain a clean and organized database. Managing old accounts/sites efficiently can help improve performance, reduce clutter, and ...
            • 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 : ...
            • How to add hyperlinks in Advisory for MSP Account ?

              Under Account Tab>Editing the Account will have an advisory field in which we can configure hyperlinks. However, under Admin>Oranization Details the feature is not available.  Feature ID: 13986 Ticket for reference: 5700120  Workaround 1. Click on ...