Versions Compared

Key

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

...

Applies filtering license usage data on all fields.

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

Parameter
Required
Type
Description
${featureId}Yesinteger/stringInternal LicStat identification Specifies ID of the feature for which you want to view current usage.
${returnType}YesstringSpecifies the format in which the data should be returned. The format can be one of the following: json, csv, xlsx, or pdf.
fieldsVisibility Nojson/string

Specifies field visibility settings, for example:

Code Block
languagejs
firstline1
{ "uid": "1", "un": "1", "hn": "1", "lus": "1", "lco": "1", "tu": "1", "lbe": "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 XLSX. 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 XLSX types. If provided, it cannot be left empty.
filterNojson/string
Code Block
languagejs
firstline1
linenumberstrue
[
    {
        "type": "string",
        "field": "${un | hn | lco | lbe}",
        "value": "${value}"
    }
]

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

Code Block
linenumberstrue
[
    {
        "type": "numeric",
        "comparison": "${gt | lt | eq}",
        "field": "${uid, lus}",
        "value": "${value}"
    }
]
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, lus, lco, tu, lbe

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

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

Response

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

Code Block
languagejs
firstline1
linenumberstrue
{
    success: ${success},
    msg: ${message},
    data: [{
        "uid": ${userId},
        "un": ${userName},
        "hn": ${hostName},
        "lus": ${licensesUsed},
        "lco": ${checkoutTime},
        "tu": ${licensesUsed},
        "lbe": ${borrowExpire},
        "uil": ${ldapUser}
    }],
    "code": ${errorCode},
    "totalCount": ${totalCount}
}

...

Standard format option. See Making an API request for details.
standard report options Novarious

See Making an API request for details.

Response

On success, the report will contain one row for each license session for a specified feature. Each row consists of the following columns.


Column
Full name
Type
Description
Visible by default in export

uid

User Id

integer

Internal License Statistics identification of user that checked out licenses.

Minus (-)No

un

Username

string

Name of user that checked out licenses.

Yes

hn

Hostname

string

Name of host where licenses were checked out to.

Yes

lus

Used
Field
Type
Description

uid

integer

User ID.

un

string

Username.

hn

string

Hostname.

lus

integer

Total number of licenses used by user on host.

Yes

lco

Checked Out

date and time

string

Date when

license was

licenses were checked out.

The date is in YYYY-MM-DD HH:MM format; for example, 2017-05-20 10:20.


Yes
tuTime Usedstring

How long the licenses have

lbe

string

Borrow expiration date. The date is in YYYY-MM-DD HH:MM format; for example, 2017-05-20 10:20.

Returns an empty string if does not apply.

tustringIndicates how long this license has

been in use. Note that you cannot filter on this field.

Yes

lbe

Borrow Expiration

date and time

Borrow expiration date. Returns an empty string if not applicable.

Yes

uil

User is from LDAP

boolean

Indicates whether user details have been imported from an LDAP directory. Note that you cannot filter and order data by this field.

msg

string

Error message returned on failure.

success

boolean

Indicates whether your API request was successfully processed. 

codeinteger

Error code for an unsuccessful request.

totalCountintegerTotal number of all matching results
Error (x) Unavailable

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

 Example

Say you would like to download data in a CSV file about current feature usage for feature "1". To generate this data set, enter a command similar to the following.

...

Code Block
languagejs
firstline1
GET /api/v1/report/feature/${featureId}/usage/chart/json?day=${dayYYYY-MM-DD}

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

Parameter
Required
Type
Description
${featureId}YesintegerID Internal License Statistics identification of the feature for which you want to get data.
${day} NostringdateDate in YYYY-MM-DD format. Indicates day for which you want to gather data. If not provided, it defaults to today.

Response

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

 

Code Block
languagejs
firstline1
linenumberstrue
{
    success: ${success},
    msg: ${message},
    data: [{
        "fid": ${featureId},
        "lud": ${dateAndTime},
        "ltc": ${totalCount},
        "lumax": ${licenseUsageMax},
        "lbmax": ${licensesBorrowedMax}
    }],
    "code": ${errorCode},
    "totalCount": ${totalCount}
}

where the response fields can be explained as follows:

This report supports only JSON format.

Response

On success, this report will contain one row for each 5-minute-long period with usage statistic for the specified feature throughout the period.

Periods are from midnight, each 5 minutes (00:00-00:05, 00:05-00:10, 00:10-0:15, ...).

Each row consists of the following columns: 


Column
Full name
Type
Description
fidFeature IDintegerReturn specified feature ID from request.
ludPeriod Startdate and timeBeginning of the period.
ltcTotalintegerTotal number of licenses available for feature in the period.
lumaxMax Used
Field
Type
Description
fidintegerFeature ID.ludstringDate and time (adjusted to 5 minute intervals).ltcintegerLicense total count.lumax
integerMaximum amount of used licenses during the period.
lbmaxMax BorrowedintegerMaximum amount of borrowed licenses
.

msg

string

Error message returned on failure.

success

boolean

Indicates whether the API request was successfully processed. 

codeinteger

Error code for unsuccessful request.

totalCountintegerTotal number of all matching results
during the period.