License Statistics API allows you to generate data from the Usage Per User report. This report shows statistics for license usage by users, during any period that usage was tracked.
Obtaining information about usage
...
per user for feature
If you want to retrieve information about usage history per user for a single feature, we recommend that you use the following URL request template.
...
Field | Type | Description |
---|
success | boolean | Indicates that your API request was successfully processed. |
msg | string | Error message returned on failure. |
fid | integer | Feature ID. |
lsid | integer | License server ID. |
uid | integer | User ID. |
uil | boolean | Information if user is managed by LDAP. |
fud | string | Indicates period of time for which usage information is generated, i.e. date and time for hourly usage and dates for the remaining granularity options.
|
un | string | Username. |
hn | string | Hostname. |
lsn | string | License server name.
|
fns | string | Feature name.
|
fv | string | Feature version. |
ftype | string | Feature type. |
musage | float | Maximum usage of licenses in relation to total license number, expressed in percentages. |
hu | float | Hours used.
|
mu | integer | Maximum licenses used count for given date. |
hb | float | Hours borrowed. |
mb | integer | Maximum licenses borrowed count for given date. |
code | integer | Error code if success equals false, null otherwise. |
totalCount | integer | Total number of rows returned. |
Obtaining information about usage
...
per user for license server
If you want to obtain retrieve information about usage history comparison for features, per user for license servers we recommend that you use the following URL request template.
Code Block |
---|
language | js |
---|
firstline | 1 |
---|
linenumbers | true |
---|
|
GET GET /api/v1/report/license-server/${licenseServerId}/usage-per-history/comparison/json?fi=user/${featureIdsreturnType}&?sd=${startDate}&ed=${endDate}&granularitygrat=${granularity}$(additional parameters, as needed) |
where
- $ indicates a variable value that you can replace with a proper value, according to your needs
- possible parameters are as followsPossible parameters are as follows:
Parameter | Required | Type | Description |
---|
featureIdsarrayArrays of feature IDs in the following format: id1, id2, id3... for example fi=1,2,3,5ID of single license server or "all" if information about all license servers is requested.
|
${returnType} | Yes | string | Specifies the format in which license usage data will be returned. The format can be one of the following: json, csv, xls, xlsx or pdf. |
sd | Yes | string | Specifies the start date for which the report will be generated in YYYY-MM-DD format; for example, 2017-01-20. |
ed | Yes | string | Specifies the end date for which the report will be generated in YYYY-MM-DD format; for example, 2017-01-27. |
granularity Specifies granularity of the returned data, which can be one of the following: - Quarter - 2
- Month - 3
- Week - 4
- Day - 5
- Hour - 6
|
Currently the report is only returned only in JSON syntax. There are plans to introduce CSV, XLS and PDF formats in the future.
If your request is successful, you should see a response similar to the following:
Code Block |
---|
|
{
"success": ${success},
"msg": ${message},
"data": [
{
"fid": ${featureId_1},
"lud": ${date},
"lumin": ${minUsed},
"lua": ${averageUsed},
"lumax": ${maxUsed},
"lbmin": ${minBorrowed},
"lbmax": ${maxBorrowed},
"ldtc": ${denials},
"hu": ${hoursUsed},
"ft": ${total}
},
{
"fid": ${featureId_2},
"lud": ${date},
"lumin": ${minUsed},
"lua": ${averageUsed},
"lumax": ${maxUsed},
"lbmin": ${minBorrowed},
"lbmax": ${maxBorrowed},
"ldtc": ${denials},
"hu": ${hoursUsed},
"ft": ${total}
}
],
"code": ${code},
"totalCount": ${count}
} |
where the fields have the same values as the ones explained in Obtaining information about usage history for feature, above.
Obtaining information about usage history for license server
If you want to obtain information about usage history for all visible features for a given server, we recommend that you use the following URL request template.
Code Block |
---|
language | js |
---|
firstline | 1 |
---|
linenumbers | true |
---|
|
GET /api/v1/report/usage-history/license-server/${lsid}/${returnType}?sd=${startDate}&ed={endDate}&granularity=${granularity}$(additional parameters, as needed) |
Possible parameters are as follows:
Parameter | Required | Type | Description |
---|
${lsid} | Yes | integer | License Server ID. |
${returnType} | Yes | string | Specifies the format in which license usage data will be returned. The format can be one of the following: json, csv, xls, xlsx or pdf. |
sd | Yes | string | Specifies the start date for which the report will be generated in YYYY-MM-DD format; for example, 2017-01-20. |
ed | Yes | string | Specifies the end date for which the report will be generated in YYYY-MM-DD format; for example, 2017-01-27. |
granularity | Yes | integer | Specifies granularity of the returned data, which can be one of the following: - Quarter - 2
- Month - 3
- Week - 4
- Day - 5
- Hour - 6
|
rn | No | string | |
agrt | No | integer | Specifies aggregation type of the returned data, which can be one of the following: - Username - 1
- Hostname - 2
- Username and hostname - 3
- Usergroup - 4
- Hostgroup - 5
By default data is aggregated by username and hostname |
rn | No | string |
Specifies the name of the report that will be displayed once the report has been exported to PDF or XLS. For CSV and JSON formats this parameter will be ignored. If you don't pass this parameter, it will be generated automatically for PDF and XLS types. If provided, it cannot be left empty.
|
filter | No | json/string | Applies filtering license usage data on all fields. To filter by string column, use the following format: Code Block |
---|
| [
{
"type": "string", |
|
field": "${lud | fns | fv | ftype}field": "lud",
"value": "${value}"
}
] |
To filter by numeric column, use the following format: Code Block |
---|
| [
{
"type": "numeric",
"comparison": "${gt | lt | eq}",
"field": "${ |
|
luminfud | un | hn | lsn | fns | |
|
lualumaxlbminlbmaxldtchuftmb}",
"value": "${value}"
}
] |
|
fieldsVisibility | No | json/string | Specifies field visibility settings, |
for exampleludluminlua0lumaxlbminlbmaxldtchu0ft0fns
"fv":"1",ftype"1"
}where " indicates that a specific field is visible, ''0" indicates it is not.Note that the order of the settings you make is important – when exported, the fields will be visible in exactly the same order you specify here.
limit | No | integer | Determines the maximum number of data records that can be returned. The value must be greater than zero. |
offset | No | integer | Specifies the offset of the first row to return. |
orderBy | No | string | Specifies the field by which you want to order your data records. The field name can be one of the following: lud | fns | fv | ftype | fid | lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft |
orderDirection | No | string | Determines whether the sorting results will be displayed in ascending (ASC) or descending (DESC) order. |
If your request is successful, you should see a response similar to the following:
where "1" indicates that a specific field is visible and ''0" indicates that it is not. Note that the order of the settings you make is important – when exported, the fields will be visible in exactly the same order you specify here. |
limit | No | integer | Determines the maximum number of data records that can be returned. The value must be greater than zero. |
offset | No | integer | Specifies the offset of the first row to return. |
orderBy | No | string | Specifies the field by which you want to order your data records. The field name can be one of the following: fud | un | hn | lsn | fns | fv | ftype | musage | hu | mu | hb | mb |
orderDirection | No | string | Determines whether the sorting results will be displayed in ascending (ASC) or descending (DESC) order. |
If your request is successful, you should see a response similar to the following:
Code Block |
---|
|
{
"success": ${success},
"msg": ${message},
"data": [
{
"fid": ${featureId}, |
Code Block |
---|
|
{
"success": ${success},
"msg": ${message},
"data": [
{
"fid": ${featureId_1},
"lud": ${date},
"lumin": ${minUsed},
"lua": ${averageUsed},
"lumax": ${maxUsed},
"lbmin": ${minBorrowed},
"lbmax": ${maxBorrowed},
"ldtc": ${denials},
"hu": ${hoursUsed},
"ft": ${total},
"fnslsid": ${featureNamelicenseServerId},
"ftypeuid": ${featureTypeuserId},
"fvuil": ${featureVersion}
},
{userIsLdap},
"fidfud": ${featureId_1date},
"ludun": ${dateusername},
"luminhn": ${minUsedhostname},
"lualsn": ${averageUsedlicenseServerName},
"lumaxfns": ${maxUsedfeatureName},
"lbminfv": ${minBorrowedfeatureVersion},
"lbmaxftype": ${maxBorrowedfeatureType},
"ldtcmusage": ${denialsmaxUsage},
"hu": ${hoursUsed},
"ftmu": ${totalmaxUsed},
"fnshb": ${featureNamehoursBorrowed},
"ftype": ${featureType},
"fvmb": ${featureVersionmaxBorrowed}
}
],
"code": ${code},
"totalCount": ${count}
} |
where the response fields can be explained as follows:
Field | Type | Description |
---|
success | boolean | Indicates that |
the your API request was successfully processed. |
msg | string | Error message returned on failure. |
fid | integer | Feature ID. |
lsid | integer | License server ID. |
fidFeature lud |
uil | boolean | Information if user is managed by LDAP. |
fud | string | Indicates period of time for which usage information is generated, i.e. date and time for hourly usage and dates for the remaining granularity options.
|
un | string | Username. |
hn | string | Hostname. |
lsn | string | License server name. |
lumin | integer | Minimal licenses used count for given date. |
lua | float | Average licenses used count for given date. |
lumax | integer | Maximum licenses used count for given date. |
lbmin | integer | Minimal licenses borrowed count for given date. |
lbmax | integer | Maximum licenses borrowed count for given date. |
ldtc | integer | Denials count. |
hu | float | Hours used. |
ft |
|
fns | string | Feature name.
|
fv | string | Feature version. |
ftype | string | Feature type. |
musage | float | Maximum usage of licenses in relation to total license number, expressed in percentages. |
hu | float | Hours used.
|
mu | integer | Maximum licenses used count for given date. |
hb | float | Hours borrowed. |
mb | integer | Maximum licenses borrowed count for given date |
integer | Feature total. |
code | integer | Error code if success equals false, null otherwise. |
totalCount | integer | Total number of rows |
returned.fns | string | Feature name. |
ftype | string | Feature type. |
fv | string | Feature version. |
...