Back to top
Home / Knox Manage / Monitor / Reports / Manage reports /

Add a new report

Last updated March 27th, 2025

Add a new report using report queries. Report queries are for filtering data or viewing statistics from the aggregate table in the Knox Manage database.

For performance and system stability purposes, the App Information installed in Device query returns a maximum of 100,000 results.

To add a new report using report queries, complete the following steps:

  1. Navigate to Advanced > Report.

  2. On the Report page, click Add.

  3. On the Add Report screen, enter the following report information:

    • Report Name — Enter the report name.
    • Report ID — Enter the ID for the new report.
    • Description — Enter a description for the report.
    • Chart — Select the chart type of the report.
    • Legend — Select the location of the chart legend.
    • Report Queries — Select the report query for the report. For more information, see Report queries list.

  4. Click Add next to Output Fields.

  5. On the Add Output Field screen, click the check boxes for the report fields you want to add and click OK.

  6. Configure the detailed settings of the selected fields depending on their data types.

  7. Click Save.

  8. On the Save Report screen, click OK.

The output fields must include at least one Category field and one Series field. There must be two or more fields.

  • The Category field shows the chart label, and you can use all data types to represent a chart label.
  • The Series field contains the data to be displayed on the chart, and you can only use the number data type to represent chart data.
  • If the chart type is Pie or Donut, the chart can only contain one Series field. For other chart types, the chart can contain multiple Series fields.

To delete selected fields, click the check box for the fields you want to delete and then click Delete.

To rearrange the selected report fields, click the check box for a field and click Up or Down.

Data type

Setting

String
  • Output Name — Change the field name if necessary.
  • Chart Setting — Select the field as the chart category if you want to display the chart.

Number
  • Output Name — Change the field name if necessary.
  • Output Format — Select the number display format.
  • Summary Type — Select the numeric value to display on the chart from among sum, average, maximum, and minimum.
  • Chart Setting — Select the field as the chart series or category if you want to display the chart.

Date
  • Output Name — Change the field name if necessary.
  • Output Format — Select the date display format.
  • Chart Setting — Select the field as the chart category if you want to display the chart.

Adding a report based on an existing report

To copy an existing report to create a new report, complete the following steps:

  1. Navigate to Advanced > Report.
  2. On the Report page, select the report you want to copy and click Copy.
  3. On the Copy Report page, enter the report name and ID.
  4. Modify the existing information if necessary.
  5. Click Save.
  6. On the Save Report screen, click OK.

This document was updated for the Knox cloud services 25.04 UAT.

On this tab

Create a new report

To create a new report using report queries, complete the following steps:

  1. Navigate to Advanced > Report.
  2. On the Report page, click Add.

Create a new report

  1. On the Add Report screen:
    • Report Name — Enter the report name.
    • Report ID — Enter the ID for the new report.
    • Description — Enter a brief description for the report.
    • Chart — Select a chart type to visualize the report.
    • Legend — Specify where the legend should appear relative to the chart (if you selected a chart type).
    • Report Queries — Select from a list of existing queries.

The App Information installed in Device query returns a maximum of 100,000 results.

  1. Click Add next to Output Fields. The Add Output Field dialog appears, showing available fields based on your report query selection. For a list of output fields in each report query, see Default reports and report queries.
  2. Configure output fields as needed. The Data Type value of the field dictates what properties you can modify.
    • String fields let you update values for Output Name (display name of the field) and Chart Setting (whether or not the field will appear as a chart category) values.
    • Number fields let you update values for Output Name (display name of the field), Output Format (the number display format), Summary Type (the numeric value to display on the chart – sum, average, maximum or minimum), and Chart Setting (whether or not the field will appear as a chart category).
    • Date fields let you update values for Output Name (display name of the field), Output Format (the date display format), and Chart Setting (whether or not the field will appear as a chart category).

You can reorder selected output fields using the up and down arrows.

  1. Based on your report query selection, relevant input fields are listed in the Input Value table. Proceed to enter input values under the Input Value column.
  2. Click View to preview your report before saving.
  3. Click Save, then in the Save Report dialog click OK.

Add a report based on an existing report

To copy an existing report to create a new report:

Copy a report

  1. Navigate to Advanced > Report.
  2. On the Report page, select the report you want to copy and click Copy.
  3. On the Copy Report page, enter a new Report Name and Report ID.
  4. Modify other fields and settings as needed.
  5. Click Save, then in the Save Report dialog click OK.

Is this page helpful?