Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Some information on this page refers to License Statistics v5.7 or newer, which changed the API endpoint URL in order to maintain version integrity into the future. If you are running a previous version of License Statistics, please refer to v5.4-v5.6 documentation.

License Statistics API allows you to generate data from User History endpoint delivers metrics License Statistics collects from the monitored license server. This endpoint is used to fetch license usage metrics specific to the User History report. This report shows , allowing you to see statistics for license usage per user, during any period that usage was tracked.

Showing sessions at a specific point in time

If you want to retrieve information fetch metrics about usage history at a particular point in time, we recommend that you use the following URL request template.

Code Block
languagejs
firstline1
linenumberstrue
GET /api/v1/report/feature/${featureId}/user-history/${returnType}?sdt=${sessionDateTime}&(additional parameters, as needed)

where :- $ $ indicates a variable value that you can replace with a proper value, as needed- value that best suits your needs and the possible parameters are as follows:

ParameterRequiredTypeDescription
${featureId}Yesinteger

Specifies feature-specific parameters.

${returnType}YesstringSpecifies the format in which license usage data should be returned. The format can be one of the following: jsonJSON, csvCSV, xls XLS or pdfPDF.
sdtYesstringSpecifies point in time for which you want to generate the report. The date and time format is as follows: YYYY-MM-DD HH:MM; for example, 20152017-0105-20 11:00.
fieldsVisibility Nojson/string

Specifies field visibility settings, for example:

Code Block
languagejs
firstline1
linenumberstrue
{"un": "1", "hn": "1", "sst": "1", "set": "1"}

where number "1" indicates that a specific field is visible.
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.

rnNostringSpecifies the name of the report that will be displayed once the report has been exported to PDF or XLS.
filterNojson/string

Applies filtering license usage data on all fields. To filter your data, use the following format:

Code Block
languagejs
firstline1
linenumberstrue
[{"value": intOrString, "field": "${fid | fns | fv | ftype | lsid | lsn | vn | gtn}"}]
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:

uid, un, hn, sst, set

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

orderDirectionNostringDetermines 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 followingThe following code block shows an example result of a successful request:

Code Block
languagejs
firstline1
linenumberstrue
{
success: true, 
msg: ${message}, 
data: [{
  uid: ${userId}, 
  un: ${userName},
  hn: ${hostName},
  sst: ${sessionStartTime},
  set: ${sessionEndTime},
  il: ${hasUserLdapDetails}
}]
}

where the response fields can be explained as follows:

Anchor
fields def
fields def

FieldTypeDescription
uidintegerUser ID.
unstringUsername.
hnstringHostname.
sststringDate returned in YYYY-MM-DD HH:MM format; for example, 20162017-0105-20 11:00.
setstringDate returned in YYYY-MM-DD HH:MM format (for example, 20162017-0105-20 11:00), "Unknown", or "Still in use".
ilbooleanIndicates whether user details have been imported from LDAP directory. Note that you cannot filter and order data by this field.
msgstringError message returned on failure.
successbooleanIndicates that the your API request was successfully processed.

...

Code Block
languagejs
firstline1
linenumberstrue
GET /api/v1/report/feature/${featureId}/user-history/${returnType}?ssd=${sessionStartDate}&sed={sessionEndDate}&(additional parameters, as needed)

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

ParameterRequiredTypeDescription
${featureId}YesintegerSpecifies feature-specific parameters.
${returnType}YesstringSpecifies the format in which license usage data should be returned. The format can be one of the following: jsonJSON, csvCSV, xls XLS or pdfPDF.
ssdYesstring

Specifies the start date for which the report will be generated in YYYY-MM-DD format; for example, 20162017-0105-20.

sedYesstring

Specifies the end date for which the report will be generated in YYYY-MM-DD format; for example, 20162017-0105-27.

fieldsVisibility  

Specifies field visibility settings, for example:

Code Block
languagejs
firstline1
linenumberstrue
{"un": "1", "hn": "1", "sst": "1", "set": "1"}

where number "1" indicates that a specific field is visible.
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.

rnNostringSpecifies the name of the report that will be displayed once the report has been exported to PDF or Excel.
filterNojson/string

Applies filtering license usage data on all fields. To filter your data, use the following format:

Code Block
languagejs
firstline1
linenumberstrue
[{"value": intOrString, "field": "${un | hn | sst | set}"}]
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:

uid, un, hn, sst, set 

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

orderDirectionNostringDetermines whether the sorting results will be displayed in ascending (ASC) or descending (DESC) order.

...

Code Block
languagejs
firstline1
linenumberstrue
{success: true, msg: ${message}, data: [
  uid: ${userId}, 
  un: ${userName},
  hn: ${hostName},
  sst: ${sessionStartTime},
  set: ${sessionEndTime},
  il: ${hasUserLdapDetails}
]}

where the response fields can be explained as followsThe following code block shows an example result of a successful request:

FieldTypeDescription
uidintegerUser ID.
unstringUsername.
hnstringHostname.
sststringDate returned in YYYY-MM-DD HH:MM format; for example, 20162017-0105-20 11:00.
setstringDate returned in YYYY-MM-DD HH:MM format (for example, 20162017-0105-20 11:00), "Unknown", or "Still in use".
ilbooleanIndicates whether user details have been imported from LDAP directory. Note that you cannot filter and order data by this field.
msgstringError message returned on failure. 

...