Is there a way to lookup a previous value of a virtual resource that has been updated?

book

Article ID: 144203

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction

If a virtual resource is updated with a new value for the amount, is there any record kept in the AutoSys data that could be queried to show the previous value for the amount prior to the update?

Resolution

There is nowhere in the AutoSys data where a previous value of an updated resource is stored.

One thing that could be done manually to keep a historical record of resource values is run the following sql query on a regular basis and store the output in a file with a date stamp...

select b.res_name, a.amount_defined from ujo_virt_resource a, ujo_virt_resource_lookup b;