MGR_AGENT Table

This section lists the database columns in the MGR_AGENT table.

MGR_AGENT Table

Database Column

Details

id

Type: Decimal. ,

The Primary key of the MGR_AGENT Table.

lastUpdated

Type: TimeStamp. Unique.

The lastUpdated column represents the date and time the agent details were last updated.

name

Type: text. Unique.

The column name represents the name of the FlexNet agent.

machineName

Type: text. Unique.

The machineName column represents the host on which the FlexNet agent resides.

ipAddress

Type: text. Unique.

The ipAddress column represents the ip address of the host on which FlexNet agent resides.

version

Type: text. Unique.

The column version represents the version of FlexNet Agent.

portNumber

Type: text. Unique.

The column portNumber represents the port of the FlexNet Agent.

type

Type: Integer. Unique.

The column type represents the type of agent. The type 0 represents the standard FlexNet Agent.

status

Type: Integer. Unique.

The column status represents the status of the FlexNet Agent.

The accepted values for Agent status are:

DOWN = 100
UP = 180
MANAGEABLE_UP = 170

FINGERPRINT

Type: text. Unique.

The column FINGERPRINT represents a unique identifier for a FlexNet agent.

protocol

Type: text (max length 32). Unique.

The column protocol represents the network protocol used to connect to the FlexNet Agent. It could be either TCP or SSL.

region

Type: text (max length 256). Unique.

Deprecated

billingBucket

Type: text (max length 256). Unique.

Deprecated

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.