tips and tricks

You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository. select OH_IDNR, OH_NAME, CASE      WHEN JBA_AUTODEACT = 'A' THEN 'Always'     WHEN JBA_AUTODEACT = 'J' THEN 'After error-free...

Unfortunately UC4 (Automic) software does not have any lookup table for ah_status values. These are the ah_status messages I stumbled upon among years. AH_STATUS Status Text when t1.eh_status = 1300 then 'Preparing ' when t1.eh_status = 1510...