DIS Import Performance
Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Report Name, Category, Created By, Creation Date, Time ...
Repository: Github Columns: Report Name, Category, Created By, Creation Date, Time ...
Simple query to review Discoverer worksheet to Blitz Report import performance, when running the mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet
https://www.enginatics.com/user-guide/#Discoverer_Worksheet
select xrv.report_name, xrv.category, xxen_util.user_name(xrv.created_by) created_by, xrv.creation_date, xxen_util.time((xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400) time from xxen_reports_v xrv where 1=1 order by xrv.report_id desc |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Category |
| LOV | |
Report Creation Time From |
| DateTime | |
Report Creation Time To |
| DateTime |