MGR_LICENSESERVER Table

The MGR_LICENSESERVER table stores information relating to a LicenseServer.

MGR_LICENSESERVER Table

Database Column

Details

id

Type: Decimal.

The primary key of the MGR_LICENSESERVER table.

lastUpdated

Type: TimeStamp. Unique.

The LastUpdated column represents the date and time the license server manager status was last updated.

name

Type: text. Unique.

The name column represents the name of the license server

hostName

Type: text. Unique.

The hostname represents the host name for the license server.

hostId

Type: text. Unique.

The hostId column represents the host Id of the license server.

lmgrdLocation

Type: text. Unique.

The lmgrdLocation column represents the path to the lmgrd executable (license server manager) on the license server.

lmgrdVersion

Type: text. Unique.

The lmgrdVersion column represents the version of the lmgrd executable (license server manager).

portNumber

Type: text. Unique.

The portnumber column represents the License manager port.

master

Type: Boolean. Unique.

The master column represents the whether this License server is the master in a License Server group.

newLicenseDirectory

Type: text. Unique.

The newLicenseDirectory represents the directory where the licenses will be added.

lmutilLocation

Type: text. Unique.

The lmutilLocation column represents the path to the lmutil executable on the license server.

enableDebugging

Type: Boolean. Unique.

The enableDebugging column represents an option to enable creation of debug log for this license server.

appendDebugLog

Type: Boolean. Unique.

The appendDebugLog column represents an option to append new debug log information to this license server's existing debug log file.

licensePaths

Type: text (max length 2048). Unique.

The licensePaths column represents the full path to your license files or directories.

debugLogLocation

Type: text. Unique.

The debugLogLocation column represents the full path to the debug log file.

notes

Type: text (max length 1000). Unique.

The notes column stores the custom notes for this license server.

xlmdown

Type: Boolean. Unique.

The xlmdown column represents the running value of the configuration that allows the remote shutdown of this license server.

xlmremove

Type: Boolean. Unique.

The xlmremove column represents the running value of the configuration that allows the licenses to be freed.

is_local

Type: Boolean. Unique.

The is_local column represents the configuration that allows the remote shutdown of this license server.

serverRole

Type: Integer. Unique.

The serverRole column represents whether the license server is Master or Redundant server.

status

Type: Integer. Unique.

The status column represents the staus of a license server. The accepted values for "active" are:

100 = DOWN
130 = UNKNOWN
140 = STOPPING
150 = STARTING
160 = REREADING
170 = MANAGEABLE_UP
180 = UP

EXTENDED_STATUS

Type: Integer. Unique.

The EXTENDED_STATUS column represents constant ints used as License Server status descriptions. Mostly to indicate the source of the problem

FINGERPRINT

Type: text. Unique.

ACTIVE

Type: Integer. Unique.

The ACTIVE column represents the state of this license server. The accepted values for "active" are:

0 = Not active / Orphan / Invalid
1 = Active / Valid
-1 = Updating

STATE

Type: Integer. Unique.

This column is an integer that contains all the measurables. It is an extended state that is later mapped to a simpler status. Each position holds the state of one measurable.

startParameters

Type: text. Unique.

The startParameters column represents the command-line option when starting lmgrd or lmadmin.

TIMEZONE

Type: text. Unique.

The Timezone column represents the timezone of this license server.

agent

Type: Decimal.

References Table: MGR_AGENT Table

Backward reference of a LicenseServer to its parent Agent entity

LicenseServerGroup_id

Type: Decimal.

References Table: MGR_AGENT Table

The LicenseServerGroup_id represents the LicenseServerGroup to which this license server belongs.