5.6

Procedure
1 In a Web browser, type http:// ip_address /dbAccessQuery.action where ip_address is the IP address of
the vCenter Operations Manager server.
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.
emailFilter.xml File
emailFilter.xml is an XML file that defines the filtering rules and template files to use for email alert
notifications. The file also contains general settings that apply to all email alert notifications.
IMPORTANT Do not edit emailFilter.xml directly unless you are familiar with XML structure and syntax. A
formatting mistake might prevent email alert notifications from working. If you edit emailFilter.xml directly,
make a backup copy of the file before you change it.
After you edit the emailFilter.xml file, you must restart the email filter plug-in instance in
vCenter Operations Manager to make your changes take effect.
Sample emailFilter.xml File
This sample emailFilter.xml file shows the entire content of emailFilter.xml contained within the
<EmailFilter> and </EmailFilter> tags. None of the entries are case-sensitive.
<EmailFilter >
<Templates>
<Template alert_type="Administrative" alert_subtype="Environment"
status="New">New-Administrative-Environment.html</Template>
<Template alert_type="Administrative" alert_subtype="Environment"
status="Cancel">Cancel-Administrative-Environment.html</Template>
<Template alert_type="Administrative" alert_subtype="System"
status="New">New-Administrative-System.html</Template>
<Template alert_type="Administrative" alert_subtype="System"
status="Cancel">Cancel-Administrative-System.html</Template>
...
</Templates>
<SendFromEmail>[e-mail]</SendFromEmail>
<FilterRule name="WebTierAlerts">
<Conditions>
<condition type="Application">Online Trading</condition>
<condition type="Tier">Online Trading:Web</condition>
<condition type="Tier">Online Trading:Web</condition>
VMware vCenter Operations Manager Administration Guide
92 VMware, Inc.