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 per user for a feature
Anchor
obtain
obtain

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

Code Block
languagejs
firstline1
titleUsage per user for a single feature linenumberstrue
 GET /api/v1/report/feature/${featureId}/usage-per-user/${returnType}?sd=${startDateYYYY-MM-DD}&ed=${endDateYYYY-MM-DD}&grat=${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 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

...

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

...

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.

...


Code Block
languagejs

...

[
	{ 
		"type": "string",
		"field": "lud",
		"value": "${value}"
	}
]
firstline1
titleUsage per user for a single license server

To filter by numeric column, use the following format:

Code Block
languagejs
[
	{ 
		"type": "numeric", 
		"comparison": "${gt | lt | eq}", 
		"field": "${fud | un | hn | lsn | fns | fv | ftype | musage | hu | mu | hb | mb}",
		"value": "${value}" 
	}
]

...

Specifies field visibility settings, like this:

Code Block
languagejs
{ 
	"fud": "1", 
	"un": "1", 
	"hn": "1", 
	"lsn": "1", 
	"fns": "1", 
	"fv": "1", 
	"ftype": "1", 
	"musage": "1", 
	"hu": "1", 
	"mu": "1", 
	"hb": "1", 
	"mb": "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:

fud | un | hn | lsn | fns | fv | ftype | musage | hu | mu | hb | mb

If orderBy is provided, orderDirection is mandatory.

...

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

Code Block
languagejs
{
	"success": ${success},
  	"msg": ${message},
  	"data": [
    	{      		
			"fid": ${featureId},      		
			"lsid": ${licenseServerId},	
			"uid": ${userId},
			"uil": ${userIsLdap},
      		"fud": ${date},      		
			"un": ${username},      		
			"hn": ${hostname},
      		"lsn": ${licenseServerName},
      		"fns": ${featureName},
      		"fv": ${featureVersion},
      		"ftype": ${featureType},
      		"musage": ${maxUsage},
      		"hu": ${hoursUsed},
      		"mu": ${maxUsed},
      		"hb": ${hoursBorrowed},
      		"mb": ${maxBorrowed}
    	}
  	],
  	"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.

...

Error code if success equals false, null otherwise.

...

Obtaining information about usage per user for license server

If you want to retrieve information about usage per user for license servers we recommend that you use the following URL request template.

Code Block
languagejs
firstline1
linenumberstrue
 GET /api/v1/report/license-server/${licenseServerId}/usage-per-user/${returnType}?sd=${startDateYYYY-MM-DD}&ed=${endDateYYYY-MM-DD}&grat=${granularity}$(additional parameters, as needed)

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

ParameterRequiredTypeDescription
${featureId}Yesinteger

Internal License Statistics identification of the feature for which you want to view usage history.

${licenseServerId}Yesinteger/string
ID of single license server

Internal License Statistics identification of the license server for which you want to view usage history, or "all" if information about all license servers is requested.

${returnType}Yesstring
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
Standard format option. See Making an API request for details.
sdYes
string
date
Specifies the start
Start date for which the report will be generated
in YYYY-MM-DD format; for example, 2017-01-20
.
edYes
string
date
Specifies the end
End date for which the report will be generated
in YYYY-MM-DD format; for example, 2017-01-27
.
gratYes
integer

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

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

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

    agrtNointeger
    Specifies

    Type of aggregation

    type

    of the returned data

    , which

    . Aggregation type can be one of the following:

    Username
    • User - 1
    Hostname
    • Host - 2
    Username
    • User and
    hostname
    • host - 3
    • Usergroup - 4
    • Hostgroup - 5

    By default, data is aggregated by

    username and hostnamern

    user and host (3).

    standard report optionsNo
    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.

    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",
    		"value": "${value}"
    	}
    ]

    To filter by numeric column, use the following format:

    Code Block
    languagejs
    [
    	{ 
    		"type": "numeric", 
    		"comparison": "${gt | lt | eq}", 
    		"field": "${fud | un | hn | lsn | fns | fv | ftype | musage | hu | mu | hb | mb}",
    		"value": "${value}" 
    	}
    ]
    fieldsVisibilityNojson/string

    Specifies field visibility settings, like this:

    Code Block
    languagejs
    { 
    	"fud": "1", 
    	"un": "1", 
    	"hn": "1", 
    	"lsn": "1", 
    	"fns": "1", 
    	"fv": "1", 
    	"ftype": "1", 
    	"musage": "1", 
    	"hu": "1", 
    	"mu": "1", 
    	"hb": "1", 
    	"mb": "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.

    limitNointegerDetermines the maximum number of data records that can be returned. The value must be greater than zero.offsetNointegerSpecifies 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:

    fud | un | hn | lsn | fns | fv | ftype | musage | hu | mu | hb | mb

    If orderBy is provided, orderDirection is mandatory.

    orderDirectionNostringDetermines whether the sorting results will be displayed in ascending (ASC) or descending (DESC) order. If orderDirection is provided, orderBy is mandatory

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

    Code Block
    languagejs
    {
    	"success": ${success},
      	"msg": ${message},
      	"data": [
        	{      		
    			"fid": ${featureId},      		
    			"lsid": ${licenseServerId},	
    			"uid": ${userId},
    			"uil": ${userIsLdap},
          		"fud": ${date},      		
    			"un": ${username},      		
    			"hn": ${hostname},
          		"lsn": ${licenseServerName},
          		"fns": ${featureName},
          		"fv": ${featureVersion},
          		"ftype": ${featureType},
          		"musage": ${maxUsage},
          		"hu": ${hoursUsed},
          		"mu": ${maxUsed},
          		"hb": ${hoursBorrowed},
          		"mb": ${maxBorrowed}
        	}
      	],
      	"code": ${code},
      	"totalCount": ${count}
    }

    where the response fields can be explained as follows:

    various

    See Making an API request for details.

    Response

    On success, this report will contain one row for each feature for each aggregator for each period. Each row consists of the following columns.


    FieldTypeDescriptionsuccessbooleanIndicates that your API request was successfully processed.msgstringError message returned on failure.fidintegerFeature ID.lsidintegerLicense server ID.uidintegerUser ID.uilbooleanInformation if user is managed by LDAP.fudstring

    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.

    unstringUsername.hnstringHostname.lsnstringLicense server name.
    fnsstringFeature name.
    fvstringFeature version.ftypestringFeature type.musage
    ColumnFull nameTypeDescriptionVisible by default in export
    fudDatestring

    The time period. Format depends on granularity.

    (tick)Yes
    uidUser IDstring

    Internal License Statistics identification of the user for aggregations User(1) and User and Host(3).

    Otherwise, a semicolon-separated list of user IDs.

    (error) Unavailable
    unUserstring

    Name of the user for aggregations User(1) and User and host(3).

    Otherwise, a semicolon-separated list of usernames.

    (tick)Yes
    uilUser is from LDAPstring

    Information about whether the user is managed by LDAP for aggregations User(1) and User and host(3).

    Otherwise, a null value.

    (error) Unavailable
    ugnUser Groupstring

    Name of user group for aggregations Usergroup(4).

    Otherwise, an empty string.

    (warning) Only for aggregation Usergroup(4)
    hnHoststring

    Hostname for aggregations Host(2) and User and host(3).

    Otherwise, a semicolon-separated list of hostnames.

    (tick)Yes
    hgnHost GroupstringName of host group for aggregations Hostgroup(5).

    Otherwise, an empty string.

    (warning) Only for aggregation Hostgroup(4)
    lsidLicense Server IDintegerInternal License Statistics identification of the license server hosting the feature.
    (error) Unavailable
    lsnLicense ServerstringName of the license server hosting the feature.(tick)Yes
    fidFeature IDintegerInternal License Statistics identification of the feature.
    (error) Unavailable
    fnsFeature NamestringFeature name.
    (tick)Yes
    fvFeature VersionstringFeature version.(tick)Yes
    ftypeFeature TypeenumerationSee feature type descriptions for details.(tick)Yes
    musageMax Usage
    floatMaximum usage of licenses in relation to total
    license
    number of licenses in the period, expressed in percentages.(tick)Yes
    huHours Usedfloat
    Hours used.
    Cumulative time used by all licenses of the feature in the period, in hours.(tick)Yes
    muMax Used
    mu
    integerMaximum number of licenses
    used count for given date
    of the feature used in the period.
    (tick)Yes
    hbHours Borrowedfloat
    Hours borrowed.
    Cumulative time of all license borrows of the feature in the period, in hours.
    (tick)Yes
    mbMax Borrowed
    mb
    integerMaximum number of licenses
    borrowed count for given date
    of the feature borrowed in the period.
    codeinteger

    Error code if success equals false, null otherwise.

    totalCountintegerTotal number of rows returned
    (tick)Yes

    Note that the order in the table is the default order of the columns in the exported file.