vovselect

Utility to query vovserver data.


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:
           KEY.<KEYNAME>       (metric objects)
           PARAM.<PARAMNAME>   (server object)
           PROP.<PROPNAME>     (all objects)
           RESOURCES.<RESNAME> (tasker 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