Creating ad hoc reports

Article:HOWTO17717  |  Created: 2009-01-22  |  Updated: 2010-12-09  |  Article URL
Article Type
How To



Creating ad hoc reports

Table: Process to create an ad hoc report summarizes the steps typically used to build an ad hoc report.

Table: Process to create an ad hoc report




Select a package.

Identifies the area of study and provides the metrics, views, and filters for that study.

See Opening Query Studio and selecting a package.

Select one or more metrics.

Places data columns in the report.

See Working with columns in ad hoc reports.

Optionally, add a view.

Focuses the report on specific object attributes, business views, or historical trends. For example, in a switch analysis report, select one or more of the following views:

  • Switch-specific attributes (for example, switch key, discovery state, display name, or virtual support)

  • Business views (for example, business units, applications, or geographic locations)

  • Historical views (year, quarter, month, or day)

See Selecting views in ad hoc reports.

Optionally, select filters.

Typically, you should apply the Most Recent Metrics and Inventory filters to obtain accurate results.

Limits the results in the report. For example, in a switch analysis report, show only physical switches or switches from a specific vendor.

Select two unique sample filters stored in most namespaces: Most Recent Host Consumption Metric and Most Recent Host Consumption Inventory.

See Filtering ad hoc reports.

See Using the Most Recent Metrics or the Most Recent Inventory filters.

Optionally, format the data.

Changes the display of the data. For example, change the number of decimal places or currency.

See Formatting data in ad hoc reports.

Optionally, sort the data in a column.

Arranges data in ascending or descending order.

See Sorting data in ad hoc reports.

See About ad hoc reports

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices