Query options

The following command line options are available for query reports from the reporttool utility.

-aggregator

Comma-separated list of aggregator functions to be applied to the accessor values in each time bucket. For example: -aggregator max,average. This option is required if -type query is used.

-list_aggregators

Use this option to obtain a list of the available aggregator functions. The basic aggregators are as follows:

  • max—maximum value of an accessor in each time bucket

  • min—minimum value of an accessor in each time bucket

  • sum—sum of all accessor values in each time bucket

  • average—average value of accessor in each time bucket

  • len—number of items in each time bucket

  • peak—maximum number of licenses in use; must operate on the session accessor

Not all aggregators will work with all assessors. For example, you can successfully calculate the maximum duration of sessions, but attempting to find the average value of usernames is meaningless.

-duration

The size of each time bucket for query reports, in minutes, hours, days, weeks, or months. If this option is omitted, the default is 24 hours. Examples: -duration 1hour, -duration 2days