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.
Topic Participants
Dinesh Bhaskaran
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?