5.8.5

Example: Defining a Metric Set for the Generic Scoreboard Widget
This metric set definition XML file defines a metric set for the Generic Scoreboard widget.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<AdapterKinds>
<AdapterKind adapterKindKey="VMWARE">
<ResourceKind resourceKindKey="HostSystem">
<Metric attrkey="badge|workload" label="Workload" unit="%" yellow="50" orange="60"
red="80" />
<Metric attrkey="men|host_usage" label="Host Usage" unit="%" yellow="50" orange="60"
red="80" />
<Metric attrkey="cpu|usage_average" label="Usage Avg" unit="%" yellow="50" orange="60"
red="80" />
</ResourceKind>
</AdapterKind>
</AdapterKinds>
If you select this metric set definition XML file from the Res. Interaction Mode menu when you edit the
Generic Scoreboard widget, the widget draws the Workload, Host Usage, and Usage Avg metrics for host
system resources.
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
114 VMware, Inc.