You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 26 Next »

Obtaining information about usage per user for a feature

You can easily fetch metrics about usage per user for a single feature by sending the following HTTP request.

 GET /api/v1/report/feature/${featureId}/usage-per-user/${returnType}?sd=${startDate}&ed=${endDate}&grat=${granularity}$(additional parameters, as needed)

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}Yesinteger

Specifies feature-specific parameters.

${returnType}YesstringSpecifies the format in which license usage data will be returned. The format can be one of the following: json, csv, xlsx, or pdf.  
sdYesstringSpecifies the start date for which the report will be generated. The date is in YYYY-MM-DD format; for example, 2017-05-20.
edYesstringSpecifies the end date for which the report will be generated. The date is in YYYY-MM-DD format; for example, 2017-05-27.
gratYesstring

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

  • QUARTER or 2
  • MONTH or 3
  • WEEK or 4
  • DAY or 5
agrtNointeger

Specifies type of aggregation of the returned data. Aggregation type 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 XLSX. For CSV and JSON formats this parameter will be ignored.

Note: If you don't pass this parameter, it will be generated automatically for PDF and XLSX types. If provided, it cannot be left empty.

filter

Nojson/string

Applies filtering license usage data on all fields.

To filter by a string column, use the following format. 

[
	{ 
		"type": "string",
		"field": ""${fud | un | ugn | hn | hgn | lsn | fns | fv | ftype}",
		"value": "${value}"
	}
]

To filter by a numeric column, use the following format.

[
	{ 
		"type": "numeric", 
		"comparison": "${gt | lt | eq}", 
		"field": "${musage | hu | mu | hb | mb}",
		"value": "${value}" 
	}
]


fieldsVisibility

Nojson/string

Specifies field visibility settings, like this:

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

(See this section for more field-specific information.)

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.

Response

The following code block shows an example result of a successful request.

{
	"success": ${success},
  	"msg": ${message},
  	"data": [
    	{      		
			"fid": ${featureId},      		
			"lsid": ${licenseServerId},	
			"uid": ${userId},
			"uil": ${userIsLdap},
      		"fud": ${date},      					
			"un": ${username},      			
			"ugn": ${userGroupName},      		
			"hn": ${hostname},
			"hgn": ${hostGroupName},
			"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.

FieldTypeDescription
successbooleanIndicates whether your API request was successfully processed.
msgstringError message returned on failure.
fidintegerFeature ID.
lsidintegerLicense server ID.
uidintegerUser ID.
uilbooleanInformation about whether the 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 or semicolon-separated list of usernames, depending on the aggregation type.
ugnstringName of user group. This field is returned only when the requested aggregation type was usergroup.
hnstringHostname or semicolon-separated list of hostnames, depending on aggregation type.
hgnstringName of host group. This field is returned only when requested aggregation type was hostgroup.
lsnstringLicense server name.
fnsstringFeature name.
fvstringFeature version.
ftypestringFeature type.
musagefloatMaximum usage of licenses in relation to total license number, expressed in percentages.
hufloatHours used.
muintegerMaximum licenses used count for given date.
hbfloatHours borrowed.
mbintegerMaximum licenses borrowed count for a given date.
codeinteger

Error code if success equals false, null otherwise.

totalCountintegerTotal number of rows returned.

Obtaining information about usage per user for a license server

You can easily fetch metrics about usage per user for a single license server by sending the following HTTP request.

 GET /api/v1/report/license-server/${licenseServerId}/usage-per-user/${returnType}?sd=${startDate}&ed=${endDate}&grat=${granularity}$(additional parameters, as needed)

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

ParameterRequiredTypeDescription
${licenseServerId}Yesinteger/string

ID of a single license server or "all" if information about all license servers is requested.

${returnType}YesstringSpecifies the format in which license usage data will be returned. The format can be one of the following: json, csv, xlsx, or pdf.
sdYesstringSpecifies the start date for which the report will be generated in YYYY-MM-DD format; for example, 2017-05-20.
edYesstringSpecifies the end date for which the report will be generated in YYYY-MM-DD format; for example, 2017-05-27.
gratYesstring

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

  • QUARTER or 2
  • MONTH or 3
  • WEEK or 4
  • DAY or 5
  • HOUR or 6
agrtNointeger

Specifies aggregation type of the returned data. Aggregation type 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 XLSX. For CSV and JSON formats this parameter will be ignored.
Note: If you don't pass this parameter, it will be generated automatically for PDF and XLSX types. If provided, it cannot be left empty.

filterNojson/string

Applies filtering license usage data on all fields. (See this section for more format-specific information.)

fieldsVisibilityNojson/string

Specifies field visibility settings. (See the this section for more information.)

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 | ugn | hn | hgn | lsn | fns | fv | ftype | musage | hu | mu | hb | mb

(See this section for more field-specific information.)

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 response given above for usage per user for a feature.

  • No labels