This table is used to record events that occur within Unicenter Patch Management during the lifecycle of a patch. Examples: file downloads, user approvals, deployment results, errors.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| event_uuid | byte(16) | not null | The uuid of the event as assigned by UPM when the event is recorded. |
| object_uuid | byte(16) | with null | The uuid of the object associated with the event. See object_type. |
| generated_by | nvarchar(64) | with null | The name of the UPM component which generated the event. |
| type | smallint | with null | "The type of event
1 = debugging
2 = informational
3 = warning
4 = error
5 = fatal error
" |
| message | nvarchar(512) | with null | The text of the message associated with the event. |
| status | integer1 | with null | "The status of the event 1 = Posted 2 = Acknowledged " |
| when_posted | integer | with null | The date/time the event was posted. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| when_ack | integer | with null | The date/time the event was acknowledged by the user in the UPM application. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| ack_by | byte(16) | with null | The uuid of the user who acknowledged the event. |
| object_type | integer1 | with null | "The type of the object associated with the event. (See object_uuid.) 1 = Software (ca_software_def) 2 = Install package (ca_install_package) 3 = Baseline (upm_baseline) 4 = Download Queue Entry (upm_download) 5 = Download File (ca_download_file) " |
Product Name: Unicenter Patch Management
Table Type: Table