Audit Report

[Sonali Babar]

Hi,
Please can you help me to get audit report from CA PPM Advanced reporting.

On Standard Jasper server I am able to find it under Public\Audit folder but here on Clarity, we are not able to find anywhere.

Or please can you help me to get a report with below information:
All the report names and their last used date & last used by name



Thanks,
Sonali

[Suman Pramanik]

Hi Sonali

Audit is not enabled by default with clarity integration. so if you go via advance reporting you will not see it.  I believe you are trying to get the report usage within your organization and that is not something a native capability Jaspersoft provided but you may look into the API's provided by Jaspersoft to see if you can get desired output 

Also if you are running reports from reports and jobs from clarity you might be able to build some custom reports

------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
------------------------------

[Sonali Babar]

Thank you Suman for the response. We are using reports from clarity also building some new customized reports. To build a report with expected information i.e. list of reports and last updated date and last used date and user name etc. I need to know that from where I'll be able to get this data.
Please can you help me to understand that where this data gets stored.

Thanks,
Sonali

[Suman Pramanik]

Hi Sonali

See if this query helps 

SELECT JR.STATUS_CODE,
JR.JOB_ID JOBID,
JR.ID RUNID,
J.NAME,
TO_CHAR(jr.start_date, 'MM-DD-YYYY HH24:MI:SS AM Dy') start_time_app,
TO_CHAR(JR.END_DATE, 'MM-DD-YYYY HH24:MI:SS AM Dy') END_TIME_APP,
ROUND(JR.TOTAL_EXECUTION_TIME/1000/60, 3) EXEC_MINS
FROM Cmn_Sch_Job_Runs Jr,
CMN_SCH_JOBS J,
CMN_SEC_USERS CSU
WHERE J.id = JR.JOB_ID
AND JR.LAST_UPDATED_BY = CSU.id
AND JR.START_DATE > sysdate-3
--AND j.name LIKE '%Data Warehouse Schema%'
ORDER BY JR.START_DATE DESC;

------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
------------------------------