Contains information about managed systems the reporting information is collecting data from.
ms_id |
VARCHAR(32) |
The unique ID for this managed system in the reporting warehouse |
ms_logical_id |
VARCHAR(4000) |
The logical ID of this managed system |
ms_collect_id |
VARCHAR(32) |
The collection ID of this managed system. |
ms_uuid |
VARCHAR(4000) |
|
ms_idm_driver |
VARCHAR(4000) |
|
ms_name |
VARCHAR(4000) |
|
ms_descr |
VARCHAR(4000) |
The description of this managed system |
ms_bus_owner |
VARCHAR(32) |
The ID of the business owner of this managed system |
ms_app_owner |
VARCHAR(32) |
The ID of the application owner of this managed system |
ms_domain |
VARCHAR(4000) |
The domain host address of this managed system |
ms_type |
VARCHAR(4000) |
The type of this managed system. For example, Active Directory |
ms_classification |
VARCHAR(4000) |
The classification of this managed system. For example, windows |
ms_location |
VARCHAR(4000) |
The physical location of this managed system |
ms_environment |
VARCHAR(4000) |
The operating system of this managed system |
ms_conn_ip |
VARCHAR(255) |
The IP address of this managed system |
ms_conn_auth_id |
VARCHAR(255) |
The ID used when connecting to the managed system |
ms_conn_port |
int4 |
The port used when connecting to this managed system |
ms_vendor |
VARCHAR(256) |
The vendor of this managed system |
ms_version |
VARCHAR(128) |
The version of this managed system |
ms_hierarchical |
bool |
|
ls_name |
VARCHAR(4000) |
|
ls_descr |
VARCHAR(4000) |
|
ls_bus_owner |
VARCHAR(32) |
|
ls_app_owner |
VARCHAR(32) |
|
ls_type |
VARCHAR(4000) |
|
ls_classification |
VARCHAR(4000) |
|
ls_location |
VARCHAR(4000) |
|
ls_environment |
VARCHAR(4000) |
|
ls_conn_ip |
VARCHAR(255) |
|
ls_conn_auth_id |
VARCHAR(255) |
|
ls_conn_port |
int4 |
|
ls_vendor |
VARCHAR(256) |
|
ls_version |
VARCHAR(128) |
|
ls_hierarchical |
bool |
|
idmrpt_deleted |
bool |
|
idmrpt_valid_from |
TIMESTAMP WITHOUT TIME ZONE |
|
idmrpt_syn_state |
int2 |