Blitz Report Deletion History

➜ Back to Library

Description
Categories: Application, Enginatics, Setup Shows deleted Blitz Reports and can be used to recover accidentally deleted reports. The history of deleted reports can be purged completely by running concurrent 'Blitz Report Monitor' with parameter 'Purge delete reports SQL history' set to Yes more less

select
xrh.report_name,
xrh.version,
xrh.min_creation_date creation_date,
xxen_util.user_name(xrh.created_by_orig) created_by,
xrh.creation_date last_update_date,
xxen_util.user_name(xrh.created_by) last_updated_by,
xrh.sql_text,
xrh.guid
from
(
select
count(*) over (partition by xrh.report_id) version,
max(xrh.creation_date) over (partition by xrh.report_id) max_creation_date,
min(xrh.creation_date) over (partition by xrh.report_id) min_creation_date,
min(xrh.created_by) keep (dense_rank first order by xrh.creation_date) over (partition by xrh.report_id) created_by_orig,
xrh.*
from
xxen_reports_h xrh
) xrh
where
xrh.creation_date=xrh.max_creation_date and
not exists (select null from xxen_reports xr where xrh.report_id=xr.report_id)
order by
xrh.creation_date desc

Download

Related Blitz Reports
Blitz Report Execution History Blitz Reports Without Example Files Blitz Report Example XLSX Files Blitz Reports Blitz Report Execution Summary Blitz Report License Users Blitz Reports with Example Files (Web View) ONT Credit Order Summary FND Concurrent Requests