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 |