DIS Import Performance

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Query to review Discoverer to Blitz Report import performance, after running the 'Blitz Report Discoverer Import' concurrent program or mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet
select
x.*,
xxen_util.time(x.seconds) time
from
(
select
xrv.report_name,
regexp_substr(xrv.description,'Object IDs: (.+)',1,1,null,1) object_use_key,
xrv.category,
xxen_util.user_name(xrv.created_by) created_by,
xxen_util.client_time(xrv.creation_date) creation_date,
(xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400 seconds
from
xxen_reports_v xrv
where
1=1
order by
xrv.report_id desc
) x
Parameter NameSQL textValidation
Report Creation Time From
xrv.creation_date>=:date_from
DateTime
Report Creation Time To
xrv.creation_date<=:date_to
DateTime
Category
xrv.report_id in (
select
xrca.report_id
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:category_name and
xrcv.category_id=xrca.category_id
)
LOV
Download
Related Blitz Reports
Blitz Reports Blitz Report Text Search AP Invoice Upload DIS End User Layers GL Account Analysis (Distributions) Blitz Upload History Blitz Report Assignments and Responsibilities QAR : Blitz Report User Access Blitz Report History Blitz Report Security
Blitz Report™