hist_report

This table contains historical report for the utilization of AEC rules and Message Records/Message Actions, which can be used by customers and Level2 supports to monitor how efficiently an AEC rule or a Message Action is being utilized. The historical reporting for AEC is also used for other purpose: 1.Historical Audit Trail - for example, if I didn't page for a database outage last night, I can find out the next morning why AEC didn't generate the correlation message that should have paged me. 2.Real-time Feedback - near real-time feedback of what the engine is processing. 3.Rule Analysis - Customer can fine tune their maturity and reset intervals using this data. No primary key is assigned yet to this table.

Column Name Column Datatype Column Null Option Column Comment
policyname varchar(50) with null Physical name of the rule file used by the AEC
rulename varchar(25) with null Rule name used in the MDB record
ruledesc varchar(255) with null Description of the rule
ruleuuid char(128) with null Unique id number for rule
ruletype char(15) with null Idenitifies which type of AEC rule PIPELINE, BOOLEAN etc
istemplate char(15) with null Yes/no to indicate if it is a template or not
pipename varchar(25) with null Pileline item name
pipeuuid char(128) with null Unique ID of the pipeline item
aecaction varchar(50) with null AEC action description used for tracing AEC Engine. Possible values are as follows: - Rule TRIGGER(Pipelineitem TRIGGER) - Pipelineitem MATCH - Maturity Interval Expired(30) - Reset Interval Expired(10) - Maturity Interval Overridden - CorrelationEvent Generated - CorrelationEvent Generated As ALERT - ImpactEvent Generated - ResetEvent Generated - ResetRequestEvent Received - ResetRequestAck Generated - Threshold Counter Decremented - Threshold Counter Incremented - ACEReload - ACE Init - ACE Term - ACE Suspend - ACE Resume
log_date char(10) with null Log date that message action got triggered
log_time char(8) with null Log time that message action get triggered
node varchar(64) with null Node where the action originated

Product Name: Unicenter Desktop and Server Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.