Administration Guide › Queries and Reports › Example: Create a Report from Existing Queries

Previous Topic: Design Report Layout

Next Topic: Example: Set Up Federation and Federated Reports

Example: Create a Report from Existing Queries

You can create custom reports composed of predefined queries and tailor it to your specifications.

To create a report from existing queries

  1. Identify the queries to include in the custom report.
    1. Click the Queries and Reports tab and the Queries subtab, if not displayed.
    2. Enter a key word or key phrase in the Search field to display the queries with the content from which you want to make a selection. For example, enter critical hosts trend.
    3. Note the names of the queries you want to include in the custom report. For example, you can define a report of the trends associated with business critical hosts from those listed in the following illustration, for example, the ones for System Access, Resource Access and Account Creations.

    Three queries with Business Critical Hosts trend are shown.

  2. For the first query to include in the report, create a copy and add a custom tag.
    1. Select a query and select Copy from the Options drop-down list.
    2. Rename the query and enter a custom tag to add. For example, rename Copy of System Access by Business Critical Hosts Trend to Custom System Access by Business Critical Hosts Trend.
    3. Add a custom tag. For example, enter Critical_Assets_Trend and click Add Tag.

      Enter Critical_Hosts_Trend for the custom tag.

    4. Click the move button to move the preselected tag to the Available Tags area. For example, move System Access. The only tag selected is the one you added.

    The tag appears as selected.

    1. Click Save and Close.
  3. For the other queries to include in the report, create a copy and select the custom tag you created.
    1. Select a query and select Copy from the Options drop-down list.
    2. Rename the query and select the new custom tag. For example, rename Copy of Resource Access by Business Critical Hosts Trend to Custom Resource Access by Business Critical Hosts Trend, move Critical_Assets_Trend to the Selected Tags list and remove the preselected tag.
    3. Click Save and Close.

    The copied queries display under User:

    Custom queries are listed under the User folder.

  4. If the queries are associated with keyed list, define the values for that keyed list.
  5. Initiate the report creation process as follows:
    1. Click the Queries and Reports tab and then the Reports subtab.
    2. Select New from the Options drop-down list under the Report List.

      The Report Design wizard appears.

      Add the custom tag, Critical_Assets_Trend.

  6. Design the report layout.

    Select grid rows 3 and columns 1.

  7. Click Save and Close.
  8. Schedule the report based on the custom tag you created.
  9. View the report.

Note: It is good practice to examine any new report to verify that it provides the desired information in the best possible way.

More information:

Example: Schedule Reports with a Common Tag

View a Generated Report