========================2024-06-24 10:45:28======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-8CIQFF2 parm_os_type = 109 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 64E599FB3E06B4FFE751 sCDKey = 721062265539 sName = 오상목 test ========================2024-06-24 10:45:28======================== 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 = '721062265539' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 10:45:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2024-06-24 10:45:28======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06B4FFE751' AND app_code = '050' ========================2024-06-24 10:45:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390222' ========================2024-06-24 10:45:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390222' ========================2024-06-24 10:45:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390222', '64E599FB3E06B4FFE751', '050', '오상목 test', '109', '1280', '1024', 'adam5352', '다미식품[오상목]', '721062265539' ) ========================2024-06-24 10:56:24======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-8CIQFF2 parm_os_type = 109 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 64E599FB3E06B4FFE751 sCDKey = 721062265539 sName = 오상목test ========================2024-06-24 10:56:24======================== 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 = '721062265539' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 10:56:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2024-06-24 10:56:24======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06B4FFE751' AND app_code = '050' ========================2024-06-24 10:56:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390222' ========================2024-06-24 10:56:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390222' ========================2024-06-24 10:56:24======================== UPDATE mac_detail SET pc_name = '오상목test', os_type = '109', user_id = 'adam5352', user_name = '다미식품[오상목]', screen_w = '1280', screen_h = '1024', cdkey = '721062265539' WHERE mac_idx = '390222' ========================2024-06-24 13:46:01======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-IVLIJ2B parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23428DCBAF38365 sCDKey = 355449113211 sName = DESKTOP-IVLIJ2B ========================2024-06-24 13:46:01======================== 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 = '355449113211' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 13:46:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdcc' ========================2024-06-24 13:46:02======================== SELECT idx FROM macs WHERE mac_addr = '7085C23428DCBAF38365' AND app_code = '050' ========================2024-06-24 13:46:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365019' ========================2024-06-24 13:46:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '365019' ========================2024-06-24 13:46:02======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IVLIJ2B', os_type = '109', user_id = 'kdcc', user_name = '국군방첩사령부[노재용]', screen_w = '1920', screen_h = '1080', cdkey = '355449113211' WHERE mac_idx = '365019' ========================2024-06-24 14:14:50======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-IVLIJ2B parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23428DCBAF38365 sCDKey = 678905519571 sName = DESKTOP-IVLIJ2B ========================2024-06-24 14:14:50======================== 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 = '678905519571' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 14:14:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'solbar' ========================2024-06-24 14:14:50======================== SELECT idx FROM macs WHERE mac_addr = '7085C23428DCBAF38365' AND app_code = '050' ========================2024-06-24 14:14:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365019' ========================2024-06-24 14:14:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '365019' ========================2024-06-24 14:14:50======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IVLIJ2B', os_type = '109', user_id = 'solbar', user_name = '(주)솔바텍[오영근]', screen_w = '1920', screen_h = '1080', cdkey = '678905519571' WHERE mac_idx = '365019' ========================2024-06-24 14:16:20======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-IVLIJ2B parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23428DCBAF38365 sCDKey = 355449113211 sName = DESKTOP-IVLIJ2B ========================2024-06-24 14:16: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 = '355449113211' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 14:16:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdcc' ========================2024-06-24 14:16:20======================== SELECT idx FROM macs WHERE mac_addr = '7085C23428DCBAF38365' AND app_code = '050' ========================2024-06-24 14:16:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365019' ========================2024-06-24 14:16:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '365019' ========================2024-06-24 14:16:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IVLIJ2B', os_type = '109', user_id = 'kdcc', user_name = '국군방첩사령부[노재용]', screen_w = '1920', screen_h = '1080', cdkey = '355449113211' WHERE mac_idx = '365019' ========================2024-06-24 14:23:03======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-IVLIJ2B parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23428DCBAF38365 sCDKey = 355449113211 sName = DESKTOP-IVLIJ2B ========================2024-06-24 14:23:03======================== 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 = '355449113211' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 14:23:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdcc' ========================2024-06-24 14:23:03======================== SELECT idx FROM macs WHERE mac_addr = '7085C23428DCBAF38365' AND app_code = '050' ========================2024-06-24 14:23:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365019' ========================2024-06-24 14:23:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '365019' ========================2024-06-24 14:23:03======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IVLIJ2B', os_type = '109', user_id = 'kdcc', user_name = '국군방첩사령부[노재용]', screen_w = '1920', screen_h = '1080', cdkey = '355449113211' WHERE mac_idx = '365019' ========================2024-06-24 15:12:21======================== noteurl_start parm_app_code = 045 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8975A2CB5061A786739 sCDKey = 997147665538 sName = USER ========================2024-06-24 15:12:21======================== 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 = '997147665538' AND r.app_code = '045' AND r.app_block = 0 ========================2024-06-24 15:12:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jys4645' ========================2024-06-24 15:12:21======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A2CB5061A786739' AND app_code = '045' ========================2024-06-24 15:12:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407284' ========================2024-06-24 15:12:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407284' ========================2024-06-24 15:12:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407284', 'B8975A2CB5061A786739', '045', 'USER', '90', '1920', '1080', 'jys4645', '신도리코고흥컴퓨터[정연심]', '997147665538' ) ========================2024-06-24 15:20:25======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GHTP11R parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF734416D9EEF09AE sCDKey = 922507532195 sName = DESKTOP-GHTP11R ========================2024-06-24 15:20:25======================== 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 = '922507532195' AND r.app_code = '046' AND r.app_block = 0 ========================2024-06-24 15:20:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'puzzlek' ========================2024-06-24 15:20:25======================== SELECT idx FROM macs WHERE mac_addr = '50AF734416D9EEF09AE' AND app_code = '046' ========================2024-06-24 15:20:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407286' ========================2024-06-24 15:20:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407286' ========================2024-06-24 15:20:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407286', '50AF734416D9EEF09AE', '046', 'DESKTOP-GHTP11R', '110', '1024', '768', 'puzzlek', '퍼즐케이[김연주]', '922507532195' ) ========================2024-06-24 17:20:37======================== noteurl_start parm_app_code = 050 parm_pc_name = MINJU parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0A002700000F54A0AD7F sCDKey = 545626552469 sName = MINJU ========================2024-06-24 17:20:37======================== 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 = '545626552469' AND r.app_code = '050' AND r.app_block = 0 ========================2024-06-24 17:20:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kmj0801' ========================2024-06-24 17:20:37======================== SELECT idx FROM macs WHERE mac_addr = '0A002700000F54A0AD7F' AND app_code = '050' ========================2024-06-24 17:20:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407298' ========================2024-06-24 17:20:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407298' ========================2024-06-24 17:20:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407298', '0A002700000F54A0AD7F', '050', 'MINJU', '109', '1920', '1080', 'kmj0801', '엠제이소프트[김민주]', '545626552469' ) ========================2024-06-24 17:29:33======================== noteurl_start parm_app_code = 046 parm_pc_name = PC-202405181745 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04DD9053F6ECFEDB9 sCDKey = 551811080774 sName = PC-202405181745 ========================2024-06-24 17:29:33======================== 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 = '551811080774' AND r.app_code = '046' AND r.app_block = 0 ========================2024-06-24 17:29:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chsily' ========================2024-06-24 17:29:33======================== SELECT idx FROM macs WHERE mac_addr = '18C04DD9053F6ECFEDB9' AND app_code = '046' ========================2024-06-24 17:29:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '407302' ========================2024-06-24 17:29:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '407302' ========================2024-06-24 17:29:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '407302', '18C04DD9053F6ECFEDB9', '046', 'PC-202405181745', '110', '1920', '1080', 'chsily', '우성종합상사[전용기]', '551811080774' )