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
New to ADSelfService Plus?
Related Articles
Query to show Category, Sub category and Item (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL & MSSQL: Excute the below query under Report > New Report > Query Report > Copy, Paste the below and Run the query. SELECT CategoryDefinition.CATEGORYNAME "Category Name", ...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 ...Unable to add request during Zia Category prediction when both category & sub-category is mandated
Issue: When the Zia category prediction is enabled and while raising the request using a template in which the category and subcategory are mandated while submitting the request, the category prediction pop-up comes up and on applying it the category ...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 ...Script to auto-populate the "Estimated Efforts" of a task based on the "Category" and "Sub-Category" of an incident request
REQUIREMENT: When an incident request is created, a task should be automatically added to the request. In the created task, the "Estimated Efforts" field should be automatically calculated based on the Category and Sub-Category of the incident ...