Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# system_event

The `system_event` table contains information about system events.

## Structure

The `system_event` table has the following structure:

      TABLE system_event    type_idnumber(5)NOT NULL, user_namevarchar(255)NOT NULL, audit_datedate NOT NULL, audit_usecsnumber(6)NOT NULL, details varchar(512)NOT NULL,

Column | Description
``type_id`` | IID of an audit event. It is defined in the `SWDIR\etc\language.lng\sysevents.cfg` file.
``user_name`` | Name of the user who performed the audit event, as defined in the `user_names` table.
``audit_date`` | Date and time when the event occurred. Note: The audit_usecs column can be combined with this column to provide resolution to a microsecond.
`audit_usecs` | Number of microseconds since the start of the seconds value specified in the audit_date column.
``details`` | Extra details of the event.

## Primary Key

None.

## Foreign Keys

None.

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
idx_sys_event_fk | type_id user_name audit_date

## Table Activity

The `system_event` table contains one row for each system event that is audited.

Rows are added and deleted in the following situations:

A row is... | When...
added | a new system event is audited.
deleted | using the `swadm delete_system_event` command to delete system event information or clean system event information that is earlier than a specified period. See TIBCO iProcess Engine Administrator’s Guide for more information about the `swadm delete_system_event` command.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine