Export solutions

Export solutions

Run this query under Reports->New Query Report and export it to the desired format

SELECT solution.solutionid "Solutionid", KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",solutioninfo.noofhits   
"Views",Creator.FIRST_NAME "Created By",longtodate(SolutionInfo.CREATEDTIME) "Created Time",Updater.FIRST_NAME "Last Modified By",longtodate
(SolutionInfo.LASTUPDATEDTIME) "Last Modified Time",Sol_StatusDefinition.STATUSNAME "Status" FROM Solution INNER JOIN SolutionInfo ON
Solution.SOLUTIONID=SolutionInfo.SOLUTIONID
LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID
LEFT JOIN AaaUser Updater ON SolutionInfo.LASTUPDATEDBY=Updater.USER_ID
LEFT JOIN AaaUser Creator ON SolutionInfo.CREATEDBY=Creator.USER_ID
LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID
LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID
LEFT JOIN solutionugmapping sum ON solutioninfo.solutionid=sum.solutionid
LEFT JOIN Usergroups ug ON sum.usergroupid=ug.id
LEFT JOIN Usergroupsaccmapping ugam ON ug.id=ugam.usergroupid
LEFT JOIN AccountDefinition ad ON ugam.accountid=ad.org_id

      • Related Articles

      • Query to get solutions account based

        PGSQL & MSSQL: SELECT solution.solutionid "Solutionid", KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",solutioninfo.noofhits "Views",Creator.FIRST_NAME "Created By",longtodate(SolutionInfo.CREATEDTIME) "Created ...
      • How Public and Private Solutions work

        ServiceDesk Plus MSP allows you to publish knowledge base solutions as either public (available for all requesters and technicians) or private (accessible only by technicians). To make a solution public, while adding/editing the solution select the ...
      • 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 ...
      • 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 ...
      • 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 ...