DIS Import Performance
Description
Categories: Enginatics, Kcapps
Repository: Github
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
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 Name | SQL text | Validation | |
---|---|---|---|
Report Creation Time From |
|
DateTime | |
Report Creation Time To |
|
DateTime | |
Category |
|
LOV |