To monitor the philsys data we are generating the report on the need Bases
Here are some import queries to get the Data and count
In the Philsys uploaded packets will be stuck in the secure zone notification stage on the basis of configuration in the registration Processor .mz properties then Reprocessor kicked in and Prcoess teh packets on the basis of the latest_trn_dtims in the registration table (FIFO)
1)Reprocessor Query
Info
| Info |
|---|
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
| Info |
|---|
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'; |
...
3) Stage-wise Report Per day
| Info |
|---|
select trn_type_code, status_code, count(id),COUNT(DISTINCT reg_id) from regprc.registration_transaction where |
3) 24Sample 2-hour Report query (How many UINs were generated and moved to Printing stage )
...
4)Print Records Per day
| Info |
|---|
select count(*) From registration from credential.credential_transaction where status_code='PROCESSEDISSUED' and latest_trn_type_code='PRINT_SERVICE' and latest_trn_dtimes >= 'issuancedate>='2022-07-25 26 16:00:00' and latest_trn_dtimes issuancedate <= '2022-07-26 27 15:59:59' and request like '%print%'; |
4)How many Packets uploaded per day
SELECT reg_type5)Template extraction Per day
| Info |
|---|
select status_code,count( |
...
*) from credential.credential_transaction where upd_dtimes>='2023-03-02 00:00:00' and |
...
upd_dtimes <= ' |
...
2023- |
...
03- |
...
02 23:59:59' and request like '%mpartner-default-auth%' group by |
...
1 |