5.7
Table Of Contents
- VMware vCenter Operations Manager Administration Guide
- Contents
- VMware vCenter Operations Manager Administration Guide
- Configuring and Managing vCenter Operations Manager
- Configuring Adapters
- Configuring Resources
- Configuring Attribute Packages
- Configuring Applications
- Configuring and Managing Users
- Configuring Alert Notifications
- Performing Basic System Administration Tasks
- View Performance Information
- View Status Information
- vCenter Operations Manager Service Names
- Start or Stop vCenter Operations Manager Services
- Viewing and Managing System Log Files
- Delete Old Data in the File System Database
- Run the Audit Report
- Modify Global Settings
- Modify Global Settings for Virtual Environments
- Create a Support Bundle
- Resolving Administrative System Alerts
- Analytics FSDB Overloaded
- Analytics Threshold Checking Overloaded
- Collector Is Down
- Controller Is Unable to Connect to MQ
- DataQueue Is Filling Up
- Describe Failed
- Failed to Connect to Replication MQ
- Failed to Repair Corrupted FSDB Files
- File Queue Is Full
- FSDB Files Corrupted for Resources
- FSDB Storage Drive Free Space Is Less Than 10%
- No DT Processors Connected
- One or More Resources Were Not Started
- Outbound Alert Send Failed
- Replication MQ Sender Is Blocked
- Backing Up and Recovering Data
- Backing Up and Recovering Data Components
- Backing Up and Recovering Processing Components
- Configuring the Repository Adapter
- Repository Adapter Requirements and Limitations
- Repository Adapter Configuration Steps
- Creating a Database User for the Repository Adapter
- Configure the Source Database Connection for the Repository Adapter
- Configure the Output Destination for the Repository Adapter
- Configuring the Source and Destination Columns for the Repository Adapter
- Configure Data Export Values for the Repository Adapter
- Customizing Repository Adapter Operation
- Start the Repository Adapter
- Using System Tools
- Using the Database Command Line Interface
- Index
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.