Query the vovserver

The vovselect command provides a way to retrieve specific data from the vovserver, with filtering done on the server side. This method is differs from some of the VTK calls, which get all data and require processing on the client side to get the data of interest.

Many types of objects in the vovserver may be queried. See the help information below for the supported objects.
Note: vovselect supports the "*" wildcard to signify all fields of a particular object. Be sure to quote the * character as required by your shell, e.g.: vovselect '*' from jobs where idint==12345
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> (slave objects)

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

Use vovselect for Querying

The nc hosts command can be used for querying, but it can sometimes take several minutes to return results, which causes some nodes to show up as "N/A". nc hosts will query the server and return significant amounts of data, but the server loading will directly affect the response time of the command.

In order to avoid such delay, you can use vovselect to run the query, as it prefilters the output server-side before returning it to the client.

Use the table below to understand the mapping of fields between the nc hosts and vovselect commands.

nc hosts vovselect from TASKERS vovselect from HOSTS
ARCH ARCH ARCH
CAPABILITIES CAPABILITIES NA
CAPACITY CAPACITY CPUS
CLASSRESOURCES CLASSRESOURCES NA
CLOCK CLOCK CPUCLOCK
COEFF COEFF NA
CONSUMABLES CONSUMABLES NA
CORES CORESAVAIL NA
CORESAVAIL CORESAVAIL NA
CORESTOTAL CORESTOTAL CPUS
CORESUSED CORESUSED NA
CPUS CPUS CPUS
CURLOAD CURLOAD NA
DOEXEC DOEXEC NA
DONETINFO DONETINFO NA
DOPROCINFO DOPROCINFO NA
DORTTRACING DORTTRACING NA
EFFLOAD NA NA
EXTRAS EXTRAS NA
FULLINFO FULLINFO NA
GROUP GROUP NA
HB NA NA
HBPP NA NA
HEARTBEAT HEARTBEAT NA
HOST HOST NAME
ID ID NA
IDINT IDINT NA
LASTJOBID NA NA
LASTUPDATE LASTUPDATE NA
LIFETIMEJOBS LIFETIMEJOBS NA
LOAD1 NA NA
LOAD15 NA NA
LOAD5 NA NA
LOADEFF NA NA
MACHINE MACHINE MACHINE
MANUALPOWER NA NA
MAXLOAD MAXLOAD NA
MESSAGE MESSAGE NA
MESSAGESYS MESSAGESYS NA
MESSAGEUSER MESSAGEUSER NA
MODEL MODEL NA
NAME NAME NAME
NUMJOBS NA NA
OSCLASS OSCLASS NA
PERCENT PERCENT NA
PERSISTENT PERSISTENT NA
PID PID NA
POWER POWER NA
RAM RAM NA
RAMFREE RAMFREE NA
RAMTOTAL RAMTOTAL RAMTOTAL
RAWPOWER NA NA
RELEASE RELEASE NA
RESERVEDBY RESERVEDBY NA
RESERVEEND RESERVEEND NA
RESERVEFORBUCKETID RESERVEFORBUCKETID NA
RESERVEFORID RESERVEFORID NA
RESERVEGROUP RESERVEGROUP NA
RESERVEJOBCLASS RESERVEJOBCLASS NA
RESERVEJOBPROJ RESERVEJOBPROJ NA
RESERVEOSGROUP RESERVEOSGROUP NA
RESERVESTART RESERVESTART NA
RESERVEUSER RESERVEUSER NA
RESOURCECMD RESOURCECMD NA
RESOURCES NA NA
RESOURCESEXTRA NA NA
RESOURCESPEC RESOURCESPEC NA
RUNNINGJOBS RUNNINGJOBS NA
SLOTS NA NA
SLOTSTOTAL SLOTSTOTAL NA
STATSREJECTCORES STATSREJECTCORES NA
STATSREJECTOTHER STATSREJECTOTHER NA
STATSREJECTRAM STATSREJECTRAM NA
STATSREJECTRESERVED STATSREJECTRESERVED NA
STATSREJECTSLOTS STATSREJECTSLOTS NA
STATSVISITS NA NA
STATUS NA NA
SWAP SWAP NA
SWAPFREE SWAPFREE NA
SWAPTOTAL SWAPTOTAL NA
TASKERGROUP TASKER NA
TASKERNAME TASKERNAME NAME
TASKERSLOTSSUSPENDABLE TASKERSLOTSSUSPENDABLE NA
TASKERSLOTSSUSPENDED TASKERSLOTSSUSPENDED NA
TASKERSLOTSUSED TASKERSLOTSUSED NA
TASKERTYPE TASKERTYPE NA
TIMELEFT TIMELEFT NA
TMP TMP NA
TYPE TYPE NA
UPTIME NA NA
UPTIMEPP UPTIMEPP NA
USER USER NA
VERSION VERSION NA
VOVVERSION VOVVERSION NA