Usage (Organization Structure–Based)

This query subject describes feature license utilization on the top level of organization structures.

Some of the query subject properties will vary, depending on which model you are working with.

Usage Properties

Property

Description

Usage Events

Number of times a feature/product has been started within the time interval (hour/day/month) referenced by TIME_ID.

Ultimate Denials

Total number of “true” denials during 1 month beginning at the time point referenced by TIME_ID.

A true denial is an ultimate denial or folded denial, based on the configured false denials interval.

Peak Licenses

The peak (maximum) number of licenses used concurrently for a feature/product within the time interval (hour/day/month) referenced by TIME_ID.

Count at Token Peak

Actual count for a given capability at the time where the tokenized feature peak occurred. It is not necessarily that tokenized feature (sum of all capabilities) peak would coincide in time with any individual capability peak.

Total Used Time (hours)

Calculated cumulative time a license has been used during this month in hours. For example, 2 licenses in use during 1 hour would result in 2 hours of total use time.

Total Used Time (seconds)

Calculated cumulative time a license has been used during this month in seconds. For example, 2 licenses in use during 1 hour would result in 2 hours of total use time.

Borrowed Usage Events

The number of licenses that have been borrowed during the interval (hour/day/month) referenced by TIME_ID.

Peak Borrowed Licenses

Peak number of borrowed licenses in use during one month, beginning at the time referenced by TIME_ID.

Elapsed Time at Peak (hours)

The amount of time that was spent with the peak number of licenses checked out. For example, if there was one license checked out for an eight-hour day, and then a second license was checked out just for three hours during that day, the peak would be 2, and the Elapsed Time at Peak would be 3 hours.

Applies to Product-Org OLAP only.

Elapsed Time at Peak (seconds)

The amount of time that was spent with the peak number of licenses checked out. For example, if there was one license checked out for the entire hour, and then a second license was checked out just for three minutes during that hour, the peak would be 2, and the Elapsed Time at Peak would be 180 seconds (3 minutes).

Applies to Product-Org OLAP only.

Duration at Capacity (hours)

The amount of time spent when the number of checked-out licenses was equal to (or greater) than the number of licenses available. For the example provided in the Elapsed Time at Peak (hours) description, if there were three licenses available, the Duration at Capacity would be zero, but if it there were only two licenses available, the Duration at Capacity would be the same as the Elapsed Time at Peak: 3 hours.

Applies to Product-Org OLAP only.

Duration at Capacity (seconds)

The amount of time spent when the number of checked-out licenses was equal to (or greater) than the number of licenses available. For the example provided in the Elapsed Time at Peak (seconds) description, if there were three licenses available, the Duration at Capacity would be zero, but if it there were only two licenses available, the Duration at Capacity would be the same as the Elapsed Time at Peak: 180 seconds.

Applies to Product-Org OLAP only.

Org Node ID

Reference to Organization Unit.

Time ID

Reference to Time.

Feature ID

Reference to Feature.

Applies to Feature-Org OLAP only.

Product ID

Reference to Product.

Applies to Product-Org OLAP only.

Tier ID

Reference to Tier.

Applies to Tier-Feature-Org OLAP only.

Capability ID

Reference to Capability.

Applies to Cadence-Token-Feature-Org OLAP only.

License Server DB Key (Hybrid Org Filter)

Internal surrogate key. Set to NULL to show usage for all license servers.

Applies to hybrid (multi-dimensional) organizational structures. For information about hybrid organizational structures, see the online help library.

License Server Name (Hybrid Org Filter)

Name of the license server for which to aggregate usage data.

Applies to hybrid (multi-dimensional) organizational structures. For information about hybrid organizational structures, see the online help library.

License Server Display Name (Hybrid Org Filter)

Display name of the license server for which to aggregate usage data.

Applies to hybrid (multi-dimensional) organizational structures. For information about hybrid organizational structures, see the online help library.