To check if any reports have been run, use the appropriate query for your database type.
📌 Note: If you notice B13 under the Title, it may affect the environment and potentially cause crashes.
Format date and time: Oracle only
alter session set nls_date_format='DD-MON-RRRR HH24:MI:SS';
Mosaic version 22.1 or higher includes report parameters
select adt.id,adt.date_stamp, adt.system_user_id, r.title, ata.value
from audit_trail adt
join reports r on r.id = adt.record_id
left outer join AUDIT_TRAIL_ATTRIBUTES ata on adt.id=ata.AUDIT_ID
where adt.date_stamp >= getdate() -2
and adt.record_type = 'REP'
order by date_stamp desc;
Mosaic version prior to 22.1
select adt.date_stamp, adt.system_user_id, r.title
from audit_trail adt
join reports r
on r.id = adt.record_id
where adt.date_stamp >= getdate() -2
and adt.record_type = 'REP'
order by date_stamp desc;