Question

How to group license consumption report data by date using API?

Answer

In the latest releases of FlexiCapture 12, the groupByType parameter was substituted with timeGrouping.

The timeGrouping must be of type integer and can have any of the following values:

• 1=hour
• 2=day
• 3=month

The default value is 1.

To obtain the aggregated report on the latest builds, specify the timeGrouping as "Name" for the aggregated time period parameter and set the "Value" based on the required duration. The following screenshot illustrates the sample parameters that need to be set when using the API to obtain a report aggregated by month:

[
    { "Name": "dateFrom", "Value": "$dateFrom"},
    { "Name": "dateTo", "Value": "$dateTo"},
    { "Name": "tenantIds", "Value": "0},
    { "Name": "timeGrouping", "Value": "3"}
]

Consequently, the report that is generated will be consolidated on a monthly basis:

Additional information

Site Performance reports