Dell NetWorker 19.9 Administration Guide

In the query, the attribute name (for example, 'type') is preceded by a period ('.'), and optionally followed by a colon (':') and a comma-separated list of values (for example, "host: mars";"job state: STARTED, ACTIVE, SESSION ACTIVE"). When a query consists of more than one attribute names, attributes are separated by a semi-colon (';'). When an attribute name is specified without values, any resource descriptor that contains this attribute is a match. If an attribute name is followed by one or more values, a resource whose value list matches at least one of the values for the specified attribute satisfies the criteria.

To launch the jobquery interface, type:

jobquery -s NetWorker_server

Where NetWorker_server is the hostname of the NetWorker Server. Use the -s option when you run the jobquery command from a NetWorker host that is not the NetWorker Server.

The jobquery -s<server> command connects to the specified NetWorker server and returns jobquery prompt. The data in the job database is queried with the following commands:

• types — a command that lists all job types currently known by nsrjobd that does not take any argument (for example, types return a list indicating Known types: save job, savegroup job, and so on).
• . — a command that sets the query criteria and is followed by one or more attribute names, or lists current query criteria when not followed by any attribute.

  Query criteria may contain several attributes, including job type, host, and job state, with each attribute separated by a semi-colon and each value separated by a comma, as in the following example:

  jobquery> . type: savegroup job; host: mars; job state: ACTIVE, COMPLETED

  This example would return information on all savegroup jobs from the host mars that are either in progress or in completed state.

• show — restricts the list of attributes that are returned for each resource descriptor that matches the query. For the above example, specifying the following:

  show name; job id; completion status; completion severity
  

  returns the names, job ids, completion status, and completion severity for all matched completed and active savegroups.

• print — runs the query and displays the results. If show list is in effect, each resource descriptor in the result list is restricted to desired attributes.
• all — returns all resource descriptors in the jobs database. If show list is in effect, result is restricted to desired attributes.
• help — displays help text.
• quit — exits jobquery.

Running jobquery -s NetWorker_server -i input_file reads input from the file for non-interactive usage. The man pages or the NetWorker Command Reference Guide provides detailed information about the jobquery program.