Introduction

The JOC Cockpit Operation Script offered for Unix Shell can be applied to perform frequently used status operations on JOC Cockpit.

JOC Cockpit Operation Script


The script is offered for download and can be applied for frequently used operations:

  • The script is available for Linux and MacOS® using bash shell.
  • The script terminates with exit code 0 to signal successful execution, with exit code 1 for command line argument errors and with exit code 4 for non-recoverable errors. Exit code 3 signals that no matching objects have been found.
  • The script is intended as a baseline example for customization by JS7 users and by SOS within the scope of professional services. Examples make use of JS7 Release 2.7.2, bash 4.2, curl 7.29.0 and jq 1.6.0.

Prerequisites

The Script requires the curl utility and the jq utility to be available from the operating system. 

jq ships with the MIT license, see https://opensource.org/licenses/MIT.

Download

Download: JS7 - Download (Section: Unix Shell ClI)

Usage

Invoking the script without arguments displays the usage clause:


Usage
Usage: operate-joc.sh [Command] [Options] [Switches]

  Commands:
    status                 --controller-id
    status-agent           --controller-id  [--agent-id] [--agent-state] [--agent-cluster] [--no-hidden]
    health-check           --controller-id  [--agent-id] [--agent-state] [--agent-cluster] [--no-hidden] [--whatif-shutdown]
    version               [--controller-id] [--agent-id] [--json]
    switch-over            --controller-id
    restart-service       [--service-type]  [--proxies]
    run-service            --service-type
    check-license         [--validity-days]
    get-settings
    store-settings         --settings
    report-*              [--controller-id] [--workflow] [--folder] [--recursive] [--date-from] [--date-to] [--state] [--tag] [--order-tag] [--csv]
    report-daily-plan     [--order-id] [--schedule] [--schedule-folder] [--late]
    report-order-history  [--order-id] [--time-zone] [--date-from-completed] [--date-to-completed] [--limit]
    report-task-history   [--job]      [--time-zone] [--date-from-completed] [--date-to-completed] [--limit] [--criticality]
    encrypt                --in [--infile --outfile] --cert [--java-home] [--java-lib]
    decrypt                --in [--infile --outfile] --key [--key-password] [--java-home] [--java-lib]

  Options:
    --url=<url>                        | required: JOC Cockpit URL
    --user=<account>                   | required: JOC Cockpit user account
    --password=<password>              | optional: JOC Cockpit password
    --ca-cert=<path>                   | optional: path to CA Certificate used for JOC Cockpit login
    --client-cert=<path>               | optional: path to Client Certificate used for login
    --client-key=<path>                | optional: path to Client Key used for login
    --timeout=<seconds>                | optional: timeout for request, default: 60
    --controller-id=<id>               | optional: Controller ID
    --agent-id=<id[,id]>               | optional: Agent ID
    --agent-state=<state[,state]>      | optional: Agent state filters such as
                                                   COUPLED, RESETTING, RESET, INITIALISED, COUPLINGFAILED, SHUTDOWN
    --service-type=<identifier>        | optional: service for restart such as cluster, history, dailyplan, cleanup, monitor
    --validity-days=<number>           | optional: min. number of days for which a license should be valid, default: 60
    --settings=<json>                  | optional: settings to be stored from JSON
    --whatif-shutdown=<host[,host]>    | optional: health status if hosts will be shutdown
    --order-id=<id[,id]>               | optional: list of Order IDs
    --order-tag=<name[,name]>          | optional: list of order tags
    --workflow=<name[,name]>           | optional: list of workflow names
    --folder=<path[,path]>             | optional: list of workflow folder paths
    --schedule=<name[,name]>           | optional: list of schedule names
    --schedule-folder=<path[,path]>    | optional: list of schedule folder paths
    --tag=<name[,name]>                | optional: list of workflow tags
    --limit=<number>                   | optional: limit the number of orders returned
    --job=<name>                       | optional: job name
    --criticality=<name[,name]>        | optional: job criticality: minor, normal, major, critical
    --date-from=<date>                 | optional: date from which to select orders
    --date-to=<date>                   | optional: date until which to select orders
    --date-from-completed=<date>       | optional: earliest order completion date
    --date-to-completed=<date>         | optional: latest order completion date
    --time-zone=<identifier>           | optional: time zone for date specification
    --state=<state[,state]>            | optional: order state for history commands
                                                   report-daily-plan:    PLANNED, SUBMITTED, FINISHED
                                                   report-order-history: SUCCESSFUL, FAILED, INCOMPLETE
                                                   report-task-history:  SUCCESSFUL, FAILED, INCOMPLETE
    --key=<path>                       | optional: path to private key file in PEM format
    --key-password=<password>          | optional: password for private key file
    --cert=<path>                      | optional: path to certificate file in PEM format
    --in=<string>                      | optional: input string for encryption/decryption
    --infile=<path>                    | optional: input file for encryption/decryption
    --outfile=<path>                   | optional: output file for encryption/decryption
    --java-home=<directory>            | optional: Java Home directory for encryption/decryption, default: $JAVA_HOME
    --java-lib=<directory>             | optional: Java library directory for encryption/decryption, default: ./lib
    --audit-message=<string>           | optional: audit log message
    --audit-time-spent=<number>        | optional: audit log time spent in minutes
    --audit-link=<url>                 | optional: audit log link
    --log-dir=<directory>              | optional: path to directory holding the script's log files

  Switches:
    -h | --help                        | displays usage
    -v | --verbose                     | displays verbose output, repeat to increase verbosity
    -p | --password                    | asks for password
    -k | --key-password                | asks for key password
    -x | --proxies                     | specifies proxy services for restart
    -c | --csv                         | converts JSON output of history commands to CSV
    -j | --json                        | returns version information in JSON format
    -l | --late                        | includes late orders
    -r | --recursive                   | includes sub-folders recursively
    --agent-cluster                    | filters non-clustered Agents
    --no-hidden                        | filters hidden Agents
    --show-logs                        | shows log output if --log-dir is used
    --make-dirs                        | creates directories if they do not exist

Commands

  • status
    • Returns status information about JOC Cockpit & Controller instances and database indicated by a textual status and severity, for details see JS7 - Dashboard. The textual status explains the status type, the severity indicates if this is considered normal behavior as for green (0), yellow (1) or a problem as with red (2, 3).


      JOC Cockpit StatusTextSeverity
      JOC Cockpit Cluster Statusactivegreen (0)

      inactiveyellow (1)

      unknownred (3)



      Controller StatusTextSeverity
      Controller Cluster Statuscoupledgreen (0)

      unknownred (3)
      Controller Cluster Node Statusactivegreen (0)

      inactiveyellow (1)

      unknownred (3)
       Controller Component Statusoperationalgreen (0)

      limitedyellow (1)

      inoperablered (2)

      unknownred (3)
      Controller Connection Statusestablishedgreen (0)

      unstableyellow (1)

      unreachablered (2)

      unknownred (3)



      Database StatusTextSeverity
      Database Component Statusoperationalgreen (0)

      unknownred (3)
      Database Connection Statusestablishedgreen (0)

      unstableyellow (1)

      unreachablered (2)

      unknownred (3)
  • status-agent
    • Returns status information about Agent instances indicated by a textual status and severity, for details see JS7 - Dashboard. The textual status explains the status type, the severity indicates if this is considered normal behavior as for green (0), yellow (1) or a problem as with red (2, 3).


      Agent StatusTextSeverity
      Agent Cluster Statusactivegreen (0)

      inactiveyellow (1)

      unknownred (3)
      Agent Component Statuscoupledgreen (0)

      resettingyellow (1)

      resetyellow (1)

      initialisedyellow (1)

      couplingfailedred (2)

      shutdownred (2)

      unknownred (3)
  • health-check
    • Performs a health check and returns status information for each JOC Cockpit, Controller and Agent instances.
      • When used with the --agent-id option, filters the indicated. Agents. More than one Agent ID can be specified separated by comma, for example: --agent-id=agent1,agent2.
      • When used with the --agent-state option, allows to filter Agents by state.: COUPLED, RESETTING, RESET, INITIALISED, COUPLINGFAILED, SHUTDOWN, UNKNOWN. More than one Agent state can be specified separated by comma, for example: --agent-state=COUPLED,COUPLINGFAILED.
      • When used with the --agent-cluster switch, limits the scope to clustered Agents.
      • When used with the --no-hidden switch, limits the scope to Agents that are not hidden.
      • The health check will return exit code 0 for a healthy environment and exit 2 for an unhealthy envirornment.
    • Checks the scenario of host shutdown when used with the --whatif-shutdown option. The option takes a hostname. More than one hostname can be specified separated by comma, for example: --whatif-shutdown=host1.example.com,host2.example.com. The check implies verifying if the JS7 scheduling environment will remain operational in case that the given host or hosts will be shut down.
  • version
    • Returns version information of JOC Cockpit, Controller and Agents.
      • When used without options, the JOC Cockpit version will be returned.
      • When usiedf with the --controller-id option, the version of the indicated Controller will be returned.
      • When used with the --agent-id option, the version of the indicated Agent will be returned. If a Cluster Agent is specified, then version information for included Director Agents and Subagents will be returned in JSON format.
    • When used with the --json switch, information about included Controllers and/or Agents will be returned in JSON format.
  • switch-over
    • Shifts the active role to the Standby JOC Cockpit instance.
  • restart-service
    • Allows to restart JOC Cockpit proxy services when used with the --proxies switch.
    • Allows to restart JOC Cockpit background services. One of the following services must be specified using the --service-type option:
      • cluster, history, dailyplan, cleanup, monitor
    • JOC Cockpit background services will run based on events (cluster, history, monitor) or based on schedules configurable with JS7 - Settings (dailyplan, cleanup). To force a background service to start immediately the run-service command can be used.
  • run-service
    • Starts JOC Cockpit background services. One of the following services can be specified using the --service-type option:
      • dailyplan, cleanup
    • JOC Cockpit background services will run based on schedules configurable with JS7 - Settings (dailyplan, cleanup). The run-service command will force immediate execution of the service.
  • check-license
    • Checks which JS7 - License is available with JOC Cockpit and if it is valid for a predetermined period.
      • The Open Source License is valid for any period of time and will not expire.
      • The Commercial License can be perpetual or can be valid for a limited subscription period.
    • The --validity-days option specifies the number of days before expiration of the Commercial License. Default: 60 days.
    • Exit codes of the license check include: 
      • Exit code 0 signals a valid license for the period specified.
      • Exit code 2 signals an expired license or an inapplicable license check if the Open Source License is used.
      • Exit code 3 signals a valid license that is about to expire within the number of days specified.
  • get-settings
    • Returns JS7 - Settings in JSON format.
    • Users can modify settings using the jq utility and can update settings using the store-settings command.
  • store-settings
    • Updates JS7 - Settings in JOC Cockpit. 
    • Users can read settings using the get-settings command and can modify settings using the jq utility before updating settings.
  • report-daily-plan
    • Returns Daily Plan information about orders.
    • Users can filter results
      • by workflows, folders and recursive processing of sub-folders,
      • by specifying Daily Plan dates, for example use of the --date-from="2024-12-09" --date-to="2024-12-09" options limits results to the given Daily Plan date range,
      • by tags, for example using the --tag=ScheduledExecution,MutualExclusion option for workflows and the --order-tag=Important,Critical option for orders,
      • by specifying one or more Daily Plan order states, for example using --state=PLANNED,SUBMITTED.
    • Results are returned in JSON format. Users can specify the --csv switch to receive output in CSV format.
  • report-order-history
    • Returns history order information.
    • Users can filter results
      • by workflows, folders and recursive processing of sub-folders, 
      • by specifying the order history's date range, for example --date-from="2024-12-09 08:00:00" --date-to="2024-12-09 14:00:00" will limit results to a period of 6 hours on the given day.
        • If dates are not specified in the UTC time zone, then users can indicate the applicable time zone using for example the  --time-zone=Europe/London option.
        • The following examples for Unix using bash shell calculate the UTC date independently from the machine's time zone:
          • begin of current day: --date-from="$(TZ=Etc/UTC;date +'%Y-%m-%d 00:00:00')"
          • begin of previous day: --date-from="$(TZ=Etc/UTC;date --date="1 day ago" +'%Y-%m-%d 00:00:00')"
          • begin of next day: --date-to="$(TZ=Etc/UTC;date --date="+1 day" +'%Y-%m-%d 00:00:00')"
      • by specifying tags similar to the report-daily-plan command,
      • by specifying one or more history states, for example using --state=SUCCESSFUL,FAILED.
    • Results are returned in JSON format. Users can specify the --csv switch to receive output in CSV format.
  • report-task-history
    • Returns history information about job executions.
    • Users can filter results
      • by workflows, folders and recursive processing of sub-folders,
      • by specifying the task history's date range similar to use with the report-order-history command,
      • by specifying tags similar to the report-daily-plan command,
      • by specifying one or more history states, for example using --state=SUCCESSFUL,FAILED.
    • Results are returned in JSON format. Users can specify the --csv switch to receive output in CSV format.
  • encrypt
    • Allows to encrypt a value using the --in option. If used to encrypt a file then --infile and --outfile options must be specified.
    • The --cert option specifies the path to a file holding the Certificate used for encryption.
    • Encryption is performed by Java libraries that are looked up in the ./lib sub-directory of the  JS7 Unix Shell CLI. For details see JS7 - Encryption and Decryption.
  • decrypt
    • Allows to decrypt a value using the --in option. If used to decrypt a file then --infile and --outfile options must be specified.
    • The --key option specifies the path to the Private Key used for decryption. If the Private Key is protected by a password, then the --key-password option or switch must be specified.
    • Decryption is performed by Java libraries that are looked up in the ./lib sub-directory of the JS7 Unix Shell CLI.

Options

  • --url
  • --user
    • Specifies the user account for login to JOC Cockpit. If JS7 - Identity Services are available for Client authentication certificates that are specified with the --client-cert and --client-key options then their common name (CN) attribute has to match the user account.
    • If a user account is specified then a password can be specified using the --password option or interactive keyboard input can be prompted using the -p switch.
  • --password
    • Specifies the password used for the account specified with the --user option for login to JOC Cockpit.
    • Password input from the command line is considered insecure.
      • Consider use of the -p switch offering a secure option for interactive keyboard input.
      • Consider use of the encrypt command to encrypt a password: ./operate-joc.sh encrypt --in=root --cert=encrypt.crt.
        • The encryption result will include the prefix enc: followed by the encrypted symmetric key, initialization vector and encrypted secret separated by space.
        • If an encrypted password is specified, then it will be decrypted using the Private Key file: ./operate-joc.sh <command> --password="enc:BF8J8KP7TPlxy..." --key=encrypt.key.
  • --ca-cert
    • Specifies the path to a file in PEM format that holds the Root CA Certificate and optionally Intermediate CA Certificates to verify HTTPS connections to JOC Cockpit.
  • --client-cert
    • Specifies the path to a file in PEM format that holds the Client Certificate if HTTPS mutual authentication is used..
  • --client-key
    • Specifies the path to a file in PEM format that holds the Client Private Key if HTTPS mutual authentication is used..
  • --timeout
    • Specifies the maximum duration for requests to the JS7 REST Web Service. Default: 60 seconds.
  • --controller-id
    • Specifies the identification of the Controller.
  • --agent-id
    • The Agent ID specifies a unique identifier for a Standalone Agent or Agent Cluster that cannot be changed later on.
    • Agents are identified from their Agent ID.
  • --service-type
    • When used with the restart-service command, specifies the service that should be restarted.
    • One of the following services can be specified: cluster, history, dailyplan, cleanup, monitor
  • --validity-days
    • When used with the checck-license command, specifies the number of days before expiration of a JS7 license.
      • Exit code 2 signals an expired license or an inapplicable license check if the Open Source License is used.
      • Exit code 3 signals a valid license that is about to expire within the number of days specified.
  • --settings
    • When used with the store-settings command, specifies settings from their JSON format.
  • --whatif-shutdown
  • --order-id
    • When used with the report-daily-plan command, a number of Order IDs can be specified separated by comma to limit results.
    • When used with the report-order-history command, a single Order ID can be specified to filter results. The Order ID can include wildcard characters:
      • * matching zero or more characters,
      • ? matching any single character.
  • --order-tag
    • When used with the report-* commands, specifies one or more order tags to limit results. Order tags are typically specified by schedules.
  • --workflow
    • When used with the report-* commands, specifies one or more workflows from their name to limit results.
  • --folder
    • When used with the report-* commands, specifies one or more folders holding workflows to limit results.
    • Use of the --recursive switch will include sub-folders.
  • --schedule
    • When used with the report-* commands, specifies one or more schedules from their name to limit results.
  • --schedule-folder
    • When used with the report-daily-plan command, specifies one or more folders holding schedules to limit results.
    • Use of the --recursive switch will include sub-folders.
  • --tag
    • When used with the report-* commands, specifies one or more worfklow tags to limit results.
  • --limit
    • When used with the report-order-history and report-task-history commands, limits the number of orders that will be returned.
  • --job
    • When used with the report-task-history command, filters jobs by name.
    • It is recommended to specify the --workflow or --folder option too to speed up querying the history.
  • --criticality
    • When used with the report-task-history command, filters jobs by the indicated critiicality.
    • One or more values can be specified for example using --criticality=minor,normal,major,critical.
  • --date-from
    • When used with the report-* commands, specifies the date starting from which history entries will be returned.
    • The report-daily-plan command allows to specify the Daily Pl.an date. The report-order-history and report-task-history commands allow to specify date and time.
  • --date-to
    • When used with the report-* commands, specifies the date until which results will be returned.
    • Values are specified similarly to use of the --date-from option.
  • --date-from-completed
    • When used with the report-order-history and report-task-history commands, specifies the date starting from which orders/tasks are required to be completed.
    • Values are specified similarly to use of the --date-from option.
  • --date-to-completed
    • When used with the report-order-history and report-task-history commands, specifies the date until which orders/tasks are required to be completed.
    • Values are specified similarly to use of the --date-from option.
  • --time-zone
    • Specifies the applicable time zone for values of the --date-from, --date-to, --date-from-completed and --date-to-completed options. Default: Etc/UTC.
  • --state
    • When used with the report-* commands, offers to limit results to orders holding the following states:
      • report-daily-plan:    --state=PLANNED,SUBMITTED,FINISHED
      • report-order-history: --state=SUCCESSFUL,FAILED,INCOMPLETE
      • report-task-history:  --state=SUCCESSFUL,FAILED,INCOMPLETE
  • --key
    • When used with the decrypt command, specifies the path to a file that holds the Private Key in PEM format used for decryption.
  • --cert
    • When used with the encrypt command, specifies the path to a file that holds the CA-signed or self-signed X.509 Certificate. Alternatively, the path to a file holding the Public Key can be specified. The Certificate/Public Key is expected in PEM format.
    • For encryption the Certificate/Public Key must match the Private Key used for later decryption specified with the --key option.
  • --key-password
    • When used with the decrypt command, specifies the password for access to the key file using the --key option.
    • Password input from the command line is considered insecure.
      • Consider use of the -k switch or more elaborate mechanisms, for example by temporarily populating the system keystore form a security key such as a YubiKey® or similar.
      • Consider use of encrypted passwords as explained with the --password option.
  • --in
    • When used with the encrypt and decrypt commands, specifies the input value that should be encrypted or decrypted.,
    • One of the options --in or --infile can be specified.
  • --infile
    • When used with the encrypt and decrypt commands, specifies the path to the input file that should be encrypted/decrypted.
    • One of the options --in or --infile can be specified. This option requires use of the --outfile option.
  • --outfile
    • When used with the encrypt command, specifies the path to the output file that will be created holding the encrypted content of the input file.
    • When used with the decrypt command, specifies the path to the output file that will be created holding the decrypted content of the input file.
    • The option is required if the --infile option is specified
  • --java-home
    • When used with the encrypt and decrypt commands or with encrypted passwords, specifies the Java home directory. By default the JAVA_HOME environment variable is used to determine the location of Java.
    • The Java home directory is the top-level directory of a Java installation. The directory includes the bin sub-directory and java executable.
  • --java-lib
    • When used with the encrypt and decrypt commands or with encrypted passwords, a number of Java libraries are required to perform encryption/decryption.
    • The Java libraries are expected in the lib sub-directory of the JS7 Unix Shell CLI. Default: ./lib.
  • --audit-message
    • Specifies a message that is made available to the Audit Log.
    • Specification of Audit Log messages can be enforced on a per user basis and for a JS7 environment.
  • --audit-time-spent
    • Specifies the time spent to perform an operation which is added to the Audit Log.
    • The option can be specified if the --audit-message option is used.
  • --audit-link
    • Specifies a link (URL) which is added to the Audit Log.
    • The option can be specified if the --audit-message option is used.
  • --log-dir
    • If a log directory is specified then the script will log information about processing steps to a log file in this directory.
    • File names are created according to the pattern: operate-joc.<yyyy>-<MM>-<dd>T<hh>-<mm>-<ss>.log
    • For example: operate-joc.2022-03-19T20-50-45.log

Switches

  • -h | --help
    • Displays usage.
  • -v | --verbose
    • Displays verbose log output that includes requests and responses with the JS7 REST Web Service.
    • When used twice as with -v -v then curl verbose output will be displayed.
  • -p | --password
    • Asks the user for interactive keyboard input of the password used for the account specified with the --user option..
    • The switch is used for secure interactive input as an alternative to use of the option --password=<password>.
  • -k | --key-password
    • Asks the user for interactive keyboard input of the password used for access to a keystore or key file specified with the --keystore or --key options.
    • The switch is used for secure interactive input as an alternative to use of the --key-password=<password> option.
  • -x | --proxies
    • When used with the restart-service command, specifies that proxy services should be restarted.
  • -c | --csv
    • When used with the report-* commands, specifies that results will be returned in CSV format.
  • -j | --json
    • Returns version information in JSON format when used with the version command.
  • -l | --late
    • When used with the report-daily-plan command, specifies that results should be limited to late orders that exceeded their start time.
  • -r | --recursive
    • When used with the report-* commands and the --folder or --schedule-folder options, specifies that sub-folders should be looked up for workflows or schedules.
  • --agent-cluster
    • When used with the status-agent and health-check commands, filters non-clustered Agents.
  • --no-hidden
    • When used with the status-agent and health-check commands, filters hidden Agents.
  • --show-logs
    • Displays the log output created by the script if the --log-dir option is used.
  • --make-dirs
    • If directories are missing that are indicated with the --log-dir option then they will be created.

Exit Codes

  • 0: operation successful
  • 1: argument errors
  • 2: permanent error
  • 3: no objects found or temporary error
  • 4: JS7 REST Web Service is not reachable or reports errors

Examples

The following examples illustrate typical use cases.

Getting Status Information

Examples for Getting JOC Cockpit and Controller Status Information
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# get status information for Standalone JOC Cockpit and Controller
response=$(./operate-joc.sh status "${request_options[@]}" --controller-id=controller)

# returns response
{"clusterState":{"_text":"ClusterUnknown","severity":2},"controllers":[{"componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"controllerId":"controller","host":"localhost","id":20,"isCoupled":false,"javaVersion":"21+35-2513","os":{"architecture":"amd64","distribution":"3.10.0-1160.92.1.el7.x86_64","name":"Linux"},"role":"STANDALONE","securityLevel":"HIGH","startedAt":"2024-09-03T09:52:38.918Z","surveyDate":"2024-09-23T10:10:01.496Z","title":"Standalone Controller","url":"http://localhost:4444","version":"2.7.2"}],"database":{"componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"dbms":"H2","version":"1.4.200 (2019-10-14)"},"deliveryDate":"2024-09-23T10:10:01.499Z","jocs":[{"componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"controllerConnectionStates":[{"role":"STANDALONE","state":{"_text":"established","severity":0}}],"current":true,"host":"localhost","id":1,"instanceId":"joc#0","isApiServer":false,"lastHeartbeat":"2024-09-23T10:09:43.682Z","memberId":"localhost:1ce420678f21a574e6adeb2f218f5bd40ed1b1bf9005414bcf060fba2e4c5a67","os":{"architecture":"amd64","distribution":"3.10.0-1160.92.1.el7.x86_64","name":"Linux"},"securityLevel":"HIGH","startedAt":"2024-09-19T20:55:34.522Z","title":"My JOC Cockpit","url":"http://localhost:4446","version":"2.7.2"}]}

# reads severity from response
echo "$response" | jq -r '.jocs[0].componentState.severity // empty'
echo "$response" | jq -r '.jocs[0].connectionState.severity // empty'
echo "$response" | jq -r '.jocs[0].controllerConnectionStates[0].state.severity // empty'
echo "$response" | jq -r '.jocs[0].version // empty'
echo "$response" | jq -r '.database.componentState.severity // empty'
echo "$response" | jq -r '.database.connectionState.severity // empty'


# get status information for JOC Cockpit Cluster and Controller Cluster
response=$(./operate-joc.sh status "${request_options[@]}" --controller-id=controller)
 
# returns response
{"clusterState":{"_text":"ClusterCoupled","severity":0},"controllers":[{"clusterNodeState":{"_text":"inactive","severity":1},"clusterUrl":"http://localhost:4444","componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"controllerId":"controller_cluster","host":"localhost","id":2,"isCoupled":true,"javaVersion":"17.0.12+7-alpine-r0","os":{"architecture":"amd64","distribution":"3.10.0-1160.92.1.el7.x86_64","name":"Linux"},"role":"PRIMARY","securityLevel":"MEDIUM","startedAt":"2024-09-18T20:29:33.271Z","surveyDate":"2024-09-23T10:07:16.768Z","title":"PRIMARY CONTROLLER","url":"http://localhost:4444","version":"2.7.2"},{"clusterNodeState":{"_text":"active","severity":0},"clusterUrl":"http://localhost:4444","componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"controllerId":"controller_cluster","host":"localhost","id":3,"isCoupled":true,"javaVersion":"17.0.12+7-alpine-r0","os":{"architecture":"amd64","distribution":"3.10.0-1160.92.1.el7.x86_64","name":"Linux"},"role":"BACKUP","securityLevel":"MEDIUM","startedAt":"2024-09-18T20:29:33.972Z","surveyDate":"2024-09-23T10:07:16.737Z","title":"SECONDARY CONTROLLER","url":"http://localhost:44444","version":"2.7.2"}],"database":{"componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"dbms":"MySQL","version":"5.7.33"},"deliveryDate":"2024-09-23T10:07:16.773Z","jocs":[{"clusterNodeState":{"_text":"active","severity":0},"componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"controllerConnectionStates":[{"role":"PRIMARY","state":{"_text":"established","severity":0}},{"role":"BACKUP","state":{"_text":"established","severity":0}}],"current":true,"host":"localhost","id":3,"instanceId":"joc#0","isApiServer":false,"lastHeartbeat":"2024-09-23T10:07:13Z","memberId":"localhost:97c88ccc3975703ebd0b7277d394ec8768f88b31775e8df038572d2547c240a0","os":{"architecture":"amd64","distribution":"3.10.0-957.1.3.el7.x86_64","name":"Linux"},"securityLevel":"MEDIUM","startedAt":"2024-09-20T15:50:41Z","title":"PRIMARY JOC COCKPIT","url":"http://localhost:4446","version":"2.7.2"},{"clusterNodeState":{"_text":"inactive","severity":1},"componentState":{"_text":"operational","severity":0},"connectionState":{"_text":"established","severity":0},"controllerConnectionStates":[{"role":"PRIMARY","state":{"_text":"established","severity":0}},{"role":"BACKUP","state":{"_text":"established","severity":0}}],"current":false,"host":"localhost","id":1,"instanceId":"joc#1","isApiServer":false,"lastHeartbeat":"2024-09-23T10:07:12Z","memberId":"localhost:97c88ccc3975703ebd0b7277d394ec8768f88b31775e8df038572d2547c240a0","os":{"architecture":"amd64","distribution":"3.10.0-957.1.3.el7.x86_64","name":"Linux"},"securityLevel":"MEDIUM","startedAt":"2024-09-20T15:50:40Z","title":"SECONDARY JOC COCKPIT","url":"http://localhost:4446","version":"2.7.2"}]}

# reads severity from response
echo "$response" | jq -r '.clusterState.severity // empty'
echo "$response" | jq -r '.controllers[0].componentState.severity // empty'
echo "$response" | jq -r '.controllers[0].connectionState.severity // empty'
echo "$response" | jq -r '.controllers[1].componentState.severity // empty'
echo "$response" | jq -r '.controllers[1].connectionState.severity // empty'
echo "$response" | jq -r '.jocs[0].componentState.severity // empty'
echo "$response" | jq -r '.jocs[0].connectionState.severity // empty'
echo "$response" | jq -r '.jocs[0].version // empty'
echo "$response" | jq -r '.database.componentState.severity // empty'
echo "$response" | jq -r '.database.connectionState.severity // empty'



Examples for Getting Agent Status Information
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# get status information for indicated Standalone Agents
response=$(./operate-joc.sh status-agent "${request_options[@]}" --controller-id=controller --agent-id=agent_001,agent_002)

# returns response
{"agents":[{"agentId":"agent_001","agentName":"primaryAgent","controllerId":"testsuite","disabled":false,"healthState":{"_text":"ALL_SUBAGENTS_ARE_COUPLED_AND_ENABLED","severity":0},"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"url":"https://agent-2-0-primary:4443","version":"2.7.2-SNAPSHOT"},{"agentId":"agent_002","agentName":"secondaryAgent","controllerId":"testsuite","disabled":false,"healthState":{"_text":"ALL_SUBAGENTS_ARE_COUPLED_AND_ENABLED","severity":0},"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"url":"https://agent-2-0-secondary:4443","version":"2.7.2-SNAPSHOT"}],"deliveryDate":"2024-11-11T18:45:28.855Z","surveyDate":"2024-11-11T18:45:06.798Z"}

# read severity from response
echo "$response" | jq -r '.agents[0].state.severity // empty'


# get status information for Agent Cluster
response=$(./operate-joc.sh status-agent "${request_options[@]}" --controller-id=controller --agent-cluster)

# returns response
{"agents":[{"agentId":"agent_cluster_001","agentName":"AgentCluster001","clusterState":{"_text":"ClusterCoupled","severity":0},"controllerId":"testsuite","healthState":{"_text":"ALL_SUBAGENTS_ARE_COUPLED_AND_ENABLED","severity":0},"runningTasks":0,"subagents":[{"agentId":"agent_cluster_001","disabled":false,"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"subagentId":"director_primary_001","url":"https://diragent-2-0-primary:4443","version":"2.7.2-SNAPSHOT","clusterNodeState":{"_text":"active","severity":0},"isDirector":"PRIMARY_DIRECTOR"},{"agentId":"agent_cluster_001","disabled":false,"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"subagentId":"director_secondary_001","url":"https://diragent-2-0-secondary:4443","version":"2.7.2-SNAPSHOT","clusterNodeState":{"_text":"inactive","severity":1},"isDirector":"SECONDARY_DIRECTOR"},{"agentId":"agent_cluster_001","disabled":false,"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"subagentId":"subagent_primary_001","url":"https://subagent-2-0-primary:4443","version":"2.7.2-SNAPSHOT","isDirector":"NO_DIRECTOR"},{"agentId":"agent_cluster_001","disabled":false,"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"subagentId":"subagent_secondary_001","url":"https://subagent-2-0-secondary:4443","version":"2.7.2-SNAPSHOT","isDirector":"NO_DIRECTOR"},{"agentId":"agent_cluster_001","disabled":false,"runningTasks":0,"state":{"_text":"COUPLED","severity":0},"subagentId":"subagent_third_001","url":"https://subagent-2-0-third:4443","version":"2.7.2-SNAPSHOT","isDirector":"NO_DIRECTOR"}]}]}

# reads cluster state from status information
echo "$response" | jq -r '.agents[0].clusterState.severity // empty'

# reads Primary and Secondary Director Agent component state
echo "$response" | jq -r '.agents[0].subagents[0].state.severity // empty'
echo "$response" | jq -r '.agents[0].subagents[1].state.severity // empty'

# reads Primary and Secondary Director Agent cluster node state
echo "$response" | jq -r '.agents[0].subagents[0].clusterNodeState.severity // empty'
echo "$response" | jq -r '.agents[0].subagents[1].clusterNodeState.severity // empty'

Performing Health Checks

Examples for performing Health Checks
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# perform health check for JOC Cockpit, Controller and Agents
./operate-joc.sh health-check "${request_options[@]}" --controller-id=controller

# log output of the command can look like this with 2 Agents not being available
Database: MySQL 5.7.33
    Component State    : operational (0)
    Connection State   : established (0)
JOC Cockpit: PRIMARY JOC COCKPIT, URL: https://joc-2-0-primary.sos:7443, Date: 2024-11-11T15:11:01.19Z
    Cluster Node State: active (0)
    Component State:    operational (0)
    Connection State:   established (0)
JOC Cockpit: SECONDARY JOC COCKPIT, URL: http://centostest_primary.sos:7546, Date: 2024-11-11T15:11:01.19Z
    Cluster Node State: inactive (1)
    Component State:    operational (0)
    Connection State:   established (0)
JOC Cockpit Cluster State: ClusterCoupled (0)
PRIMARY Controller: PRIMARY CONTROLLER, ID: testsuite, URL: https://controller-2-0-primary:4443, is coupled: true, Date: 2024-11-11T15:11:01.186Z
    Cluster Node State: inactive (1)
    Component State:    operational (0)
    Connection State:   established (0)
BACKUP Controller: SECONDARY CONTROLLER, ID: testsuite, URL: https://controller-2-0-secondary:4443, is coupled: true, Date: 2024-11-11T15:11:01.158Z
    Cluster Node State: active (0)
    Component State:    operational (0)
    Connection State:   established (0)
STANDALONE Agent: primaryAgent, ID: agent_001, URL: https://agent-2-0-primary:4443, Controller ID: testsuite, Disabled: , Date: 2024-11-11T15:11:01.111Z
    Component State:    COUPLED (0)
STANDALONE Agent: apmaccsAgent, ID: agent_005, URL: http://192.11.3.3:4449, Controller ID: testsuite, Disabled: true, Date: 2024-11-11T15:11:01.111Z
    Component State:    UNKNOWN (2)
[WARN] Fatal Component State: UNKNOWN (2)
STANDALONE Agent: apmacwinAgent, ID: agent_006, URL: http://192.11.2.2:4245, Controller ID: testsuite, Disabled: true, Date: 2024-11-11T15:11:01.111Z
    Component State:    UNKNOWN (2)
[WARN] Fatal Component State: UNKNOWN (2)
CLUSTER Agent: AgentCluster001, ID: agent_cluster_001, Controller ID: testsuite, Date: 2024-11-11T15:11:01.111Z
  PRIMARY DIRECTOR:     Subagent ID: director_primary_001, URL: https://diragent-2-0-primary:4443
    Cluster Node State: active (0)
    Component State:    COUPLED (0)
  SECONDARY DIRECTOR:   Subagent ID: director_secondary_001, URL: https://diragent-2-0-secondary:4443
    Cluster Node State: inactive (1)
    Component State:    COUPLED (0)
STANDALONE Agent: secondaryAgent, ID: agent_002, URL: https://agent-2-0-secondary:4443, Controller ID: testsuite, Disabled: , Date: 2024-11-11T15:11:01.111Z
    Component State:    COUPLED (0)
STANDALONE Agent: oracleAgent, ID: agent_010, URL: http://minos.sos:4445, Controller ID: testsuite, Disabled: , Date: 2024-11-11T15:11:01.111Z
    Component State:    COUPLED (0)
STANDALONE Agent: testAgent, ID: agent_011, URL: http://centostest_primary.sos:7775, Controller ID: testsuite, Disabled: , Date: 2024-11-11T15:11:01.111Z
    Component State:    COUPLED (0)
STANDALONE Agent: wintestAgent, ID: agent_021, URL: http://192.11.0.146:4445, Controller ID: testsuite, Disabled: , Date: 2024-11-11T15:11:01.111Z
    Component State:    COUPLED (0)
STANDALONE Agent: winutf8Agent, ID: agent_022, URL: http://192.11.0.146:4245, Controller ID: testsuite, Disabled: , Date: 2024-11-11T15:11:01.111Z
    Component State:    COUPLED (0)
[ERROR] health check identified 2 fatal problems



Examples for performing Health Checks for Host Shutdown Scenario
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# performs health check for JOC Cockpit, Controller and Agents assuming the shutdown of the Primary Controller's host
./operate-joc.sh health-check "${request_options[@]}" --controller-id=controller --agent-cluster --whatif-shutdown=controller-2-0-primary

Database: MySQL 5.7.33
    Component State    : operational (0)
    Connection State   : established (0)
JOC Cockpit: PRIMARY JOC COCKPIT, URL: https://joc-2-0-primary.sos:7443, Date: 2024-11-11T15:16:41.664Z
    Cluster Node State: active (0)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: controller-2-0-primary: ok
JOC Cockpit: SECONDARY JOC COCKPIT, URL: http://centostest_primary.sos:7546, Date: 2024-11-11T15:16:41.664Z
    Cluster Node State: inactive (1)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: controller-2-0-primary: ok
JOC Cockpit Cluster State: ClusterCoupled (0)
PRIMARY Controller: PRIMARY CONTROLLER, ID: testsuite, URL: https://controller-2-0-primary:4443, is coupled: true, Date: 2024-11-11T15:16:41.659Z
    Cluster Node State: inactive (1)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: controller-2-0-primary: ok
BACKUP Controller: SECONDARY CONTROLLER, ID: testsuite, URL: https://controller-2-0-secondary:4443, is coupled: true, Date: 2024-11-11T15:16:41.638Z
    Cluster Node State: active (0)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: controller-2-0-primary: ok
CLUSTER Agent: AgentCluster001, ID: agent_cluster_001, Controller ID: testsuite, Date:
  PRIMARY DIRECTOR:     Subagent ID: director_primary_001, URL: https://diragent-2-0-primary:4443
    Cluster Node State: active (0)
    Component State:    COUPLED (0)
  SECONDARY DIRECTOR:   Subagent ID: director_secondary_001, URL: https://diragent-2-0-secondary:4443
    Cluster Node State: inactive (1)
    Component State:    COUPLED (0)
  What if host is shutdown: controller-2-0-primary: ok
health check identified no problem if host is shutdown: controller-2-0-primary


# performs health check for JOC Cockpit, Controller and Agents assuming the shutdown of the Primary and Secondary Director Agent host
./bin/operate-joc.sh health-check "${request_options[@]}" --controller-id=testsuite --agent-cluster --whatif-shutdown=diragent-2-0-primary,diragent-2-0-secondary

Database: MySQL 5.7.33
    Component State    : operational (0)
    Connection State   : established (0)
JOC Cockpit: PRIMARY JOC COCKPIT, URL: https://joc-2-0-primary.sos:7443, Date: 2024-11-11T20:45:33.983Z
    Cluster Node State: inactive (1)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: diragent-2-0-primary,diragent-2-0-secondary: ok
JOC Cockpit: SECONDARY JOC COCKPIT, URL: http://centostest_primary.sos:7546, Date: 2024-11-11T20:45:33.983Z
    Cluster Node State: active (0)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: diragent-2-0-primary,diragent-2-0-secondary: ok
JOC Cockpit Cluster State: ClusterCoupled (0)
PRIMARY Controller: PRIMARY CONTROLLER, ID: testsuite, URL: https://controller-2-0-primary:4443, is coupled: true, Date: 2024-11-11T20:45:33.978Z
    Cluster Node State: inactive (1)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: diragent-2-0-primary,diragent-2-0-secondary: ok
BACKUP Controller: SECONDARY CONTROLLER, ID: testsuite, URL: https://controller-2-0-secondary:4443, is coupled: true, Date: 2024-11-11T20:45:33.958Z
    Cluster Node State: active (0)
    Component State:    operational (0)
    Connection State:   established (0)
    What if host is shutdown: diragent-2-0-primary,diragent-2-0-secondary: ok
CLUSTER Agent: AgentCluster001, ID: agent_cluster_001, Controller ID: testsuite, Date:
  PRIMARY DIRECTOR:     Subagent ID: director_primary_001, URL: https://diragent-2-0-primary:4443
    Cluster Node State: active (0)
    Component State:    COUPLED (0)
  SECONDARY DIRECTOR:   Subagent ID: director_secondary_001, URL: https://diragent-2-0-secondary:4443
    Cluster Node State: inactive (1)
    Component State:    COUPLED (0)
[WARN] What if host is shutdown: diragent-2-0-primary,diragent-2-0-secondary: failure
[ERROR] health check identified 1 problems if host is shutdown: diragent-2-0-primary,diragent-2-0-secondary

Getting Version Information

Examples for Getting Version Information
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# get JOC Cockpit version
./operate-joc.sh version "${request_options[@]}"
# returns
2.7.2

# get Controller version
./operate-joc.sh version "${request_options[@]}" --controller-id=controller
# returns
2.7.2

# get Standalone Agent version
./operate-joc.sh version "${request_options[@]}" --agent-id=StandaloneAgent
# returns
2.7.2

# get Agent Cluster version
./operate-joc.sh version "${request_options[@]}" --agent-id=AgentCluster
# returns
2.7.2

# get version of specific Controller and of all Agents in Agent Cluster
response=$(./operate-joc.sh version "${request_options[@]}" --controller-id=controller --agent-id=AgentCluster --json)
# returns response
{
  "agentVersions":[
    {"agentId":"AgentCluster","compatibility":"COMPATIBLE","uri":"https://diragent-2-0-primary:4443","version":"2.7.2"},
    {"agentId":"AgentCluster","compatibility":"COMPATIBLE","subagentId":"director_primary_001","uri":"https://diragent-2-0-primary:4443","version":"2.7.2"},
    {"agentId":"AgentCluster","compatibility":"COMPATIBLE","subagentId":"director_secondary_001","uri":"https://diragent-2-0-secondary:4443","version":"2.7.2"},
    {"agentId":"AgentCluster","compatibility":"COMPATIBLE","subagentId":"subagent_primary_001","uri":"https://subagent-2-0-primary:4443","version":"2.7.2"},
    {"agentId":"AgentCluster","compatibility":"COMPATIBLE","subagentId":"subagent_secondary_001","uri":"https://subagent-2-0-secondary:4443","version":"2.7.2"},
    {"agentId":"AgentCluster","compatibility":"COMPATIBLE","subagentId":"subagent_third_001","uri":"https://subagent-2-0-third:4443","version":"2.7.2"}
  ],
  "controllerVersions":[
    {"compatibility":"COMPATIBLE","controllerId":"controller","uri":"https://controller-2-0-standalone:4443","version":"2.7.2"}
  ],
  "jocVersion":"2.7.2"
}
# read version of specifc Agent
echo "$response" | jq -r '.agentVersions[] | select(.subagentId == "director_primary_001") | .version // empty'

Switching-over JOC Cockpit Cluster

Example for Switching-over JOC Cockpit Cluster
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# switch-over active role
./operate-joc.sh switch-over "${request_options[@]}" --controller-id=controller

Restarting and Running Services

Examples for Restarting and Running Services
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# restart proxy service
./operate-joc.sh restart-service "${request_options[@]}" --proxies

# restart service: cluster, history, dailyplan, cleanup, monitor
./operate-joc.sh restart-service "${request_options[@]}" --service-type=history

# run service: dailyplan, cleanup
./operate-joc.sh run-service "${request_options[@]}" --service-type=cleanup

Checking License

Example for Checking JOC Cockpit License
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# check license
./operate-joc.sh check-license "${request_options[@]}"
# returns response
.... License type: COMMERCIAL_VALID
.... License valid: true
.... License valid from: 2021-05-05T12:22:41Z
.... License valid until: 2026-05-04T12:22:41Z

Getting and Storing Settings

Example for Getting and Storing Settings
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root)

# get settings
settings=$(./operate-joc.sh get-settings "${request_options[@]}")

# update settings
settings=$(echo "$settings" | jq '.dailyplan.days_ahead_submit.value = "4"')
settings=$(echo "$settings" | jq '.dailyplan.days_ahead_plan.value = "6"')

# store settings
./operate-joc.sh store-settings "${request_options[@]}" --settings="$settings"

Reporting Daily Plan Information

Examples for Reporting Daily Plan Orders
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root --controller-id=controller)

# report daily plan orders for specific date
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="2024-12-09" --date-to="2024-12-09" \
                                                           --csv > ./out.csv

# report daily plan orders starting from current day until any future dates
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="$(TZ=Etc/UTC;date +'%Y-%m-%d')" \
                                                           --csv > ./out.csv

# report daily plan orders from current day until the next 3 days
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="$(TZ=Etc/UTC;date +'%Y-%m-%d')" \
                                                           --date-to="$(TZ=Etc/UTC;date --date="+3 day" +'%Y-%m-%d')" \
                                                           --csv > ./out.csv

# report daily plan orders by workflow for date range
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-08" \
                                                           --workflow=pdwScheduledWorkflow_003 \
                                                           --csv > ./out.csv

# report daily plan orders by workflow folder recursively for date range
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-08" \
                                                           --folder=/ProductDemo --recursive \
                                                           --csv > ./out.csv

# report daily plan orders by schedule for date range
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-08" \
                                                           --schedule=pdsScheduledWorkflowDaily \
                                                           --csv > ./out.csv

# report daily plan orders by workflow tags for date range
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-08" \
                                                           --tag=ScheduledExecution,ProductDemo \
                                                           --csv > ./out.csv

# report daily plan orders by order tags for date range
./operate-joc.sh report-daily-plan "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-08" \
                                                           --order-tag=ScheduledExecution,ProductDemo \
                                                           --csv > ./out.csv

Reporting History Information

Examples for Reporting Order History
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root --controller-id=controller)

# report order history for date range with limit of results
./operate-joc.sh report-order-history "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-09" \
                                                              --limit=100 --csv > ./out.csv

# report order history for date range of two days ago until begin of current day
./operate-joc.sh report-order-history "${request_options[@]}" --date-from="$(TZ=Etc/UTC;date --date="2 day ago" +'%Y-%m-%d 00:00:00')" \
                                                              --date-to="$(TZ=Etc/UTC;date +'%Y-%m-%d 00:00:00')" \
                                                              --csv > ./out.csv

# report order history by workflow for date range
./operate-joc.sh report-order-history "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-09" \
                                                              --workflow=pdwScheduledWorkflow_003 \
                                                              --csv > ./out.csv

# report order history by workflow folder recursively for date range using times
./operate-joc.sh report-order-history "${request_options[@]}" --date-from="2024-12-08 08:00:00" --date-to="2024-12-08 20:00:00" \
                                                              --time-zone="Etc/UTC" --folder=/ProductDemo --recursive \
                                                              --csv > ./out.csv

# report order history by tags for date range
./operate-joc.sh report-order-history "${request_options[@]}" --date-from="2024-12-08T00:00:00" --date-to="2024-12-08T23:59:59" \
                                                              --time-zone="Etc/UTC" --tag=ProductDemo \
                                                              --csv > ./out.csv

# report order history by state for date range
./operate-joc.sh report-order-history "${request_options[@]}" --date-from="2024-12-08T00:00:00" --date-to="2024-12-08T23:59:59" \
                                                              --time-zone="Etc/UTC" --state=failed \
                                                              --csv > ./out.csv



Examples for Reporting Task History
# common options for connection to JS7 REST API
request_options=(--url=http://localhost:4446 --user=root --password=root --controller-id=controller)

# report task history for date range with limit of results
./operate-joc.sh report-task-history "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-09" \
                                                             --limit=20 --csv > ./out.csv

# report task history by workflow for date range of two days ago until begin of current day
./operate-joc.sh report-task-history "${request_options[@]}" --date-from="$(TZ=Etc/UTC;date --date="2 day ago" +'%Y-%m-%d 00:00:00')" \
                                                             --date-to="$(TZ=Etc/UTC;date +'%Y-%m-%d 00:00:00')" \
                                                             --workflow=pdwScheduledWorkflow_003 \
                                                             --csv > ./out.csv

# report task history by workflow and job for date range
./operate-joc.sh report-task-history "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-09" \
                                                             --workflow=pdwScheduledWorkflow_003 --job=job2_2b \
                                                             --csv > ./out.csv

# report task history by workflow tags and date range
./operate-joc.sh report-task-history "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-09" \
                                                             --tag=ProductDemo,ScheduledExecution \
                                                             --csv > ./out.csv

# report task history by order tags and date range
./operate-joc.sh report-task-history "${request_options[@]}" --date-from="2024-12-08" --date-to="2024-12-09" \
                                                             --order-tag=ProductDemo,ScheduledExecution \
                                                             --csv > ./out.csv

Using encrypted Passwords

Example for Use of encrypted Password
# create Private Key
openssl ecparam -name secp384r1 -genkey -noout -out encrypt.key

# create Certificate Signing Request, adjust the subject to your needs
openssl req -new -sha512 -nodes -key encrypt.key -out encrypt.csr -subj "/C=DE/ST=Berlin/L=Berlin/O=SOS/OU=IT/CN=Encrypt"

# create Certificate, adjust the validity period to your needs
openssl x509 -req -sha512 -days 1825 -signkey encrypt.key -in encrypt.csr -out encrypt.crt -extfile <(printf "keyUsage=critical,keyEncipherment,keyAgreement\n")


# encrypt the password "root" using the Certificate, the encryption result will be returned and will look like: enc:BEXbHYa...
MY_JS7_PASSWORD=$(./operate-joc.sh encrypt --in="root" --cert=encrypt.crt)

# store the environment variable to your profile ($HOME/.bash_profile or similar) to make the encrypted password available to the shell
# export MY_JS7_PASSWORD=enc:BEXbHYa...


# options for connection to the JS7 REST API can specify the encryption result as password and the Private Key for decryption
request_options=(--url=http://localhost:4446 --user=root --password="$MY_JS7_PASSWORD" --key=encrypt.key --controller-id=controller)

# for example, when reading version information, the Private Key is used to decrypt the password on-the-fly for access to the REST API
./operate-joc.sh version "${request_options[@]}"

Resources