========================2023-04-13 09:40:45======================== noteurl_start parm_app_code = 047 parm_pc_name = HANKILSA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9C6B0000F76FF6E13F6E sCDKey = 679110813017 sName = HANKILSA ========================2023-04-13 09:40:45======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '679110813017' AND r.app_code = '047' AND r.app_block = 0 ========================2023-04-13 09:40:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jung382' ========================2023-04-13 09:40:46======================== SELECT idx FROM macs WHERE mac_addr = '9C6B0000F76FF6E13F6E' AND app_code = '047' ========================2023-04-13 09:40:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386045' ========================2023-04-13 09:40:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386045' ========================2023-04-13 09:40:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '386045', '9C6B0000F76FF6E13F6E', '047', 'HANKILSA', '�쐢�룄�슦 10', '0', '0', 'jung382', '한길사[정명진]', '679110813017' ) ========================2023-04-13 14:11:54======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GHTP11R parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73383C070EEF09AE sCDKey = 461609832074 sName = DESKTOP-GHTP11R ========================2023-04-13 14:11:54======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '461609832074' AND r.app_code = '047' AND r.app_block = 0 ========================2023-04-13 14:11:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tim2012' ========================2023-04-13 14:11:54======================== SELECT idx FROM macs WHERE mac_addr = '50AF73383C070EEF09AE' AND app_code = '047' ========================2023-04-13 14:11:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347765' ========================2023-04-13 14:11:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347765' ========================2023-04-13 14:11:54======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GHTP11R', os_type = '�쐢�룄�슦 10', user_id = 'tim2012', user_name = '(주)팀크리에이티브[홍범영]', screen_w = '0', screen_h = '0', cdkey = '461609832074' WHERE mac_idx = '347765' ========================2023-04-13 14:12:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73364123EE2B1141 sCDKey = 461609832074 sName = DESKTOP-IR4BE71 ========================2023-04-13 14:12:23======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '461609832074' AND r.app_code = '047' AND r.app_block = 0 ========================2023-04-13 14:12:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tim2012' ========================2023-04-13 14:12:23======================== SELECT idx FROM macs WHERE mac_addr = '50AF73364123EE2B1141' AND app_code = '047' ========================2023-04-13 14:12:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334505' ========================2023-04-13 14:12:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334505' ========================2023-04-13 14:12:23======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IR4BE71', os_type = '�쐢�룄�슦 10', user_id = 'tim2012', user_name = '(주)팀크리에이티브[홍범영]', screen_w = '0', screen_h = '0', cdkey = '461609832074' WHERE mac_idx = '334505' ========================2023-04-13 14:40:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3363CEJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2302EA42EC3FC67 sCDKey = 737699781943 sName = DESKTOP-3363CEJ ========================2023-04-13 14:40:43======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '737699781943' AND r.app_code = '039' AND r.app_block = 0 ========================2023-04-13 14:40:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dwriro75' ========================2023-04-13 14:40:43======================== SELECT idx FROM macs WHERE mac_addr = '7085C2302EA42EC3FC67' AND app_code = '039' ========================2023-04-13 14:40:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386093' ========================2023-04-13 14:40:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386093' ========================2023-04-13 14:40:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '386093', '7085C2302EA42EC3FC67', '039', 'DESKTOP-3363CEJ', '110', '1920', '1080', 'dwriro75', '(주)엘엠에스코리아[김용수]', '737699781943' ) ========================2023-04-13 14:54:20======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DC4DE7646F7D14 sCDKey = 959905592383 sName = IPOS-HDXP ========================2023-04-13 14:54:20======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 14:54:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 14:54:20======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DC4DE7646F7D14' AND app_code = '046' ========================2023-04-13 14:54:20======================== 값이 없을 경우 ========================2023-04-13 14:55:16======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DC4DE7646F7D14 sCDKey = 959905592383 sName = IPOS-HDXP ========================2023-04-13 14:55:16======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 14:55:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 14:55:16======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DC4DE7646F7D14' AND app_code = '046' ========================2023-04-13 14:55:16======================== 값이 없을 경우 ========================2023-04-13 15:01:57======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DC4DE7646F7D14 sCDKey = 959905592383 sName = IPOS-HDXP ========================2023-04-13 15:01:57======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:01:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 15:01:57======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DC4DE7646F7D14' AND app_code = '046' ========================2023-04-13 15:01:57======================== 값이 없을 경우 ========================2023-04-13 15:02:00======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DC4DE7646F7D14 sCDKey = 959905592383 sName = IPOS-HDXP ========================2023-04-13 15:02:00======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:02:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 15:02:00======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DC4DE7646F7D14' AND app_code = '046' ========================2023-04-13 15:02:00======================== 값이 없을 경우 ========================2023-04-13 15:06:58======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DC4DE7646F7D14 sCDKey = 959905592383 sName = IPOS-HDXP ========================2023-04-13 15:06:58======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:06:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 15:06:58======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DC4DE7646F7D14' AND app_code = '046' ========================2023-04-13 15:06:58======================== 값이 없을 경우 ========================2023-04-13 15:12:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LMTTFAS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CFDA15EB6017443D6BE sCDKey = 374148714767 sName = DESKTOP-LMTTFAS ========================2023-04-13 15:12:06======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '374148714767' AND r.app_code = '039' AND r.app_block = 0 ========================2023-04-13 15:12:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bongsan340' ========================2023-04-13 15:12:06======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15EB6017443D6BE' AND app_code = '039' ========================2023-04-13 15:12:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386100' ========================2023-04-13 15:12:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386100' ========================2023-04-13 15:12:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '386100', '2CFDA15EB6017443D6BE', '039', 'DESKTOP-LMTTFAS', '110', '1920', '1080', 'bongsan340', '대건초경[최택규]', '374148714767' ) ========================2023-04-13 15:12:15======================== noteurl_start parm_app_code = 046 parm_pc_name = MINJU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE5C54A0AD7F sCDKey = 879640962569 sName = MINJU ========================2023-04-13 15:12:15======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '879640962569' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:12:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kmj0801' ========================2023-04-13 15:12:15======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE5C54A0AD7F' AND app_code = '046' ========================2023-04-13 15:12:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345009' ========================2023-04-13 15:12:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345009' ========================2023-04-13 15:12:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '345009', 'F44D30B9AE5C54A0AD7F', '046', 'MINJU', '110', '1920', '1080', 'kmj0801', '[김민주]', '879640962569' ) ========================2023-04-13 15:14:51======================== noteurl_start parm_app_code = 046 parm_pc_name = CHOISH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 305A3A58E5C6782808EF sCDKey = 959905592383 sName = CHOISH-PC ========================2023-04-13 15:14:51======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:14:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 15:14:51======================== SELECT idx FROM macs WHERE mac_addr = '305A3A58E5C6782808EF' AND app_code = '046' ========================2023-04-13 15:14:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386101' ========================2023-04-13 15:14:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386101' ========================2023-04-13 15:14:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '386101', '305A3A58E5C6782808EF', '046', 'CHOISH-PC', '110', '1920', '1080', 'sun55', '주식회사다인유통[류나영]', '959905592383' ) ========================2023-04-13 15:18:49======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4DC4DE7646F7D14 sCDKey = 959905592383 sName = IPOS-HDXP ========================2023-04-13 15:18:49======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:18:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 15:18:49======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DC4DE7646F7D14' AND app_code = '046' ========================2023-04-13 15:18:49======================== 값이 없을 경우 ========================2023-04-13 15:35:48======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AA7C4FCCCFF8D74 sCDKey = 959905592383 sName = OKPOS ========================2023-04-13 15:35:48======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '959905592383' AND r.app_code = '046' AND r.app_block = 0 ========================2023-04-13 15:35:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sun55' ========================2023-04-13 15:35:48======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AA7C4FCCCFF8D74' AND app_code = '046' ========================2023-04-13 15:35:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386104' ========================2023-04-13 15:35:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386104' ========================2023-04-13 15:35:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '386104', 'B8975AA7C4FCCCFF8D74', '046', 'OKPOS', '64', '1024', '768', 'sun55', '주식회사다인유통[류나영]', '959905592383' ) ========================2023-04-13 16:07:35======================== noteurl_start parm_app_code = 050 parm_pc_name = JANG parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9983D78901CB570 sCDKey = 150938144285 sName = JANG ========================2023-04-13 16:07:35======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '150938144285' AND r.app_code = '050' AND r.app_block = 0 ========================2023-04-13 16:07:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2005' ========================2023-04-13 16:07:36======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9983D78901CB570' AND app_code = '050' ========================2023-04-13 16:07:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '385974' ========================2023-04-13 16:07:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '385974' ========================2023-04-13 16:07:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '385974', '8CB0E9983D78901CB570', '050', 'JANG', '109', '1920', '1080', 'blc2005', '은광교회[은광교회]', '150938144285' ) ========================2023-04-13 16:07:43======================== noteurl_start parm_app_code = 050 parm_pc_name = JANG parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9983D78901CB570 sCDKey = 150938144285 sName = JANG ========================2023-04-13 16:07:43======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '150938144285' AND r.app_code = '050' AND r.app_block = 0 ========================2023-04-13 16:08:51======================== noteurl_start parm_app_code = 050 parm_pc_name = BCY-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E60CB92E87FB70 sCDKey = 054670964469 sName = BCY-PC ========================2023-04-13 16:08:51======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '054670964469' AND r.app_code = '050' AND r.app_block = 0 ========================2023-04-13 16:08:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hellobang' ========================2023-04-13 16:08:51======================== SELECT idx FROM macs WHERE mac_addr = '309C23E60CB92E87FB70' AND app_code = '050' ========================2023-04-13 16:08:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '377685' ========================2023-04-13 16:08:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '377685' ========================2023-04-13 16:08:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '377685', '309C23E60CB92E87FB70', '050', 'BCY-PC', '109', '1920', '1080', 'hellobang', '엠제이소프트[방채영]', '054670964469' ) ========================2023-04-13 17:04:58======================== noteurl_start parm_app_code = 039 parm_pc_name = KSH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2A4624F1EE8E22C sCDKey = 029901884930 sName = KSH ========================2023-04-13 17:04:58======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '029901884930' AND r.app_code = '039' AND r.app_block = 0 ========================2023-04-13 17:04:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ntbk2975' ========================2023-04-13 17:04:58======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A4624F1EE8E22C' AND app_code = '039' ========================2023-04-13 17:04:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386116' ========================2023-04-13 17:04:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386116' ========================2023-04-13 17:04:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '386116', '7085C2A4624F1EE8E22C', '039', 'KSH', '110', '1920', '1080', 'ntbk2975', '앤티뱅크[김영숙]', '029901884930' )