In each trend table there are the text fields (in addition to the five fields described in the previous section) that associate the data to an IT asset, and some numeric fields which are the trendable attributes–the data that is collected and saved, in other words. In one way trend tables are a subset of the corresponding tables which maintain the total, current asset data.
The following is an example trend table and its schema:
TABLE_NAME=TREND_VNB_JOB TXT_FLDS=VNB_JOB_NAME,Host NUM_FLDS=VNB_JOB_PERCENT_COMPLETE,VNB_JOB_FILES,VNB_JOB_KILOBYTES,VNB_JOB_TRY, ENABLE_TREND=1 DAILY_CONSOLIDATION=0
The table's name.
Note: These are the trend table names as you see in the Web Reporter Control Panel advanced settings dialog.
The text fields available in this table.
The numeric fields available in this table.
Identifies whether or not consolidation is enabled for this table. 0=disabled, and 1=enabled. By default this option is enabled for all tables.
Identifies if stage1 consolidation is enabled for the trend table. 0=disabled, and 1=enabled. By default this option is disabled for all tables.
The trend measurements are stored in the CA SRM Web Reporter central database repository which is the Microsoft SQL Server 2005. A new schema was created for the CA SRM Web Reporter trend consolidation data that is similar to the schema used by CA SRM. All of the consolidated trend data have a representation in the schema with the object name (or table name) prefixed by TREND_. For example, the trend information for the COMPUTER managed object is stored in a trend table TREND_COMPUTER.
|
Copyright © 2013 CA.
All rights reserved.
|
|