As described in SQL queries to filter vCOps alerts and events it is not possible to filter events and alarms by other things than the resource name column. It is also not possible to filter by alarm type or level.
Today a colleague has asked me how to optimize a PowerCLI query for virtual machines in a certain virtual datacenter. He want’s to avoid a expensive GET-VM query and he seeks a solution to do that with get-view.
Currently VMware does not provide a PowerCLI snapin to access the vCenter Operations API (the HttpPostAdapter). Clint Kitson and Alan Renouf have developed a Powershell Module to fill that gap.
With ESXTOP or the vCenter performance tab of a VM you can monitor the co-stop metric to check for vSMP performance problems. vCOps can show you that information for all the VMs on a host, a resource pool, a cluster, a vCenter or your complete environment.
In the current version of vCenter Operations it is not possible to filter events and alarms by the info column, but only by the resource name column. With SQL queries you can workaround that limitation.