Solution Export
SELECT solution.solutionid "Solutionid",
KB_Topics.TOPICNAME "Topic",
Solution.TITLE "Subject",
Solution.DESCRIPTION "Contents",
solutioninfo.noofhits "View(s)",
Creator.FIRST_NAME "Created By",
longtodate(SolutionInfo.CREATEDTIME) "Created Time",
Updater.FIRST_NAME "Last Modified By",
longtodate(SolutionInfo.LASTUPDATEDTIME) "Last Modified Time",
solutioninfo.ispublic "Is Public",
owner.FIRST_NAME "Solution Owner",
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 solutionownerdefinition solown ON solown.solutionid=solution.solutionid
LEFT JOIN aaauser owner on owner.user_id=solown.ownerid
LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID
ORDER BY 1
New to ADSelfService Plus?
Related Articles
Query to Export solutions (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 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 ...Export Category,subcategory, item
This report is used to export the tree view. This report helps to import category,subcategory and item in other applications. Modify and import in the applications. SELECT CategoryDefinition.CATEGORYNAME "Category Name", SubCategoryDefinition.NAME ...How to export software data in CSV format?
Steps to export Software data in CSV format 1. Login to ServiceDesk Plus/AssetExplorer. 2. Click on the Reports tab and then click on New Query Report button. 3. Copy and paste the following query and click Run Report. select swm.name "Scanned ...Query to display the solution details, including helpful/not helpful ratings and the number of comments added
QUERY: SELECT solution.solutionid "Solution Id", Solution.TITLE "Title",KB_Topics.TOPICNAME "Topic", Sol_StatusDefinition.STATUSNAME "Status",solutioninfo.ispublic "Visibility",solutioninfo.noofhits "View(s)", Creator.FIRST_NAME "Created By", ...SQL Query to export request details
Supported only for SQL DB(14201 build). Executed in SQL DB directly to export the requests. Below query to export requests for one account / site. SELECT "wo"."WORKORDERID" AS "Request ID", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS ...