NETWORK_ADAPTER
This table represents the network adapter (also known as the print server) of a physical printer.
|
Field name |
Data type |
Description |
|---|---|---|
|
ADAPTER_TYPE |
VARCHAR(31) |
Always INA (internal network adapter). |
|
ADAPTER_ID |
BIGINT |
The primary key. |
|
FIRMWARE_REVISION |
VARCHAR(255) |
The current network firmware revision. |
|
MANUFACTURER |
VARCHAR(255) |
N/A. |
|
MODEL_NAME |
VARCHAR(255) |
N/A. |
|
SERIAL_NUMBER |
VARCHAR(50) |
N/A. |
|
SYSTEM_NAME |
VARCHAR(255) |
N/A. |
|
RETRIES |
INTEGER |
The number of times to retry communicating with a printer. |
|
SNMP_READ_COMMUNITY_NAME |
VARCHAR(255) |
The SNMP community name for reading. |
|
TIMEOUT |
BIGINT |
The number of milliseconds to wait for a particular communication attempt with a printer to succeed. |
|
CONTACT_LOCATION |
VARCHAR(255) |
N/A. |
|
CONTACT_NAME |
VARCHAR(255) |
N/A. |
|
DOMAIN_NAME_SUFFIX |
VARCHAR(191) |
The domain name suffix associated with this network adapter (for example, foo.lexmark.com). Combine with HOSTNAME to get the fully qualified domain name (FQDN). |
|
HOSTNAME |
VARCHAR(63) |
The host name associated with this network adapter. MVE can be configured to retrieve the host name from DNS or from the network adapter itself. Combine with DOMAIN_NAME_SUFFIX to get the fully qualified domain name (FQDN). |
|
IP_ADDRESS |
VARCHAR(15) |
The integer representation of the IP address of this network adapter. Deprecated. |
|
IP_ADDRESS_INT |
INTEGER |
The integer representation of the IP address of this network adapter. |
|
IP_ADDRESS_SUBNET |
INTEGER |
The integer representation of the subnet on which this network adapter resides. |
|
MAC_CANONICAL |
VARCHAR(12) |
The MAC address of the network adapter, in canonical format. |
|
PORTS |
INTEGER |
The number of ports that the network adapter supports. Always 1. |
|
RAND_MAC |
SMALLINT/ TINYINT* |
The flag indicating whether the current value of MAC_CANONICAL was randomly generated. |
|
CREDENTIAL_REQUIRED |
SMALLINT/ TINYINT* |
The flag indicating whether a credential is necessary to communicate with the associated printer. |
|
CREDENTIAL_PASSWORD |
BLOB SUB_TYPE 0 |
This value is encrypted and not available for use outside MVE. |
|
CREDENTIAL_PIN |
BLOB SUB_TYPE 0 |
This value is encrypted and not available for use outside MVE. |
|
CREDENTIAL_REALM |
VARCHAR(64) |
The credential realm, if set. |
|
CREDENTIAL_USERNAME |
VARCHAR(255) |
The credential username, if set. |
|
PORT_CONFIG_LST_TCP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_LST_UDP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_MDNS_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_NPA_TCP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_NPA_UDP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_RAW_PRINT_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_SNMP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_XML_TCP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
PORT_CONFIG_XML_UDP_OPEN |
SMALLINT/ TINYINT* |
The flag indicating whether this port on the associated printer is open. |
|
SECURE_COMMUNICATION_STATE |
VARCHAR(255) |
The state of the communication. The options are UNSECURED, MISSING_CREDENTIALS, and SECURED. |
|
USER_PASSWORD |
Blob sub_type 0 |
The username portion of the credentials. |
|
SNMP_USERNAME |
VARCHAR(32) |
The user name used for SNMPv3 communications. |
|
SNMP_PASSWORD |
VARCHAR(255) |
This value is encrypted and not available for use outside MVE. |
|
SNMP_MIN_AUTHENTICATION_LEVEL |
Varchar(50) |
The minimum authentication level used for SNMPv3 communications. |
|
SNMP_AUTHENTICATION_HASH |
VARCHAR(50) |
The hash authentication used for SNMPv3 communications. |
|
SNMP_PRIVACY_ALGORITHM |
VARCHAR(50) |
The privacy algorithm used for SNMPv3 communications. |
|
LOGIN_METHOD |
VARCHAR(256) |
The authentication method used to log in to the printer. |
|
LOGIN_METHOD_NAME |
VARCHAR(256) |
If LOGIN_METHOD is either LDAP or LDAP+GSSAPI, then this field shows the name of the authentication method. |
|
TRACING_SERIAL_NUMBER |
VARCHAR(64) |
The authentication method used to trace the serial number. |
*This data type is required for Microsoft SQL Server.