SAP Reports

[former_member260745]

Hi,

We have many queries in SAP that have not been used for long time. I would like to delete them based on when it was ran last time by whom in ECC system. SQ01 is one option to find but is there a better way to do this type of clean up.

Appreciate for your support..

Regards

A

[former_member202771]

Hi Arjun,

Check tables AQL*. these could help.

Thanks,

Anil

[former_member260745]

Anil,

Thanks for the response but those tables does not provide when and by whom queries ran last time.

Regards

Arjun

[RaymondGiuseppi]

(Easy part) First link query list (from AQLQCAT) with generated reports using RSAQ_REPORT_NAME in a LOOP.

(Harder part) Then use FM SAPWL_WORKLOAD_GET_STATISTIC (table parameter returned  APPLICATION_STATISTIC)  to get last usage of reports. (Background job suggested...)

(Easy again) then match the two extractions.

Regards,

Raymond