This document is available on ManageEngine ServiceDesk Plus :

• Export Service Catalog
• Exporting the Category/Subcategory/Item structure

It is designed for users who want to carry out their transactions.

1. Service Catalog Export

You can list the active catalog templates and their associated service categories with the following SQL query:

 SELECT
 serd.Name as "Service Category" ,
 reqtl.templatename as "Template name" ,
 reqtl.status as "Status"
 FROM RequestTemplate_list reqtl
 LEFT JOIN ServiceDefinition serd
 ON reqtl.PARENT_SERVICE = serd.SERVICEID
 WHERE
 reqtl.isdeleted = '0'
 AND reqtl.is_catalog_template = '1'
 AND reqtl.status = 'Active'
 ORDER BY 1

✅ What does this query provide?

• Lists active service catalogs.
• Shows template names
• It specifies which service category it belongs to.

2. Category / Subcategory / Item Export

You can use the following query to export the category hierarchy:

 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

✅ What does this query provide?

• Extracts the entire category structure (Category → Subcategory → Item).
• It provides a complete hierarchical view.
• It can be used for reporting and analysis.

Use Cases

• Service catalog cleaning and optimization.
• ITSM process analysis
• Category standardization
• Data extraction before new environment setup.

Support

If you encounter any problems, you can contact our support team.

📧 support@wotech.com.tr