5.7

Table Of Contents
The first set of values defines the columns in the output database. You change TestTable to the name of your
output table. The second set of values, which appears after values in the statement, defines the source fields
in the vCenter Operations Manager data model to export to the output database columns.
Source Fields
The sample conf.properties file includes all of the possible source fields. You can change the order of the
source fields or remove fields, but you cannot add source fields. If you change the source fields, you must also
change the output column list.
Field names that start with alive are from the vCenter Operations Manager relational database.
Table 11-1. Relational Database Fields
Field Description
alive.RID
Resource ID.
alive.RNAME
Resource name.
alive.MID
Metric ID.
alive.MNAME
Metric key, hierarchical format, including group keys, instance names, and attribute kind
keys. For example, cpu:0|utilization_pct.
alive.RKNAME
Resource kind key.
alive.MKNAME
Attribute kind key, one level (the last item in the metric key).
alive.AKNAME
Adapter kind key.
Field names that start with fsdb are from the vCenter Operations Manager FSDB.
Table 11-2. FSDB Fields
Field Description
fsdb.timestamp
Metric time stamp.
fsdb.min_threshold
Minimum threshold for the metric.
fsdb.value
Metric value.
fsdb.max_threshold
Maximum threshold for the metric.
insertCommand Statement Example
The following insertCommand statement exports the alive.RID field from the vCenter Operations Manager
relational database to the RID1 column of the output database and the alive.RNAME field from the
vCenter Operations Manager relational database to the RNAME1 column of the output database.
insertCommand=INSERT INTO TestTable (RID1; RNAME1) values(alive.RID; alive.RNAME)
Configure Data Export Values for the Repository Adapter
You can use the conditions.properties file to filter the resources and metrics for which the Repository adapter
exports values. If you do not use the conditions.properties file, the Repository adapter exports all data.
The conditions.properties file can contain multiple conditions. Each condition specifies the name of an output
column in the destination database or CSV file and one or more values.
VMware vCenter Operations Manager Administration Guide
142 VMware, Inc.