AutoSys machine status change time

Products

• Autosys Workload Automation

Issue/Introduction

There is no standard AutoSys command, Workload Control Center (WCC) view, or AutoSys Web Services (AEWS) API call that provides a comprehensive report or historical list detailing exactly when (exact date and time) a machine transitioned to its current status (e.g., when it went offline or missing).

While current machine statuses can be viewed using native interfaces, the specific timestamp of the status change is not included. Manually searching and running grep commands through historical event_demon log files or event records is often unfeasible due to strict log rotation policies and the unavailability of older data.

Environment

Product: AutoSys Workload Automation 24.x

Resolution

Standard native tools like autorep -M ALL, WCC Agent Inventory, and AEWS endpoints report the current state of a machine but omit the change timestamp.

To find the exact date and time a machine status was last updated, the most effective workaround is to query the AutoSys backend database directly.

The application tracks this information in the ujo_machine table. You can execute a standard SQL SELECT query targeting the following columns to extract the necessary state data:

• status: Represents the current operational state of the machine.

• update_stamp: Contains the exact timestamp when the machine record—including its status—was last modified.

Example Query:

 

SELECT machine_name, status, update_stamp FROM ujo_machine;

Important Database Notice: The AutoSys database schema is strictly designed for internal product usage and can vary or change between product versions. Direct database queries are discouraged for standard operations. Clients pursuing custom database queries do so at their own discretion and should verify schema compatibility whenever performing product upgrades.