vovselect

vovselect: Usage Message

    Utility to query vovserver data.

    USAGE:

      vovselect <FIELDSPEC> from <OBJECT> [OPTIONS]

    OPTIONS:

      -h               -- Show usage syntax.
      -v               -- Increase verbosity.
      -where <FILTER>  -- Filter the results.
      -order <COLUMN> [ORDER]  -- Sort the output by the specified column
                                    and ordering. Ordering is either "asc"
                                    (ascending)  or "desc" (descending).
                                    Default ordering is ascending.  When
                                    specifying an ordering, place the column
                                    and ordering in quotes, e.g.
                                    -order 'name desc'.
      -limit <N>       -- Limit the output to N rows.
      -distinct        -- Return distinct rows.

      -header          -- Displays column headers in the output.
      -cache 0/1       -- Control cacheing of query (default is 1).
                          Tech Note: use cache 0 for small results
                          (less than a few thousand rows)

      If option values contain shell-sensitive characters, such as ">",
      enclose them with single quotes (Linux) or double quotes (Windows).

      The from parameter will accept queryable object names (as listed by
      "vovselect objectname from objects"), individual object identifiers
      (as listed by "vovselect idint from <object>"), or set names
      (as listed by "vovselect name from sets").  This parameter can also
      accept the following:
         SUBSETS.<SETID>
         MATCHES.<RESMAPID>
         MATCHES.<RESMAPNAME>

    SUPPORTED OBJECTS:
      Run "vovselect objectname from objects" to see
      the list of queryable objects.

    SUPPORTED FIELDS:

      Run "vovselect fieldname,fieldtype from <object>" to see the list of
      fields for that object. To see a list of fields with descriptions run,
      "vovselect fieldname,fielddesc from <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:
         GRABBEDRESOURCES.<RESNAME>     (job objects)
         KEY.<KEYNAME>                  (metric objects)
         PARAM.<PARAMNAME>              (server object)
         PROP.<PROPNAME>                (all objects)
         RESOURCES.<RESNAME>            (tasker & job objects)
         SOLUTION.<RESNAME>             (job objects)

    SUPPORTED FILTERS:

      Use selection rule operators in conjunction with field names to filter
      queries. See operator list at URL/doc/html/vov/topics/vov/operators.htm
      via web browser. To get the current the URL for current instance, 
      execute the vovbrowser command.

    EXAMPLES:

      % vovselect -h
      % vovselect objectname from objects
      % vovselect fieldname from server
      % vovselect id,name from users -order name -limit 10 -header
      % vovselect id,name from users -where 'name==joe'
      % vovselect id,name from 12345
      % vovselect id,name from subsets.23456
      % vovselect matchtype,host from matches.License:spice
      % vovselect idint,name from users -where 'idint>3600'
                  -order 'idint desc'
      % vovselect id,age from System:running
      % vovselect id,age -from System:running -cache 0