For each profile, the aggregation import information is defined here.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique ID |
| domain | varchar(50) | with null | Domain |
| name | nvarchar(64) | with null | Descriptive name |
| table_name | varchar(32) | with null | Event table name |
| status | integer | with null | Process status: 0=pending, 1=processing, 2=processed, 3=error, 4=inactive |
| status_date | date | with null | Last status change |
| priority | integer | with null | priority |
| import_type | integer | with null | 0=event, 1=mr_result (not used) |
| build_expr | varchar(1024) | with null | sql to populate events/mr_result |
| user_text | nvarchar(128) | with null | Additional comments by user |
| table_id | integer | with null | mr_itable reference |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | usm_mr_ierror | ref_id |
| id | usm_mr_iref | id |