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


Article ID: 144203


Updated On:


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


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?


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;