Auditing resource

[maheshvenu]

Hi,

How to find who locked the resource (QR).
Is there any query to find out the person also let me know which table is used for all Audit related activity.

Thanks and Regards
Maheshvenu

[chris59]

Hi,
The table is CMR_QRUSE.
and the query could be :
select a.qresname, a.jobused, b.jobname from cmr_qruse a, cmr_ajf b where a.qresname = '(YOUR RESSOURCE NAME)' and a.orderno = b.orderno;

Regards

[maheshvenu]

Hi,

The query you gave was useful for finding the information about the resource and the job which locked it.

Kindly provide me the information, how to check who (operator) deleted or modified the resource and when.

thanks and regards
Maheshvenu

[chris59]

Hello
Sorry I have found any information about a history resources.
the names of the resource tables are:
CMR_QR_J, and CMR_QRTAB CMR_QRUSE for active jobs
CMS_QR_J and for jobs definitions.
regards
Christophe