Reporting

You can create reports about system activity, build lives, job execution, projects and their immediate dependencies, and several others. You can customize reports and save the results.

  1. On the left navigational panel, click Reporting.
    The Reporting page provides tools to create and run reports.
  2. Click New Report.
  3. Type a name for the report in the Name field.
  4. Select a table to add to the report from the Tables list, then click Select. Select.
    The table is added to the report and several options to customize the report are available.
  5. Optional: Modify or add report columns by completing the following steps.
    1. Click Columns.
      The columns for the selected table are displayed.
    2. To rearrange column order, click a column and drag into the new location.
    3. To rename a column, type the name in the Alias field that is associated with the column.
    4. To remove a column from the report, use the delete icon associated with the column.
    5. Optional: To add a function to a column, select the function from the Function list that is associated with the column.
      The filter types are Boolean operators.
    6. Optional: To add a compound column to the report, click Add Compound Column then type a name for the column in the Included Columns field.
      All columns are included in the compound column. To remove a column, click the delete icon that is associated with the column.
    7. Click Apply.
  6. Optional: Filter the report by completing the following steps.
    1. Click Filter.
      The columns for the selected table are available to be filtered.
    2. Type a name for the report in the Name field.
    3. Select a column to filter from the Column list.
      The available columns depend on the selected table.
    4. Optional: Select a type Filter Type list.
      The filter types are Boolean operators.
    5. Optional: Select a value from the Value options, then type or select a specific value.
      Selectable values depend on the table you choose.
    6. Click Apply.
    The filter is added to the report. To delete a filter, click the remove icon . To modify a filter, click the edit icon .
  7. Optional: Reorder report columns by completing the following steps.
    1. Click Order.
      The columns for the selected table are available to be reordered.
    2. Click Add Ordering.
    3. Select the order key column from the Column list.
      The report is ordered by the selected column
    4. Optional: Select an order direction from the Order list.
      Columns can be in Ascending or Descending order.
    5. Optional: Select a secondary order key from the Column list.
    6. Click Apply.
  8. Optional: Reorder report columns by completing the following steps.
    1. Click Order.
      The columns for the selected table are available to be reordered.
    2. Click Add Ordering.
    3. Select the order key column from the Column list.
      The report is ordered by the selected column
    4. Optional: Select an order direction from the Order list.
      Columns can be in Ascending or Descending order.
    5. Optional: Select a secondary order key from the Column list.
    6. Click Apply.
  9. Optional: If you want to represent the report's output in a chart, complete the following steps.
    1. Click Output.
      Several chart types are available.
    2. Define the chart's x-axis:
      1. Type the name for the x-axis in the Name field.
      2. Select a column key from the Value list.
      3. Select a column from the Category list. The default option is None.
    3. Define the chart's y-axis:
      1. Type the name for the y-axis in the Name field.
      2. Select a column key from the Value list.
    4. Click Apply.
  10. Optional: Modify the script that generates the report by completing the following steps.
    1. Click Text.
      The JSON script that is generated by your selections is displayed. This script actually runs the report. You can directly modify the script.
    2. Edit the JSON script.
  11. Click Run.
    The report is displayed in the Report window. Report data is displayed in columns and rows unless you selected a chart-type output option.
To save the generated report as a comma-separated values (CSV) file, use the download as CSV icon .