5.7

Retrieve Keys and Identifiers from the Database
You can obtain keys and identifiers to use in a metric set definition XML by accessing the
vCenter Operations Manager database and running SQL queries.
Procedure
1
In a Web browser, type http:// ip_address /dbAccessQuery.action where ip_address is the IP address of
the host of the vCenter Operations Manager database.
2 Type your SQL query in the top right window.
For example:
select a.ADAPTER_KIND_ID, a.ADAPTER_KEY, b.RESKND_ID, b.RESKND_KEY, e.ATTRKEY_ID, e.ATTR_KEY
from AdapterKind a
inner join ResourceKind b on (b.ADAPTER_KIND_ID = a.ADAPTER_KIND_ID)
inner join AliveResource c on (c.RESKND_ID = b.RESKND_ID)
inner join ResourceAttributeKey d on (d.RESOURCE_ID = c.RESOURCE_ID)
inner join AttributeKey e on (e.ATTRKEY_ID = d.ATTRKEY_ID)
where a.ADAPTER_KEY = 'something' or b.RESKND_KEY = 'something'
3 Click the Execute SQL icon.
The results appear in the lower right window.
VMware vCenter Operations Manager Getting Started Guide
106 VMware, Inc.