Configuration Management - view/export the tree view of category, subcategory, and item / details of scheduled reports along with their owner
This report helps to export the tree view of category, subcategory, and item.
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
This report returns the details of scheduled reports along with their owner (technician) name.
SELECT CustomReport_Details.REPORT_NAME "Report Name",
AaaUser.FIRST_NAME "Owner" FROM ReportScheduleTask
LEFT JOIN CustomReport_Details ON ReportScheduleTask.REPORTID=CustomReport_Details.REPORTID
LEFT JOIN SDUser ON ReportScheduleTask.OWNERID=SDUser.USERID
LEFT JOIN AaaUser ON SDUser.USERID=AaaUser.USER_ID
Click this link to navigate to the next report.