Table to store every machine for which Performance Data was collected. One row for every machine. Table can be populated by Performance Domain Server or by the pdtodb utility.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| machine_id | integer | not null | Machine identifier |
| machine_name | nvarchar(64) | not null | Machine name |
| systype_name | nvarchar(64) | not null | System Type Name as stored in a Performance Cube (example: nts400i refers to NT 4 OS). |
| is_this_cluster | integer1 | not null | Flag to identify if the machine is a cluster. By default, this is 0. It needs to be set to 1 for a cluster. Cluster creation is user defined. |
| asset_id | byte(16) | not null | Asset identifier. Maps to MDB asset. |
Product Name: Unicenter Network and System Management/System Performance
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| machine_id | pd_machine_ext | machine_id |
| machine_id | pd_cluster_ext | machine_id |
| machine_id | pd_cluster_def | parent_id |
| machine_id | pd_cluster_def | parent_id |
| machine_id | pd_val_8hr | machine_id |
| machine_id | pd_val_6hr | machine_id |
| machine_id | pd_val_5min | machine_id |
| machine_id | pd_val_4hr | machine_id |
| machine_id | pd_val_1min | machine_id |
| machine_id | pd_val_1hr | machine_id |
| machine_id | pd_val_1day | machine_id |
| machine_id | pd_val_15min | machine_id |
| machine_id | pd_val_12hr | machine_id |
| machine_id | pd_val_10min | machine_id |
| machine_id | pd_val_3hr | machine_id |
| machine_id | pd_val_30min | machine_id |
| machine_id | pd_val_2hr | machine_id |
| machine_id | pd_val_20min | machine_id |
| machine_id | pd_val_1year | machine_id |
| machine_id | pd_val_1week | machine_id |
| machine_id | pd_val_1month | machine_id |