Export Category,subcategory, item

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 "Sub Category Name",
       ItemDefinition.NAME"Item Name" FROM CategoryDefinition
LEFT JOIN SubCategoryDefinition ON SubCategoryDefinition.CATEGORYID=CategoryDefinition.CATEGORYID
LEFT JOIN ItemDefinition ON ItemDefinition.SUBCATEGORYID = SubCategoryDefinition.SUBCATEGORYID
ORDER BY 1,2,3




          • Related Articles

          • 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 ...
          • Solution Export

            SELECT solution.solutionid "Solutionid", max(KB_Topics.TOPICNAME) " Topic", max(Solution.TITLE) "Subject ",max(Solution.DESCRIPTION) "Description ", max(Creator.FIRST_NAME) "Created By", longtodate(max(SolutionInfo.CREATEDTIME)) "Created Time", ...
          • Preventive maintenance

            This Report is used to export the list of Preventive maintenance configured in the application with the next schedule time. SELECT swo.WORKORDERID "Scheduled WOID", ti.SCHEDULE_TIME "Next Schedule Time", aau.FIRST_NAME "Requester", sdo.NAME "Site", ...
          • How to proactively handle problem management in your IT environment.

            This post describes the use of a python script to analyze the nature of the requests and alarms the technicians about frequently raised requests' category, and sub-category. This may help the technicians to proactively start their investigation in ...