Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

Dell NetWorker 19.9 Administration Guide

Querying session information

Some actions, for example, backup, clone, and expiration actions create child actions to perform the tasks that are required to complete an action. NetWorker creates a session information record for each task that the child job starts. Use the jobquery command to view session information for the child action task. To view session information about an action task, the job id of the child job that created the save set is required.

To view session information for a child job, perform the following steps:

  1. Review the logs directory to determine the job id of the workflow. Policy log files provides more information about policy-related log files.
  2. Query the jobsdb for the workflow that contains the action.
  3. In the output, search for the parent action that started the child job and record the job id of the parent.
  4. In the output, search for the child action that contains the job id of the parent job id attribute, and record the value in the job id attribute of the child action.
  5. Query the jobsdb by using the child job id to display the session information that relates to the child task.

Viewing session information

In this example, the server backup workflow failed for a host at 7:54 PM on June 26. We want to review session information about the action tasks started by the server database backup and expiration actions.

  1. In the C:\Program Files\EMC NetWorker\nsr\logs\policy\Server Protection folder on Windows or the /nsr/logs/policy/Server Protection directory on LINUX, the workflow_Server backup_832001.raw file appears for the workflow. The job id of the server backup workflow is 832049.
  2. From a command prompt, start the jobquery program.
  3. Display information about the actions started by the server backup workflow .

    jobquery>print job id: 832049

    In this example, two action jobs created child jobs. The server database backup action created a child process for the nsrdbsave command and the expiration action created a utility job. Output for the bootstrap save job appears, as follows. The job id for the failed bootstrap backup action is 832050. The following example displays some of the attributes that appear in the print output.

                          type: bootstrap save job;
              
           canceled input count: 0;
      canceled input work items: ;      
                        command: nsrdbsave -l 1;
         completed output count: 3;
    completed output work items: 4253813558/1435241270, 4237036342/1435241270,
                                 4220259140/1435241284;
            completion severity: 10;
              completion status: succeeded;
    data protection policy name: Server Protection;          
             failed input count: 0;
        failed input work items: ;
                     file count: ;
           filtered input count: 0;
      filtered input work items: ;        
                     input flag: True;
                   input job id: ;
                         job id: 832050;
                   job log file: \
    C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Server Protection\\Serve\
    backup\\Server db backup_832050.raw";
                     job output:
                      job state: COMPLETED;
                          level: ;
                           name: nsrdbsave;                
            override parameters: ;              
                  parent job id: 832049;
             policy action name: Server db backup;
                previous job id: 0;  
             root parent job id: 832049;
            running input count: 0;
       running input work items: ;          
         successful input count: 2;
    successful input work items: bu-iddnwserver.iddlab.local,
                                 bu-iddsql.corp.com;          
            waiting input count: 0;
       waiting input work items: ;
                  workflow name: Server backup;

                           type: utility job;        
           canceled input count: 0;
      canceled input work items: ;    
                        command: nsrim -MXq;
         completed output count: 0;
    completed output work items: ;
            completion severity: 10;
              completion status: succeeded;
    data protection policy name: Server Protection;          
             failed input count: 0;
        failed input work items: ;
           filtered input count: 0;
      filtered input work items: ;
                     input flag: True;
                   input job id: 832050;
                         job id: 832057;
                   job log file: \
    C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Server Protection\\Serve\
    backup\\Expiration_832057.raw";
                     job output: \
    88411 1435241295 1 5 0 4996 1560 0 bu-iddnwserver.iddlab.local nsrim NSR noti\
    e 28 Checking for invalid volumes 0
    6069 1435241295 1 5 0 4996 1560 0 bu-iddnwserver.iddlab.local nsrim NSR notic\
    21 Processing %d clients 1 1 1 3
    6067 1435241295 1 5 0 4996 1560 0 bu-iddnwserver.iddlab.local nsrim NSR notic\
    37 Crosschecking indexes for %d clients. 1 1 1 1
    6068 1435241297 0 0 0 4996 1560 0 bu-iddnwserver.iddlab.local nsrim NSR info \
    0 Managing %d volumes. 1 1 1 4
    6073 1435241298 0 0 0 4996 1560 0 bu-iddnwserver.iddlab.local nsrim NSR info \
    ; Compressing media database. 0
                      job state: COMPLETED;
                           name: nsrim;                
            override parameters: ;
                    parallelism: 0;
                  parent job id: 832049;
             policy action name: Expiration;
                previous job id: 0;  
             root parent job id: 832049;
            running input count: 0;
       running input work items: ;          
         successful input count: 0;
    successful input work items: ;
                     waiting input count: 0;
       waiting input work items: ;
                  workflow name: Server backup;

  4. Display information about the failed bootstrap save job by specifying the job id, obtained from the bootstrap save job output .

    jobquery>print parent job id: 832050

    The jobquery program displays detailed information about the save jobs that are created by the job. The following example displays some of the attributes that appear in the print output.

      type: save job;
                actual exit code: 0;
                       adhoc job: False;
                        authtype: ;
                       automatic: False;
                   backup_device: ;
           Checkpoint restart ID: ;
    Checkpoint restart sequence: ;
                         command: \
    "save -q -e \"1 Months\" -b Default -J bu-iddnwserver.iddlab.local -a \"*polic\
    y name=Server Protection\" -a \"*policy workflow name=Server backup\" -a \"*po\
    licy action name=Server db backup\" -g \"Server Protection\" -l full -LL -LL -\
    S -f - -W 78 -N bootstrap \"C:\\\\Program Files\\\\EMC NetWorker\\\\nsr\\\\res\
    \" \"C:\\\\Program Files\\\\EMC NetWorker\\\\nsr\\\\mm\" \"C:\\\\Program Files\
    \\\\EMC NetWorker\\\\nsr\\\\authc-server\\\\tomcat\\\\data\"";
              completed savetime: 1435241284;
             completion severity: 10;
               completion status: succeeded;
                      data class: ;
                   Data set size: ;
                       data size: 255;
               dedupe sent bytes: ;
                dependent job id: 0;
                        end time: 1435241293;
                 estimated bytes: ;
                 exit code known: True;
                      file count: 185;
                    Files totals: 156, 114497;
         first_clone_id_for_ssid: ;
                      group name: ;
                            host: bu-iddnwserver.iddlab.local;
                  Inactive files: 0, 0, 0;
                      input flag: False;
                          job id: 832055;
                    job log file: \
    "C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Server Protection\\Serve\
    r backup\\Server db backup_832050_logs\\832055";
                      job output: ;
                       job state: COMPLETED;
                           level: ;
         mmdb-avamar-backup-time: ;
           mmdb-avamar-client-id: ;
              mmdb-avamar-server: ;
                            name: bootstrap backup;
                       ndmp flag: False;
         New data on De-Dup Node: ;
               NW Client name/id: ;
                   parent job id: 832050;
              policy action name: ;
                     policy name: ;
              policy_action_name: ;
                     policy_name: ;
                 previous job id: 0;
                primary_clone_id: ;
                 processed bytes: ;
                proxy agent name: ;
                proxy error code: ;
                  proxy_hostname: ;
       Reason job was terminated: ;
                  redirect stdio: True;
                 remote password: ;
                     remote user: SYSTEM;
            restricted data zone: ;
              root parent job id: 832049;
                 savegrp spawned: False;
                    saveset name: ;
                    saveset time: 1435241284;
                      saveset_id: ;
                  sibling job id: ;
                 snap session id: ;
                            SSID: ;
                      start time: 1435241283;
                 type attributes: ;
                    type classes: ;
                       type help: ;
                       type name: ;
                 type references: ;
                      type table: ;
                          userid: ;
                      vba_backup: ;
                        vba_name: ;
                vcenter_hostname: ;
                     vm guest os: ;
                         vm_name: ;
                         vm_uuid: ;

  5. Display session information for the save job by specifying the job id.

    jobquery>print jobid from session info: 832055

    The jobquery program displays detailed session information about the save job. For example, output similar to the following appears:

                   type: session info;
                     client name: bu-iddnwserver.iddlab.local;
                       completed: 1;
               compression ratio: 0;
                    current pool: Default;
        current read/write total: 254;
                   device family: disk;
                     Device path: aftd;
                     device type: adv_file;
            extended information: ;
         Jobid from session info: 832055;
          number of volumes used: 0;
              recover file count: 0;
              recover file total: 0;
            restricted data zone: ;
                  savegroup name: Server Protection;
                      saveset id: \
    7d52bfb9-00000006-fb8c0b44-558c0b44-00065000-7396bc56;
                    saveset name: bootstrap;
                Session end time: 1435241299;
                      session id: 18269;
                    Session mode: 0;
              Session start time: 1435241284;
    total amount to be read/written: 0;
            total volumes needed: 0;
                   transfer rate: 0;
                 type attributes: ;
                    type classes: ;
                       type help: ;
                       type name: ;
                 type references: ;
                      type table: ;
                     volume name: bu_iddnwserver.iddlab.local.002;


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\