Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Archive > 2017December14 - Deletes > EOC - Gathering Events from Database

EOC - Gathering Events from Database

Table of contents
Created by Robert Stidman, last modified by Jessica Solis on Dec 14, 2017

Views: 30 Votes: 0 Revisions: 6

Note: This article is designed to guide the process of collecting information from a database, but does not substitute for strong SQL knowledge. This article should be limited to SQL DBA's.

Overview

The Enterprise Operations Console does not have a reporting capability in 1.x versions. If the events EOC has gathered from the monitored Orion system need to be harvested, the database administrator will need to collect the information directly from the database. 

Environment

  • EOC version 1.x

Steps

  1. Run the query below in SQL Management Studio against that database:
    select * from eoc.event
  2. This will show all the events that EOC has gathered from all Orion modules. The database table has the fields below:
    OrionID The ID number of the Orion server being monitored that sent the event message.
    EventID The ID number of the event for EOC reference purposes.
    EventTime The time the event occurs. Generated from the Orion database.
    NetworkNode The node the event happened against on the monitored Orion database.
    NetObjectID The NodeID from the Orion database.
    EventType Corresponding event descriptions contained in the eoc.eventtype table. Represented as an ID number.
    Message The message received from the event.
    Acknowledged If the event message was acknowledged on the system it came from.
    EngineID The ID number of the engine a node was using during its setup on Orion.
    NetObjectType The node / interface / application / etc type.
    TimeStamp An arcane field that is populated with a time stamp.

A query, such as: select * from eoc.event where orionid=1, will collect all events from the Orion module that has ID number: 1. The Orion module and their corresponding IDs are in the eoc.orion database table.

 

 

 

Last modified

Tags

Classifications

Public