
[2025-07-16 Wed 00:54:22] : *********************** START Data Parsing Error Checker**************************
[2025-07-16 Wed 00:54:22] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2025-07-16'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2025-07-16 Wed 00:54:22] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2025-07-16 Wed 00:54:22] : Connection closed
[2025-07-16 Wed 00:54:22] : ************************ END ***************************
[2025-07-16 Wed 01:04:08] : *********************** START Data Parsing Error Checker**************************
[2025-07-16 Wed 01:04:08] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2025-07-16'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2025-07-16 Wed 01:04:08] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server Additional SMTP info: php_network_getaddresses: getaddrinfo failed: Name or service not known
[2025-07-16 Wed 01:04:08] : Connection closed
[2025-07-16 Wed 01:04:08] : ************************ END ***************************
[2025-07-16 Wed 04:18:53] : SELECT DISTINCT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, sis.`executed_date` AS date_bd
		FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
		LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
		WHERE sis.`status`='Active' AND sis.`executed_date` = '2025-07-16' AND sis.status_value = ''
[2025-07-16 Wed 04:18:54] : *********************** START **************************
[2025-07-16 Wed 04:18:54] : There is no empty or blank record!!!
[2025-07-16 Wed 04:18:54] : SSL Info Recheck Result: 0
[2025-07-16 Wed 04:18:54] : ************************ END ***************************
[2025-07-16 Wed 04:30:05] : *********************** START **************************
[2025-07-16 Wed 04:30:05] : select id, ssl_status_code from ssl_status_code where status='Active'
[2025-07-16 Wed 04:30:05] : SSL Status Code Result: 8
[2025-07-16 Wed 04:30:05] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2025-07-16 Wed 04:30:05] : SSL Info Result: 5
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Batch ID: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_FROM
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,1,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_TO
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,2,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,3,'','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,4,'','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE_DESC
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,5,'','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_NAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,6,'','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_COUNTRY
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,7,'','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,8,'','2025-07-16 04:30:05#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Batch ID: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_FROM
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,1,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_TO
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,2,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,3,'','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,4,'','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE_DESC
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,5,'','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_NAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,6,'','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_COUNTRY
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,7,'','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,8,'','2025-07-16 04:30:05#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Batch ID: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_FROM
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,1,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_TO
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,3,'','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,4,'','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE_DESC
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_NAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,6,'','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_COUNTRY
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,7,'','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,8,'','2025-07-16 04:30:05#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Batch ID: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_FROM
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,1,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_TO
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,3,'','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,4,'','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE_DESC
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_NAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,6,'','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_COUNTRY
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,7,'','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,8,'','2025-07-16 04:30:05#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Batch ID: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_FROM
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,1,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : VALID_TO
[2025-07-16 Wed 04:30:05] : 1970-01-01 06:00:00
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,2,'1970-01-01 06:00:00','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,3,'','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,4,'','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : SIGNATURE_DESC
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,5,'','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_NAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,6,'','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_COUNTRY
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,7,'','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Misc Test: 2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 04:30:05] : ISSUER_CNAME
[2025-07-16 Wed 04:30:05] : 
[2025-07-16 Wed 04:30:05] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,8,'','2025-07-16 04:30:05#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 04:30:05','2025-07-15 22:30:05','get-ssl-info.php')
[2025-07-16 Wed 04:30:05] : 1
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 04:30:05] : Connection closed
[2025-07-16 Wed 04:30:05] : ************************ END ***************************
[2025-07-16 Wed 05:00:04] : SELECT DISTINCT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, sis.`executed_date` AS date_bd
		FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
		LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
		WHERE sis.`status`='Active' AND sis.`executed_date` = '2025-07-16' AND sis.status_value = ''
[2025-07-16 Wed 05:00:04] : *********************** START **************************
[2025-07-16 Wed 05:00:04] : select id, ssl_status_code from ssl_status_code where status='Active'
[2025-07-16 Wed 05:00:04] : SSL Status Code Result: 8
[2025-07-16 Wed 05:00:04] : SSL Info Result: 5
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : Batch ID: 2025-07-16 05:00:04#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443
[2025-07-16 Wed 05:00:04] : Empty data fetched!!!
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : Batch ID: 2025-07-16 05:00:04#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443
[2025-07-16 Wed 05:00:04] : Empty data fetched!!!
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : Batch ID: 2025-07-16 05:00:04#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443
[2025-07-16 Wed 05:00:04] : Empty data fetched!!!
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : Batch ID: 2025-07-16 05:00:04#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443
[2025-07-16 Wed 05:00:04] : Empty data fetched!!!
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : Batch ID: 2025-07-16 05:00:04#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443
[2025-07-16 Wed 05:00:04] : Empty data fetched!!!
[2025-07-16 Wed 05:00:04] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 05:00:04] : Connection closed
[2025-07-16 Wed 05:00:04] : ************************ END ***************************
[2025-07-16 Wed 06:00:14] : *********************** START Send Deviation Alert**************************
[2025-07-16 Wed 06:00:14] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, ssc.ssl_status_code, ssc.ssl_status_code_desc, sis.status_value, sis.`executed_date` AS date_bd
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2025-07-16'
				) t1
				LEFT OUTER JOIN
				(
				SELECT si.id AS id_1, si.website_name AS website_name_1, si.website_url AS website_url_1, si.website_port AS website_port_1, si.`website_org` AS website_org_1, ssc.ssl_status_code AS ssl_status_code_1, ssc.ssl_status_code_desc AS ssl_status_code_desc_1, 
				sis.status_value AS status_value_1, sis.`executed_date` AS date_bd_1
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2025-07-15'

				) t2 ON t1.id=t2.id_1 AND t1.ssl_status_code=t2.ssl_status_code_1
				ORDER BY t1.`website_org`, t1.`website_name`, t1.`ssl_status_code`, t1.`date_bd` DESC
[2025-07-16 Wed 06:00:14] : Total Record Fetch: 40
[2025-07-16 Wed 06:00:14] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2025-07-16 Wed 06:00:14] : Mail sent on 2025-07-16 06:00:14
[2025-07-16 Wed 06:00:14] : Connection closed
[2025-07-16 Wed 06:00:14] : ************************ END ***************************
[2025-07-16 Wed 06:30:05] : *********************** START Send Deviation Alert**************************
[2025-07-16 Wed 06:30:05] : SELECT DISTINCT t1.*,t2.*  FROM 
				(
				SELECT si.id, si.website_name, si.website_url, si.`website_port`, si.`website_org`, ssc.ssl_status_code, ssc.ssl_status_code_desc, sis.status_value, sis.`executed_date` AS date_bd
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2025-07-16'
				) t1
				LEFT OUTER JOIN
				(
				SELECT si.id AS id_1, si.website_name AS website_name_1, si.website_url AS website_url_1, si.website_port AS website_port_1, si.`website_org` AS website_org_1, ssc.ssl_status_code AS ssl_status_code_1, ssc.ssl_status_code_desc AS ssl_status_code_desc_1, 
				sis.status_value AS status_value_1, sis.`executed_date` AS date_bd_1
				FROM ssl_info si LEFT OUTER JOIN ssl_info_status sis ON si.id=sis.`ssl_info_id` 
				LEFT OUTER JOIN ssl_status_code ssc ON sis.`ssl_status_code_id`=ssc.`id` 
				WHERE sis.`status`='Active' AND sis.`executed_date` = '2025-07-15'

				) t2 ON t1.id=t2.id_1 AND t1.ssl_status_code=t2.ssl_status_code_1
				ORDER BY t1.`website_org`, t1.`website_name`, t1.`ssl_status_code`, t1.`date_bd` DESC
[2025-07-16 Wed 06:30:06] : Total Record Fetch: 40
[2025-07-16 Wed 06:30:06] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2025-07-16 Wed 06:30:06] : Mail sent on 2025-07-16 06:30:05
[2025-07-16 Wed 06:30:06] : Connection closed
[2025-07-16 Wed 06:30:06] : ************************ END ***************************
[2025-07-16 Wed 15:08:02] : *********************** START **************************
[2025-07-16 Wed 15:08:02] : select id, ssl_status_code from ssl_status_code where status='Active'
[2025-07-16 Wed 15:08:02] : SSL Status Code Result: 8
[2025-07-16 Wed 15:08:02] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2025-07-16 Wed 15:08:02] : SSL Info Result: 5
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Batch ID: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_FROM
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,1,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_TO
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,2,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,3,'','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,4,'','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE_DESC
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,5,'','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_NAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,6,'','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_COUNTRY
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,7,'','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,8,'','2025-07-16 15:08:02#WebName_UCB Website#SSLInfoId_1#WebURL_https://www.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Batch ID: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_FROM
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,1,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_TO
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,2,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,3,'','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,4,'','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE_DESC
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,5,'','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_NAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,6,'','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_COUNTRY
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,7,'','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,8,'','2025-07-16 15:08:02#WebName_UNet Website#SSLInfoId_2#WebURL_https://unet.ucb.com.bd#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Batch ID: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_FROM
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,1,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_TO
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,3,'','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,4,'','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE_DESC
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_NAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,6,'','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_COUNTRY
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,7,'','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,8,'','2025-07-16 15:08:02#WebName_Infosec4allz#SSLInfoId_4#WebURL_https://infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Batch ID: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_FROM
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,1,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_TO
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,3,'','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,4,'','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE_DESC
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_NAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,6,'','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_COUNTRY
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,7,'','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,8,'','2025-07-16 15:08:02#WebName_UPay#SSLInfoId_5#WebURL_https://www.upaybd.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Batch ID: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_FROM
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,1,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : VALID_TO
[2025-07-16 Wed 15:08:02] : 1970-01-01 06:00:00
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,2,'1970-01-01 06:00:00','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,3,'','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,4,'','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : SIGNATURE_DESC
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,5,'','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_NAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,6,'','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_COUNTRY
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,7,'','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Misc Test: 2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2025-07-16 Wed 15:08:02] : ISSUER_CNAME
[2025-07-16 Wed 15:08:02] : 
[2025-07-16 Wed 15:08:02] : INSERT INTO ssl_info_status (ssl_info_id, ssl_status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (7,8,'','2025-07-16 15:08:02#WebName_Dev_Infosec4allz#SSLInfoId_7#WebURL_https://dev.infosec4allz.com#WebPort_443','2025-07-16','2025-07-16 15:08:02','2025-07-16 15:08:02','get-ssl-info.php')
[2025-07-16 Wed 15:08:02] : 1
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2025-07-16 Wed 15:08:02] : Connection closed
[2025-07-16 Wed 15:08:02] : ************************ END ***************************
[2025-07-16 Wed 21:46:40] : *********************** START Data Parsing Error Checker**************************
[2025-07-16 Wed 21:46:40] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2025-07-16'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2025-07-16 Wed 21:46:40] : Total Record Fetch: 12
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-06-03<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.4.7<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-05-21<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.0.0<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2024-12-10<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.1.4<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-05-21<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.0.1<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-06-02<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.57<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2025-05-08<br />
[2025-07-16 Wed 21:46:40] : 2025-07-16 04:00:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.25<br />
[2025-07-16 Wed 21:46:40] : Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/TroubleshootingSMTP server error: Failed to connect to server
[2025-07-16 Wed 21:46:40] : Connection closed
[2025-07-16 Wed 21:46:40] : ************************ END ***************************