My webMethods Server 10.5 | My webMethods Server Webhelp | Administering My webMethods Server | System Administrator Functions | Analysis, Reporting, and Troubleshooting | Collecting Data About Server Events | Events Collector Database Schema
 
Events Collector Database Schema
The Events Collector page uses the following database schema.
tblwEvents (main table where events data is being collected)
  idEvent    - Primary key
  idType     - Foreign key to tblwEventTypes. Stores the type
                  of an event.
  idHost     - Foreign key to tblwEventHosts. Stores the host
                  where the event occurs.
  timestamp  - Time stamp of an event, defined as the number of
                  milliseconds since epoch(java.lang.System.
                  currentDateMillis()).
  userID     - Database ID of the user who performed an operation.
  thingID_1  - object_1. For example, for Get type events this is
                  the database ID of the object being viewed.
  thingID_2  - object_2. Used in rare cases where two objects are
                  involved, for example when an object is created.
                  Then object_1 is the database ID of the container,
                  and object_2 is the database ID of an object that
                  was created.
  action     - Used for Login events: 1 - user logged in, 2 - user
                  logged out.
tblwEventHosts (stores mapping between hostID and hostname)
  idHost     - Host id.
  hostname   - Actual host name where the event occurs.
tblwEventTypes (stores mapping between eventID and eventTypeName)
  idType     - Event type ID.
 eventType   - Event type name.
Possible eventType name values:
com.webmethods.portal.event.add.impl.CreateEvent
    - New object is created.
com.webmethods.portal.event.impl.GetEvent
    - Object is being browsed.
com.webmethods.portal.event.system.impl.LoginEvent
    - User logs in/out.
com.webmethods.portal.event.modify.impl.UpdateEvent
    - Object is updated.
com.webmethods.portal.event.remove.impl.DeleteEvent
    - Object is deleted.