Queries to generate counts and metrics

Note: Timing Mentioned in PHT According to the countries time will differ

1)Registration Report Per day

SELECT reg_type,count(reg_type) FROM regprc.registration where cr_dtimes >= '2022-07-18 16:00:00' and cr_dtimes <= '2022-07-19 15:59:59' group by reg_type;

2) Uins are Generated per day

select count(*) From registration where status_code='PROCESSED' and latest_trn_type_code='PRINT_SERVICE' and latest_trn_dtimes >= '2022-07-25 16:00:00' and latest_trn_dtimes <= '2022-07-26 15:59:59';

Sample Report Link

3) Stage-wise Report Per day

select trn_type_code, status_code, count(id),COUNT(DISTINCT reg_id) from regprc.registration_transaction where
(cr_dtimes between '2022-06-19 16:00:00' and '2022-06-20 15:59:59')
group by trn_type_code, status_code order by trn_type_code

Sample 2-hour Report

4)Print Records Per day

5)Template extraction Per day