Discovery profiles

The following tables are used to track the discovery profiles of MVE.

DISCOVERY_PROFILE

Field Name

Data Type

Description

ID

BIGINT

The primary key.

NAME

VARCHAR(255)

The user-supplied name for the profile.

RETRIES

INTEGER

The number of times to retry communicating with a printer.

SNMP_READ_COMMUNITY_NAME

VARCHAR(255)

The SNMP community name to use when reading.

TIMEOUT

BIGINT

The number of milliseconds to wait for a particular communication attempt with a printer to succeed.

SNMP_USERNAME

VARCHAR(32)

The user name for SNMP communication.

SNMP_PASSWORD

VARCHAR(32)

The password for SNMP communication.

SNMP_MIN_AUTHENTICATION_LEVEL

VARCHAR(255)

The minimum authentication level for SNMP.

SNMP_AUTHENTICATION_HASH

VARCHAR(50)

The hash used for SNMP authentication.

SNMP_PRIVACY_ALGORITHM

VARCHAR(50)

The algorithm used for SNMP privacy.

DISCOVERY_PROFILE_CI

This table contains the CI-specific pieces of the discovery profile.

Field Name

Data Type

Description

CI_DP_ID

BIGINT

The primary key, and the foreign key to DISCOVERY_PROFILE.ID.

AUTOMANAGE

SMALLINT/ TINYINT*

The flag indicating whether CIs discovered using this profile must be automatically managed.

DESCRIPTION

VARCHAR(4000)

The user-provided description of the discovery profile.

LAST_RUN

TIMESTAMP

Time stamp of the last run of the profile.

CREDENTIAL_USERNAME

VARCHAR(255)

The credential user name, if set.

CREDENTIAL_REALM

VARCHAR(64)

The credential realm, if set.

LOGIN_METHOD

VARCHAR(256)

The authentication method used to log in to the printer.

LOGIN_METHOD_NAME

VARCHAR(256)

The name of the authentication method if LOGIN_METHOD is either LDAP or LDAP+GSSAPI.

CREDENTIAL_PASSWORD

BLOB

This value is encrypted and not available for use outside MVE.

CREDENTIAL_PIN

BLOB

This value is encrypted and not available for use outside MVE.

ASSIGN_KEYWORD_IDS

VARCHAR(512)

The assigned keywords in a discovery profile.

*This data type is required for Microsoft SQL Server.

EXCLUDE_PROFILE_ITEM

This table represents the Exclude list for a profile. Each excluded item has a row in this table.

Field Name

Data Type

Description

DISCOVERY_PROFILE_ID

BIGINT

The composite primary key, and the foreign key to DISCOVERY_PROFILE.ID.

VALUE_

VARCHAR(255)

The composite primary key. This field defines what items to exclude.

INCLUDE_PROFILE_ITEM

This table represents the Include list for a profile. Each included item has a row in this table.

Field Name

Data Type

Description

DISCOVERY_PROFILE_ID

BIGINT

The composite primary key, and the foreign key to DISCOVERY_PROFILE.ID.

VALUE_

VARCHAR(255)

The composite primary key. This field defines what items to include.

DISCOVERY_PROFILE_MODEL_CONFIG

This table represents the Assign Configurations portion of a discovery profile.

Field Name

Data Type

Description

ID

BIGINT

The primary key.

MODEL

VARCHAR(255)

The model name of the printers to which the configuration is assigned.

DISCOVERY_PROFILE_ID

BIGINT

The foreign key to DISCOVERY_PROFILE.ID.

CI_CONFIGURATION_ID

BIGINT

The foreign key to CONFIGURATION.CONFIGURATION_ID.