Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Warning
This page refers to functionality that has been removed from License Statistics. This information no longer applies to License Statistics v6.3 and newer.

Obtaining information about usage history

...

Anchor
obtain
obtain

If you want to retrieve information about usage history for a single feature, we recommend that you use the following URL request templateYou can easily fetch metrics about usage history by sending one of the the following HTTP requests.

Code Block
languagejs
firstline1
titleUsage history for a single featurelinenumberstrue
GET /api/v1/report/usage-history/feature/${featureId}/usage-history/${returnType}?sd=${startDateYYYY-MM-DD}&ed=${endDateYYYY-MM-DD}&granularity=${granularity}$(additional parameters, as needed)

 where

 - $ indicates a variable value that you can replace with an appropriate value, as needed

 - possible parameters are as follows:

...

Specifies feature-specific parameters.

...

Specifies granularity of the returned data, which can be one of the following:

  • Quarter - 2
  • Month - 3
  • Week - 4
  • Day - 5
  • Hour - 6

...

No

...

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.

...

Applies filtering license usage data on all fields.

To filter by string column, use the following format: 

Code Block
languagejs
[
	{ 
		"type": "string",
		"field": "lud",
		"value": "${value}"
	}
]

To filter by numeric column, use the following format:

Code Block
languagejs
[
	{ 
		"type": "numeric", 
		"comparison": "${gt | lt | eq}", 
		"field": "${lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft}",
		"value": "${value}" 
	}
]


Code Block
languagejs
firstline1
titleUsage history for a composite feature on license server group
GET /api/v1/report/feature-composite/${fcid}/usage-history/${returnType}?sd=${YYYY-MM-DD}&ed=${YYYY-MM-DD}&granularity=${granularity}$(additional parameters, as needed)

Anchor
comparison
comparison

Code Block
languagejs
firstline1
titleUsage history comparison for features
GET /api/v1/report/feature-comparison/${ucompi}/report/${returnType}?sd=${YYYY-MM-DD}&ed=${YYYY-MM-DD}&granularity=${granularity}


Code Block

...

Specifies field visibility settings, like this:

Code Block
languagejs
{ 
	"lud": "1", 
	"lumin": "1", 
	"lua": "1", 
	"lumax": "1", 
	"lbmin": "1", 
	"lbmax": "1", 
	"ldtc": "1", 
	"hu": "1", 
	"ft": "1"
}

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.

...

Specifies the field by which you want to order your data records. The field name can be one of the following:

lud | lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft

...

If your request is successful, you should see a response similar to the following:

Code Block
languagejs
{
	"success": ${success},
  	"msg": ${message},
  	"data": [
    	{
      		"fid": ${featureId},
      		"lud": ${date},
      		"lumin": ${minUsed},
      		"lua": ${averageUsed},
      		"lumax": ${maxUsed},
      		"lbmin": ${minBorrowed},
      		"lbmax": ${maxBorrowed},
      		"ldtc": ${denials},
      		"hu": ${hoursUsed},
      		"ft": ${total}
    	}
  	],
  	"code": ${code},
  	"totalCount": ${count}
}

where the response fields can be explained as follows:

...

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.

...

ldtc

...

Error code if success equals false, null otherwise.

...

Obtaining information about usage history comparison for features

If you want to obtain information about usage history comparison for features, we recommend that you use the following URL request template.

Code Block
languagejs
firstline1
titleUsage history for a license serverlinenumberstrue
GET /api/v1/report/license-server/${lsid}/usage-history/comparison/json?fi=${featureIdsreturnType}&?sd=${startDate}&ed=${endDate}&granularity=${granularity}

Possible parameters are as follows:

...

YYYY-MM-DD

...

}&ed={YYYY-MM-DD

...

}&granularity=${granularity}$(additional parameters, as needed)


Code Block
titleUsage history for a license server group

...

  • 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
languagejs
{
	"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
languagejs
firstline1
linenumberstrue
GET /api/v1/report/usage-history/license-server-group/${lsidlsgid}/usage-history/${returnType}?sd=${startDateYYYY-MM-DD}&ed={endDateYYYY-MM-DD}&granularity=${granularity}$(additional parameters, as needed)

Possible parameters are as follows:where $ indicates a variable value that you can replace with a value that best suits your needs. The possible parameters are described below.

ParameterRequiredTypeDescription
${featureId}YesintegerInternal License Statistics identification of the feature to show usage history for.
${fcid}YesintegerInternal License Statistics identification of the feature composite to show usage history for.
${ucompi}YesintegerInternal License Statistics identification of feature history comparison.
${lsid}Yesinteger
License Server ID
Internal License Statistics identification of the license server to show usage history for.
${
returnType
lsgid}Yes
stringSpecifies the format in which license usage data will be returned. The format can be one of the following: json, csv, xls, xlsx or pdf
integerInternal License Statistics identification of the license server group to show usage history for.
${returnType}YesstringStandard format option. See Making an API request for details.
sdYes
string 
dateStart
Specifies the start
date for which the report will be generated
in YYYY-MM-DD format; for example, 2017-01-20
.
edYes
string Specifies the end
dateEnd date for which the report will be generated
in YYYY-MM-DD format; for example, 2017-01-27
.
granularityYes
integer  

Specifies granularity of the returned data, which can be one of the following:

 
  • Quarter - 2
  • Month - 3
  • Week - 4
  • Day - 5
  • Hour - 6
rnNostring 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.
filterNojson/string

Applies filtering license usage data on all fields.

To filter by string column, use the following format: 

Code Block
languagejs
[
	{ 
		"type": "string", 
		"field": "${lud | fns | fv | ftype}",
		"value": "${value}"
	}
]

To filter by numeric column, use the following format:

Code Block
languagejs
[
	{ 
		"type": "numeric", 
		"field": "${lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft}",
		"value": "${value}"
	}
]
fieldsVisibilityNojson/string

Specifies field visibility settings, for example:

Code Block
languagejs
{ 
	"lud": "1", 
	"lumin": "1", 
	"lua": "0", 
	"lumax": "1", 
	"lbmin": "1", 
	"lbmax": "1", 
	"ldtc": "1", 
	"hu": "0", 
	"ft": "0",
	"fns": "1",
	"fv": "1",
	"ftype": "1"
}

where "1" 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.

limitNointeger Determines the maximum number of data records that can be returned. The value must be greater than zero.offsetNointeger Specifies the offset of the first row to return.orderByNostring

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
orderDirectionNostring 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
languagejs
{
	"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},
			"fns": ${featureName},
			"ftype": ${featureType},
			"fv": ${featureVersion}
    	},
		{
      		"fid": ${featureId_1},
      		"lud": ${date},
      		"lumin": ${minUsed},
      		"lua": ${averageUsed},
      		"lumax": ${maxUsed},
      		"lbmin": ${minBorrowed},
      		"lbmax": ${maxBorrowed},
      		"ldtc": ${denials},
      		"hu": ${hoursUsed},
      		"ft": ${total},
			"fns": ${featureName},
			"ftype": ${featureType},
			"fv": ${featureVersion}
    	}
  	],
  	"code": ${code},
  	"totalCount": ${count}
}

where the response fields can be explained as follows:

...

ldtc

...

enumeration

Period type the result is aggregated for. See granularity descriptions for further details.

standard report optionsNovarious

See Making an API request for details.

Response

On success, this report will contain one row for every feature and every period in which the feature was monitored. Each row consists of the following columns.

ColumnFull nameTypeDescriptionVisible by default in export
ludDatestring

The time period. Format depends on granularity.

(tick) Yes
fidFeature IdintegerInternal License Statistics identification of the feature(minus) No
fnsFeature NamestringFeature name.(warning) Visible for all, but feature
fvFeature VersionstringFeature version.(warning) Visible for all, but feature
ftypeFeature TypeenumerationSee feature type descriptions for details.(warning) Visible for all, but feature
luminMin UsedintegerMinimal number of licenses of the feature used in the period.(tick) Yes
luaAvg UsedfloatAverage number of licenses of the feature used in the period.(tick) Yes
lumaxMax UsedintegerMaximum number of licenses of the feature used in the period. (tick) Yes
lbminMin BorrowedintegerMinimal number of licenses of the feature borrowed in the period.(tick) Yes
lbmaxMax BorrowedintegerMaximum number of licenses of the feature borrowed in the period. (tick) Yes
ftTotalintegerTotal number of licenses of the feature available in period.(tick) Yes
huHours UsedfloatCumulative time used by all licenses of the feature in the period, in hours.(tick) Yes

ldtc

DenialsintegerNumber of denials of check out of a license of the feature in the period.(tick) Yes

Note that the order in the table is the default order of the columns in the exported file for the license server and license server group reports. For feature, feature composite and comparison default order is: fn, fns, fv, lud, lumin, lua, lumax, lbmin, lbmax, ft, hu, ldtc

...

.