Solution Export

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

                      • 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 ...
                      • How to Export SSL certificate using MMC?

                        When an SSL certificate is already installed on a Windows server, you may want to reinstall it on ServiceDesk Plus server. This may be required when you have a Wildcard or a Multi-domain certificate, and the subdomains or different domains are hosted ...
                      • Old Solution Link update

                        After migrating 14200 build our old solution link format is not accessible, in this situation one of our customer referred more number of old solution links in some solutions description, in this scenario we need to update the old format link to new ...
                      • Problem details with root cause,workaround and solution

                        SELECT prob.PROBLEMID "Problem ID",        prob.TITLE "Title",        probdesc.FULL_DESCRIPTION "Description",        catadef.CATEGORYNAME "Category",        subcatadef.NAME "Subcategory",        itemdef.NAME "Item",        orgaaa.FIRST_NAME ...