Using vovselect

You can also query the metrics using vovselect.

% vovselect id,name from metrics
...this returns id and name of  all metrics
% vovselect id,name from metrics where name~/ram/
id      name
000113670       scheduler/ram/available
000113671       scheduler/ram/capacity
000113672       scheduler/ram/inuse
If you want to access a property of a wave (reminder: a property is computed from the metric name, which may consist of components of the form PROPERTY=VALUE), use the field 'PROP.<propertyName>' as in this example:
% vovselect id,name,prop.user from metrics where prop.site==US
000150881       site=US/user=john/res=abc/m     john
000150882       site=IN/user=john/res=abc/m     john
Run vovselect fieldname,fieldtype from <object> to see the list of fields for that object. Multiple fields may be requested by separating them with a comma. Some fields represent a data collection that can be broken down using a format of FIELD.X, such as:
KEY.<KEYNAME>       (metric objects)
PARAM.<PARAMNAME>   (server object)
PROP.<PROPNAME>     (all objects)
RESOURCES.<RESNAME> (tasker objects)

To find the fields that are accessible for metrics, you can use this command:

Usage: 'vovselect fieldname from metrics'
AGE
AGEPP
FAMILY
FIRSTTS
ID
IDINT
KEY
LASTACCESS
LASTDATA
LASTLABEL
LASTTS
LASTUPDATE
MEMORY
NAME
POINTS
PROP
PROPDUMP
PROPERTIES
ROWCOUNT
TAIL
UNITS