Use service catalog variables in a report
-
- UpdatedJan 30, 2025
- 3 minutes to read
- Yokohama
- Reporting
In reports on service catalog data, stack and group by variables, use variables as columns in list reports, and as columns and rows in multilevel pivot tables.
Before you begin
Role required: itil, report_user, report_global for global reports, or report_group for group reports.
Users with the report_admin role can report on service catalog variables. Add the report_admin role to the ACLs for the Options [sc_item_option], Variable Ownership [sc_item_option_mtom], and Variables [item_option_new] tables.
- The report you want to use the variable for must be based on the Requested Items table [sc_req_item] or the Catalog Task table [sc_task]. Using other types of variables causes an error when generating the report.
- The Oracle Database CLOB field does not have the functionality to retrieve the variables data in reports. For a column string field of less than 4000 bytes, you can change the column type to varchar2. To compare the CLOB columns of a smaller size, use the to_char() function. For a larger size CLOB, you must get a substring for comparison using the dbms_lob.substr functions.
About this task

Procedure