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;