This documentation supports the 22.1 version of BMC Helix ITSM.To view an earlier version, select the version from the Product version menu.

Generating reports with BIRT

BMC Helix ITSM provides a variety of predefined reports to help you with quick and easy access to information about your system. Use the Report console to generate these reports. You can use qualifications to narrow down the information presented in the predefined reports. 

Related topics

Reporting on Remedy application activity

Creating and modifying web reports by using BIRT editor


Disclaimer

Although the concepts and procedures presented in this video are correct, the user interfaces shown are not current.


icon-play.pnghttps://youtu.be/n_5tbifs-YA


From the Applications menu, select Quick Links > AR System Report Console to view customized reports. In the web interface, a number of reports are available in the Web (BIRT) format.

Warning

The standard reports included with the BMC Helix ITSM application are designed to be used without modification. BMC Customer Support can only provide limited assistance if you modify predefined reports and have a reporting problem. In addition, there is no guarantee that BMC Customer Support can solve problems that result from these modifications. 

If your database does not support the Not Equal To argument in the "\!=" format, the content of your reports can be affected. Reports that have additional qualifications that filter out Group By fields (for example, 'Department' \!= "Engineering"), also filter out the specified conditions and records that have Group By fields set to Unspecified or Null. Check with your system administrator to determine whether your database supports this form of the Not Equal To argument.


To generate a report without qualifications

  1. On the Application Console, select Functions > Reports.
  2. On the Report Console, select one of the following options under Show:
    • All Reports, which displays all available reports
    • Created by me, which displays reports that you created
  3. In Category, select applicationName > reportCategory > reportName.
    A list of available reports is displayed. Reports are organized by category, some of which contain subcategories. The reports that you see vary according to which applications are installed.
  4. Select the report that you want to run and click Run.
    If you select a report that requires additional parameters, you are prompted to enter the required parameters. For example, if the selected report requires a date range, the date range field is displayed.
  5. Enter the required parameters if needed, and click OK.


To generate a report with qualifications

You can manage the scope of a report by adding qualifications to the criteria that the report engine uses to generate the report content. You can set the report to search only specified fields for particular values.

  1. In the Application Console, select Functions > Reports.
  2. In the Report Console, select one of the following options under Show:
    • All Reports, which displays all available reports
    • Created by me, which displays reports that you created
  3. In Category, select applicationName > reportCategory > reportName.
    A list of available reports is displayed. Reports are organized by category, some of which contain subcategories. The reports that you see vary according to which applications are installed.
  4. Select the Show Additional Filter option.
    Along with a list of available fields, the simple query builder and the advanced query builder sections are displayed. You use the simple query builder to quickly construct a simple query. Alternatively, advanced users can use the advanced query builder to build the query by using AR System query syntax. For additional information about the AR System Report Console, see Reporting on Remedy application activity.
  5. From the Available Fields list, select a field name and click Add next to the simple query builder.

  6. Click the down arrow next to the field name listed in the qualification box, and select the appropriate operator. Enter or select a value for the field in the column.

    Example

     If you want to enter 001 as the Cost Center qualification, select the Cost Center field, click the down arrow next to the field and select =, and then enter 001 in the column.

  7. Repeat steps 5 and 6 for each field that you want to include in the report.
  8. After you complete defining the qualifications, click Run.


To generate a report by using advanced qualifications

You can build advanced qualifications by using field names, keywords, and operators.

  1. In the Application Console, select Functions > Reports.
  2. In the Report Console, click Show and select either All Reports or Created by me.
  3. In Category, select applicationName > reportCategory > reportName.
    Reports are organized by category, some of which contain subcategories. 
  4. Select the Show Additional Filter option.
    Along with a list of available fields, the simple query builder and the advanced query builder sections are displayed. You use the simple query builder to quickly construct a simple query. Alternatively, you can use the advanced query builder to build the query by using AR System     query syntax. For additional information about the AR System Report Console, see Reporting on Remedy application activity.
  5. Select Available Fields, click Add next to the advanced query builder and use the AR System query syntax to build your qualification.
    Construct your qualification by using the various operators available in the qualification builder.
    To remove a qualification, select the qualification and click the Delete icon.
  6. After you finish defining advanced qualifications, click Run to view the updated report.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*