11.32 idmrpt_ms_collector_v

idmrpt_ms_collector contains information about the connected systems. This is the data that drives the Identity Vaults page in the reporting tool. These connected systems are used to collect reporting data.

ms_collect_id

VARCHAR(32)

The unique id for the collector

collect_name

VARCHAR(4000)

The name of the collector

collect_port

int4

The port for connecting to the collector

collect_host

VARCHAR(64)

The host name of the collector

collect_context

VARCHAR(32)

The context for the collector

collect_protocol

VARCHAR(8)

The protocol for the collector. Values: http, hhtps

collect_acct

VARCHAR(128)

The account name used to connect to the collector

collector_pswd

VARCHAR(128)

The password used for connecting to this collector

collect_cert

bytea

The optional certificate used when connecting to this collector. This is only used for SSL.

collect_desc

VARCHAR(4000)

The description of the collector

data_locales

VARCHAR(255)

The locales to use when collecting data from this collector. Locale data is available in the managed system.(coma separated list).

last_collect_date

TIMESTAMP WITH TIME ZONE

The last date data was collected from this collector

next_collect_date

timestamptz

The next date data will be collected from this collector

collect_type

int2

The type of the pooling collector: 1 -idm engine rest endpoint collector 2 - enterprize application collector

collect_state

int2

The current state of the collection operation. Possible states are: 0- uninitialized, 1 - initialized, 2 - active, 3-running, 4 - suspended, 5- deleted

ms_cert_info

VARCHAR(4000)

The public information about the certificate including the certificate name and file name.

idmrpt_deleted

bool

TRUE if this collector has been deleted and FALSE otherwise