========================2020-05-18 13:03:45======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOSEEEE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B31B646F7D14 sCDKey = 382846985937 sName = IPOSEEEE ========================2020-05-18 13:03: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-18 13:03:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-05-18 13:03:45======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B31B646F7D14' AND app_code = '046' ========================2020-05-18 13:03:45======================== 값이 없을 경우 ========================2020-05-18 13:05:20======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOSEEEE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B31B646F7D14 sCDKey = 382846985937 sName = IPOSEEEE ========================2020-05-18 13:05: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-18 13:05:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-05-18 13:05:20======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A88B31B646F7D14' AND app_code = '046' ========================2020-05-18 13:05:20======================== 값이 없을 경우 ========================2020-05-18 13:14:20======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOSEEEE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B31B646F7D14 sCDKey = 382846985937 sName = IPOSEEEE ========================2020-05-18 13:14: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-18 13:35:52======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOSEEEE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A88B31B646F7D14 sCDKey = 382846985937 sName = IPOSEEEE ========================2020-05-18 13:35:52======================== 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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-18 14:50:31======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TLUOAOD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99EDE6E6C3871373 sCDKey = 488731888509 sName = DESKTOP-TLUOAOD ========================2020-05-18 14:50:31======================== 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 = '488731888509' AND r.app_code = '047' AND r.app_block = 0 ========================2020-05-18 14:50:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds6308' ========================2020-05-18 14:50:31======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99EDE6E6C3871373' AND app_code = '047' ========================2020-05-18 14:50:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317685' ========================2020-05-18 14:50:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317685' ========================2020-05-18 14:50:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '317685', 'B42E99EDE6E6C3871373', '047', 'DESKTOP-TLUOAOD', '�쐢�룄�슦 10', '0', '0', 'ds6308', '(유)전진툴[이은애]', '488731888509' ) ========================2020-05-18 14:50:45======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TLUOAOD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99EDEE3DDAC78579 sCDKey = 488731888509 sName = DESKTOP-TLUOAOD ========================2020-05-18 14:50: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 = '488731888509' AND r.app_code = '047' AND r.app_block = 0 ========================2020-05-18 14:50:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds6308' ========================2020-05-18 14:50:45======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99EDEE3DDAC78579' AND app_code = '047' ========================2020-05-18 14:50:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317686' ========================2020-05-18 14:50:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317686' ========================2020-05-18 14:50:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '317686', 'B42E99EDEE3DDAC78579', '047', 'DESKTOP-TLUOAOD', '�쐢�룄�슦 10', '0', '0', 'ds6308', '(유)전진툴[이은애]', '488731888509' ) ========================2020-05-18 15:12:52======================== noteurl_start parm_app_code = 047 parm_pc_name = MANMUL-2 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 5404A61527DDE0335C4A sCDKey = 834253831888 sName = MANMUL-2 ========================2020-05-18 15:12:52======================== 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 = '834253831888' AND r.app_code = '047' AND r.app_block = 0 ========================2020-05-18 15:12:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'manmul0989' ========================2020-05-18 15:12:52======================== SELECT idx FROM macs WHERE mac_addr = '5404A61527DDE0335C4A' AND app_code = '047' ========================2020-05-18 15:12:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317689' ========================2020-05-18 15:12:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317689' ========================2020-05-18 15:12:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '317689', '5404A61527DDE0335C4A', '047', 'MANMUL-2', '�쐢�룄�슦 7', '0', '0', 'manmul0989', '만물종합상사[이민선]', '834253831888' ) ========================2020-05-18 15:39:53======================== noteurl_start parm_app_code = 050 parm_pc_name = SDH parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B52017918E1C4E35F8 sCDKey = 038244806903 sName = SDH ========================2020-05-18 15:39:53======================== 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 = '038244806903' AND r.app_code = '050' AND r.app_block = 0 ========================2020-05-18 15:39:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nenara999' ========================2020-05-18 15:39:53======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52017918E1C4E35F8' AND app_code = '050' ========================2020-05-18 15:39:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315107' ========================2020-05-18 15:39:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315107' ========================2020-05-18 15:39:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315107', 'F4B52017918E1C4E35F8', '050', 'SDH', '109', '1920', '1080', 'nenara999', '[성대휘]', '038244806903' ) ========================2020-05-18 16:04:33======================== noteurl_start parm_app_code = 051 parm_pc_name = SDH parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B52017918E1C4E35F8 sCDKey = 788922454682 sName = SDH ========================2020-05-18 16:04: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 = '788922454682' AND r.app_code = '051' AND r.app_block = 0 ========================2020-05-18 16:04:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nenara999' ========================2020-05-18 16:04:33======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52017918E1C4E35F8' AND app_code = '051' ========================2020-05-18 16:04:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315923' ========================2020-05-18 16:04:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315923' ========================2020-05-18 16:04: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 ( '315923', 'F4B52017918E1C4E35F8', '051', 'SDH', '109', '1920', '1080', 'nenara999', '[성대휘]', '788922454682' ) ========================2020-05-18 16:18:06======================== noteurl_start parm_app_code = 051 parm_pc_name = YWD-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B78D384E4B58 sCDKey = 735712851958 sName = YWD-PC ========================2020-05-18 16:18: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 = '735712851958' AND r.app_code = '051' AND r.app_block = 0 ========================2020-05-18 16:18:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'novasix' ========================2020-05-18 16:18:06======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B78D384E4B58' AND app_code = '051' ========================2020-05-18 16:18:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '231733' ========================2020-05-18 16:18:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '231733' ========================2020-05-18 16:18:06======================== UPDATE mac_detail SET pc_name = 'YWD-PC', os_type = '109', user_id = 'novasix', user_name = 'MJ소프트[여욱동]', screen_w = '1920', screen_h = '1080', cdkey = '735712851958' WHERE mac_idx = '231733'