Every CA SRM Web Reporter consolidated trend object schema is in synchronization with its corresponding schema on the CA SRM side. Apart from the data attributes or parameters, there are five columns that are present in each table:
|
Field Name |
Field Type |
Description |
|---|---|---|
|
Host |
Char (255) not null |
The hostname/IP Address of the source CA SRM server. |
|
TrendType |
*Char (3) null allowed |
Identifies the type of the data point. The possible values of this field can be A/N/X or blank - representing a consolidated data point like Average, Minimum, and Maximum or an unconsolidated data point. |
|
CreationData |
*Char (255) null allowed |
This is the date (incorrectly spelt attribute name in SRM). This represents the time when the consolidation service created the record. |
|
HostTime |
Datetime null allowed |
The time the data point was collected. If the data point is a consolidated data point, then a mid-value is calculated and set for that consolidation region. |
*Note: Some of the fields have char (255) to maintain consistency with the schema on the CA SRM side.
|
Copyright © 2013 CA.
All rights reserved.
|
|