Service events are used in SLM analyses to comment or remove down events within given time intervals.
Service events can be added directly, or they can be exported from a associated calendar category.
Manually added service events are associated with metric instances using usm_link_service_event_metric_instance. Calendar exported service events are mapped to a report group(or contract) using usm_link_service_event
| Column Name | Column Datatype | Column Null Option | Column Comment |
| service_event_id | integer | not null | Unique identifier |
| description | nvarchar(255) | with null | Description of the service event |
| start_time | integer | with null | Epoch start time of the service event |
| stop_time | integer | with null | Epoch stop time of the service event |
| created | integer | with null | Time of creation in epoch |
| modified | integer | with null | Time when last modified, in epoch |
| category | integer | with null | 0 - Remove outage with comment - will not be used in r11 1- Comment only - previously provider responsible 3- Remove outage without comment - previously known as provider responsible |
| calendar_oid | varchar(20) | with null | Unique identity of the calendar |
| event_category_oid | varchar(20) | with null | Unique identity of the event category |
| calendar_category_oid | varchar(20) | with null | If this service event is exported from a calendar category, this points to the given calendar category. Is NULL if not. |
| onetime_event_oid | varchar(20) | with null | If the service event is exported from a calendar category and represents a onetime_event, this points to the given onetime event. |
| recurring_event_oid | varchar(20) | with null | If the service event is exported from a calendar category and is derived from a recurring event, this points to the recurring event. Otherwise it is NULL. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| service_event_id | usm_link_service_event_metric_in | service_event_id |