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
      • 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 ...
      • 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 ...
      • Query to export All Requesters from All Accounts

        SELECT AaaUser.USER_ID,AaaUser.FIRST_NAME "FullName",AaaLogin.NAME "LoginName",AaaLogin.DOMAINNAME "Domain",AaaContactInfo.EMAILID "Email",DepartmentDefinition.DEPTNAME "Department",SDOrganization.NAME ...
      • Configuring Login Web URL and Login URI for an account

        What is a login URL and login URI under accounts? Login Web URL: A login URL is the locator of a resource (Which can be used to locate the address of a resource in the internet). Login URI: It is the identifier, which is used to identify any resource ...