[2026-05-06 Wed 01:43:43] : *********************** START Test Script Checking**************************
[2026-05-06 Wed 01:43:43] : Script Executed Successfully
[2026-05-06 Wed 01:43:43] : ************************ END ***************************
[2026-05-06 Wed 01:55:16] : *********************** START **************************
[2026-05-06 Wed 01:55:16] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-06 Wed 01:55:16] : SSL Status Code Result: 8
[2026-05-06 Wed 01:55:16] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-06 Wed 01:55:16] : SSL Info Result: 2
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Batch ID: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : VALID_FROM
[2026-05-06 Wed 01:55:16] : 2026-03-16 11:56:00
[2026-05-06 Wed 01:55:16] : 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 (8,1,'2026-03-16 11:56:00','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : VALID_TO
[2026-05-06 Wed 01:55:16] : 2026-06-14 11:55:59
[2026-05-06 Wed 01:55:16] : 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 (8,2,'2026-06-14 11:55:59','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : CNAME
[2026-05-06 Wed 01:55:16] : citybankplc.com
[2026-05-06 Wed 01:55:16] : 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 (8,3,'citybankplc.com','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : SIGNATURE
[2026-05-06 Wed 01:55:16] : RSA-SHA256
[2026-05-06 Wed 01:55:16] : 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 (8,4,'RSA-SHA256','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : SIGNATURE_DESC
[2026-05-06 Wed 01:55:16] : sha256WithRSAEncryption
[2026-05-06 Wed 01:55:16] : 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 (8,5,'sha256WithRSAEncryption','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : ISSUER_NAME
[2026-05-06 Wed 01:55:16] : Let's Encrypt
[2026-05-06 Wed 01:55:16] : 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 (8,6,'Let\'s Encrypt','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : ISSUER_COUNTRY
[2026-05-06 Wed 01:55:16] : US
[2026-05-06 Wed 01:55:16] : 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 (8,7,'US','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Misc Test: 2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 01:55:16] : ISSUER_CNAME
[2026-05-06 Wed 01:55:16] : R12
[2026-05-06 Wed 01:55:16] : 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 (8,8,'R12','2026-05-06 01:55:16#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:16] : 1
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:16] : Batch ID: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : VALID_FROM
[2026-05-06 Wed 01:55:18] : 2025-06-22 06:00:00
[2026-05-06 Wed 01:55:18] : 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 (9,1,'2025-06-22 06:00:00','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : VALID_TO
[2026-05-06 Wed 01:55:18] : 2026-06-22 05:59:59
[2026-05-06 Wed 01:55:18] : 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 (9,2,'2026-06-22 05:59:59','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : CNAME
[2026-05-06 Wed 01:55:18] : www.citytouch.com.bd
[2026-05-06 Wed 01:55:18] : 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 (9,3,'www.citytouch.com.bd','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : SIGNATURE
[2026-05-06 Wed 01:55:18] : RSA-SHA256
[2026-05-06 Wed 01:55:18] : 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 (9,4,'RSA-SHA256','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : SIGNATURE_DESC
[2026-05-06 Wed 01:55:18] : sha256WithRSAEncryption
[2026-05-06 Wed 01:55:18] : 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 (9,5,'sha256WithRSAEncryption','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : ISSUER_NAME
[2026-05-06 Wed 01:55:18] : DigiCert Inc
[2026-05-06 Wed 01:55:18] : 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 (9,6,'DigiCert Inc','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : ISSUER_COUNTRY
[2026-05-06 Wed 01:55:18] : US
[2026-05-06 Wed 01:55:18] : 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 (9,7,'US','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Misc Test: 2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 01:55:18] : ISSUER_CNAME
[2026-05-06 Wed 01:55:18] : DigiCert EV RSA CA G2
[2026-05-06 Wed 01:55:18] : 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 (9,8,'DigiCert EV RSA CA G2','2026-05-06 01:55:16#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:55:16','2026-05-06 01:55:16','get-ssl-info.php')
[2026-05-06 Wed 01:55:18] : 1
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:55:18] : Connection closed
[2026-05-06 Wed 01:55:18] : ************************ END ***************************
[2026-05-06 Wed 01:56:49] : *********************** START **************************
[2026-05-06 Wed 01:56:49] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-06 Wed 01:56:49] : SSL Status Code Result: 8
[2026-05-06 Wed 01:56:49] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-06 Wed 01:56:49] : SSL Info Result: 2
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Batch ID: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : VALID_FROM
[2026-05-06 Wed 01:56:49] : 2026-03-16 11:56:00
[2026-05-06 Wed 01:56:49] : 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 (8,1,'2026-03-16 11:56:00','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : VALID_TO
[2026-05-06 Wed 01:56:49] : 2026-06-14 11:55:59
[2026-05-06 Wed 01:56:49] : 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 (8,2,'2026-06-14 11:55:59','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : CNAME
[2026-05-06 Wed 01:56:49] : citybankplc.com
[2026-05-06 Wed 01:56:49] : 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 (8,3,'citybankplc.com','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : SIGNATURE
[2026-05-06 Wed 01:56:49] : RSA-SHA256
[2026-05-06 Wed 01:56:49] : 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 (8,4,'RSA-SHA256','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : SIGNATURE_DESC
[2026-05-06 Wed 01:56:49] : sha256WithRSAEncryption
[2026-05-06 Wed 01:56:49] : 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 (8,5,'sha256WithRSAEncryption','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : ISSUER_NAME
[2026-05-06 Wed 01:56:49] : Let's Encrypt
[2026-05-06 Wed 01:56:49] : 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 (8,6,'Let\'s Encrypt','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : ISSUER_COUNTRY
[2026-05-06 Wed 01:56:49] : US
[2026-05-06 Wed 01:56:49] : 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 (8,7,'US','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Misc Test: 2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 01:56:49] : ISSUER_CNAME
[2026-05-06 Wed 01:56:49] : R12
[2026-05-06 Wed 01:56:49] : 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 (8,8,'R12','2026-05-06 01:56:49#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:49] : 1
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:49] : Batch ID: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : VALID_FROM
[2026-05-06 Wed 01:56:50] : 2025-06-22 06:00:00
[2026-05-06 Wed 01:56:50] : 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 (9,1,'2025-06-22 06:00:00','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : VALID_TO
[2026-05-06 Wed 01:56:50] : 2026-06-22 05:59:59
[2026-05-06 Wed 01:56:50] : 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 (9,2,'2026-06-22 05:59:59','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : CNAME
[2026-05-06 Wed 01:56:50] : www.citytouch.com.bd
[2026-05-06 Wed 01:56:50] : 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 (9,3,'www.citytouch.com.bd','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : SIGNATURE
[2026-05-06 Wed 01:56:50] : RSA-SHA256
[2026-05-06 Wed 01:56:50] : 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 (9,4,'RSA-SHA256','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : SIGNATURE_DESC
[2026-05-06 Wed 01:56:50] : sha256WithRSAEncryption
[2026-05-06 Wed 01:56:50] : 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 (9,5,'sha256WithRSAEncryption','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : ISSUER_NAME
[2026-05-06 Wed 01:56:50] : DigiCert Inc
[2026-05-06 Wed 01:56:50] : 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 (9,6,'DigiCert Inc','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : ISSUER_COUNTRY
[2026-05-06 Wed 01:56:50] : US
[2026-05-06 Wed 01:56:50] : 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 (9,7,'US','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Misc Test: 2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 01:56:50] : ISSUER_CNAME
[2026-05-06 Wed 01:56:50] : DigiCert EV RSA CA G2
[2026-05-06 Wed 01:56:50] : 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 (9,8,'DigiCert EV RSA CA G2','2026-05-06 01:56:49#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 01:56:49','2026-05-06 01:56:49','get-ssl-info.php')
[2026-05-06 Wed 01:56:50] : 1
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 01:56:50] : Connection closed
[2026-05-06 Wed 01:56:50] : ************************ END ***************************
[2026-05-06 Wed 01:58:30] : 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` = '2026-05-06' AND sis.status_value = ''
[2026-05-06 Wed 01:58:30] : *********************** START **************************
[2026-05-06 Wed 01:58:30] : There is no empty or blank record!!!
[2026-05-06 Wed 01:58:30] : SSL Info Recheck Result: 0
[2026-05-06 Wed 01:58:30] : ************************ END ***************************
[2026-05-06 Wed 04:30:03] : *********************** START **************************
[2026-05-06 Wed 04:30:03] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-06 Wed 04:30:03] : SSL Status Code Result: 8
[2026-05-06 Wed 04:30:03] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-06 Wed 04:30:03] : SSL Info Result: 2
[2026-05-06 Wed 04:30:03] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:03] : Batch ID: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : VALID_FROM
[2026-05-06 Wed 04:30:04] : 2026-03-16 11:56:00
[2026-05-06 Wed 04:30:04] : 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 (8,1,'2026-03-16 11:56:00','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : VALID_TO
[2026-05-06 Wed 04:30:04] : 2026-06-14 11:55:59
[2026-05-06 Wed 04:30:04] : 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 (8,2,'2026-06-14 11:55:59','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : CNAME
[2026-05-06 Wed 04:30:04] : citybankplc.com
[2026-05-06 Wed 04:30:04] : 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 (8,3,'citybankplc.com','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : SIGNATURE
[2026-05-06 Wed 04:30:04] : RSA-SHA256
[2026-05-06 Wed 04:30:04] : 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 (8,4,'RSA-SHA256','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : SIGNATURE_DESC
[2026-05-06 Wed 04:30:04] : sha256WithRSAEncryption
[2026-05-06 Wed 04:30:04] : 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 (8,5,'sha256WithRSAEncryption','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : ISSUER_NAME
[2026-05-06 Wed 04:30:04] : Let's Encrypt
[2026-05-06 Wed 04:30:04] : 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 (8,6,'Let\'s Encrypt','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : ISSUER_COUNTRY
[2026-05-06 Wed 04:30:04] : US
[2026-05-06 Wed 04:30:04] : 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 (8,7,'US','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Misc Test: 2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 04:30:04] : ISSUER_CNAME
[2026-05-06 Wed 04:30:04] : R12
[2026-05-06 Wed 04:30:04] : 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 (8,8,'R12','2026-05-06 04:30:03#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:04] : 1
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:04] : Batch ID: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : VALID_FROM
[2026-05-06 Wed 04:30:05] : 2025-06-22 06:00:00
[2026-05-06 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 (9,1,'2025-06-22 06:00:00','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : VALID_TO
[2026-05-06 Wed 04:30:05] : 2026-06-22 05:59:59
[2026-05-06 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 (9,2,'2026-06-22 05:59:59','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : CNAME
[2026-05-06 Wed 04:30:05] : www.citytouch.com.bd
[2026-05-06 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 (9,3,'www.citytouch.com.bd','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : SIGNATURE
[2026-05-06 Wed 04:30:05] : RSA-SHA256
[2026-05-06 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 (9,4,'RSA-SHA256','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : SIGNATURE_DESC
[2026-05-06 Wed 04:30:05] : sha256WithRSAEncryption
[2026-05-06 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 (9,5,'sha256WithRSAEncryption','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : ISSUER_NAME
[2026-05-06 Wed 04:30:05] : DigiCert Inc
[2026-05-06 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 (9,6,'DigiCert Inc','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : ISSUER_COUNTRY
[2026-05-06 Wed 04:30:05] : US
[2026-05-06 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 (9,7,'US','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Misc Test: 2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 04:30:05] : ISSUER_CNAME
[2026-05-06 Wed 04:30:05] : DigiCert EV RSA CA G2
[2026-05-06 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 (9,8,'DigiCert EV RSA CA G2','2026-05-06 04:30:03#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 04:30:03','2026-05-05 22:30:03','get-ssl-info.php')
[2026-05-06 Wed 04:30:05] : 1
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 04:30:05] : Connection closed
[2026-05-06 Wed 04:30:05] : ************************ END ***************************
[2026-05-06 Wed 05:00:02] : 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` = '2026-05-06' AND sis.status_value = ''
[2026-05-06 Wed 05:00:02] : *********************** START **************************
[2026-05-06 Wed 05:00:02] : There is no empty or blank record!!!
[2026-05-06 Wed 05:00:02] : SSL Info Recheck Result: 0
[2026-05-06 Wed 05:00:02] : ************************ END ***************************
[2026-05-06 Wed 06:30:02] : *********************** START Send Deviation Alert**************************
[2026-05-06 Wed 06:30:02] : 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` = '2026-05-06'
				) 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` = '2026-05-05'

				) 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
[2026-05-06 Wed 06:30:03] : Total Record Fetch: 16
[2026-05-06 Wed 06:30:03] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-05-06 Wed 06:30:03] : Mail sent on 2026-05-06 06:30:02
[2026-05-06 Wed 06:30:03] : Connection closed
[2026-05-06 Wed 06:30:03] : ************************ END ***************************
[2026-05-06 Wed 22:18:10] : *********************** START Send Deviation Alert**************************
[2026-05-06 Wed 22:18:10] : 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` = '2026-05-06'
				) 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` = '2026-05-05'

				) 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
[2026-05-06 Wed 22:18:11] : Total Record Fetch: 16
[2026-05-06 Wed 22:18:11] : <h1 style="color:green">No Mismatch Found!!!</h1>
[2026-05-06 Wed 22:18:12] : Mail sent on 2026-05-06 22:18:10
[2026-05-06 Wed 22:18:12] : Connection closed
[2026-05-06 Wed 22:18:12] : ************************ END ***************************
[2026-05-06 Wed 22:19:35] : *********************** START **************************
[2026-05-06 Wed 22:19:35] : select id, ssl_status_code from ssl_status_code where status='Active'
[2026-05-06 Wed 22:19:35] : SSL Status Code Result: 8
[2026-05-06 Wed 22:19:35] : select id, website_name, website_url, website_port from ssl_info where scheduler_status='Active' and status='Active'
[2026-05-06 Wed 22:19:35] : SSL Info Result: 2
[2026-05-06 Wed 22:19:35] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:35] : Batch ID: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : VALID_FROM
[2026-05-06 Wed 22:19:36] : 2026-03-16 11:56:00
[2026-05-06 Wed 22:19:36] : 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 (8,1,'2026-03-16 11:56:00','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : VALID_TO
[2026-05-06 Wed 22:19:36] : 2026-06-14 11:55:59
[2026-05-06 Wed 22:19:36] : 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 (8,2,'2026-06-14 11:55:59','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : CNAME
[2026-05-06 Wed 22:19:36] : citybankplc.com
[2026-05-06 Wed 22:19:36] : 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 (8,3,'citybankplc.com','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : SIGNATURE
[2026-05-06 Wed 22:19:36] : RSA-SHA256
[2026-05-06 Wed 22:19:36] : 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 (8,4,'RSA-SHA256','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : SIGNATURE_DESC
[2026-05-06 Wed 22:19:36] : sha256WithRSAEncryption
[2026-05-06 Wed 22:19:36] : 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 (8,5,'sha256WithRSAEncryption','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : ISSUER_NAME
[2026-05-06 Wed 22:19:36] : Let's Encrypt
[2026-05-06 Wed 22:19:36] : 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 (8,6,'Let\'s Encrypt','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : ISSUER_COUNTRY
[2026-05-06 Wed 22:19:36] : US
[2026-05-06 Wed 22:19:36] : 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 (8,7,'US','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Misc Test: 2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 22:19:36] : ISSUER_CNAME
[2026-05-06 Wed 22:19:36] : R12
[2026-05-06 Wed 22:19:36] : 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 (8,8,'R12','2026-05-06 22:19:35#WebName_City Bank Website#SSLInfoId_8#WebURL_https://www.citybankplc.com#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:36] : 1
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : <<<<<<<<<<<<<<<<<<<<START SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:36] : Batch ID: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_FROM --> 1 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : VALID_FROM
[2026-05-06 Wed 22:19:37] : 2025-06-22 06:00:00
[2026-05-06 Wed 22:19:37] : 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 (9,1,'2025-06-22 06:00:00','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> VALID_TO --> 2 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : VALID_TO
[2026-05-06 Wed 22:19:37] : 2026-06-22 05:59:59
[2026-05-06 Wed 22:19:37] : 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 (9,2,'2026-06-22 05:59:59','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> CNAME --> 3 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : CNAME
[2026-05-06 Wed 22:19:37] : www.citytouch.com.bd
[2026-05-06 Wed 22:19:37] : 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 (9,3,'www.citytouch.com.bd','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE --> 4 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : SIGNATURE
[2026-05-06 Wed 22:19:37] : RSA-SHA256
[2026-05-06 Wed 22:19:37] : 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 (9,4,'RSA-SHA256','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> SIGNATURE_DESC --> 5 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : SIGNATURE_DESC
[2026-05-06 Wed 22:19:37] : sha256WithRSAEncryption
[2026-05-06 Wed 22:19:37] : 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 (9,5,'sha256WithRSAEncryption','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_NAME --> 6 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : ISSUER_NAME
[2026-05-06 Wed 22:19:37] : DigiCert Inc
[2026-05-06 Wed 22:19:37] : 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 (9,6,'DigiCert Inc','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_COUNTRY --> 7 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : ISSUER_COUNTRY
[2026-05-06 Wed 22:19:37] : US
[2026-05-06 Wed 22:19:37] : 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 (9,7,'US','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<START SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Misc Test: 2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443 --> ISSUER_CNAME --> 8 --> get-ssl-info.php
[2026-05-06 Wed 22:19:37] : ISSUER_CNAME
[2026-05-06 Wed 22:19:37] : DigiCert EV RSA CA G2
[2026-05-06 Wed 22:19:37] : 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 (9,8,'DigiCert EV RSA CA G2','2026-05-06 22:19:35#WebName_City Touch Website#SSLInfoId_9#WebURL_https://www.citytouch.com.bd#WebPort_443','2026-05-06','2026-05-06 22:19:35','2026-05-06 22:19:35','get-ssl-info.php')
[2026-05-06 Wed 22:19:37] : 1
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Status Code wise Info Fetch>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : <<<<<<<<<<<<<<<<<<<<END SSL Info Loop>>>>>>>>>>>>>>>>>>>>
[2026-05-06 Wed 22:19:37] : Connection closed
[2026-05-06 Wed 22:19:37] : ************************ END ***************************
[2026-05-06 Wed 22:20:56] : 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` = '2026-05-06' AND sis.status_value = ''
[2026-05-06 Wed 22:20:56] : *********************** START **************************
[2026-05-06 Wed 22:20:56] : There is no empty or blank record!!!
[2026-05-06 Wed 22:20:56] : SSL Info Recheck Result: 0
[2026-05-06 Wed 22:20:56] : ************************ END ***************************