========================2019-07-04 11:21:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4N96AT1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = BC5FF4F207B742D6DE27 sCDKey = 110772231677 sName = DESKTOP-4N96AT1 ========================2019-07-04 11:21:12======================== 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 = '110772231677' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-04 11:21:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ms7061' ========================2019-07-04 11:21:12======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4F207B742D6DE27' AND app_code = '039' ========================2019-07-04 11:21:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289968' ========================2019-07-04 11:21:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289968' ========================2019-07-04 11:21:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '289968', 'BC5FF4F207B742D6DE27', '039', 'DESKTOP-4N96AT1', '110', '1920', '1200', 'ms7061', '마샬전자음향[김진경]', '110772231677' ) ========================2019-07-04 13:16:27======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AADE00EB36902760 sCDKey = 017488729041 sName = SAMSUNG ========================2019-07-04 13:16:27======================== 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 = '017488729041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-04 13:16:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldscrs38' ========================2019-07-04 13:16:27======================== SELECT idx FROM macs WHERE mac_addr = '24F5AADE00EB36902760' AND app_code = '039' ========================2019-07-04 13:16:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '127182' ========================2019-07-04 13:16:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '127182' ========================2019-07-04 13:16:27======================== UPDATE mac_detail SET pc_name = 'SAMSUNG', os_type = '110', user_id = 'ldscrs38', user_name = '유영고무[유대성]', screen_w = '1920', screen_h = '1080', cdkey = '017488729041' WHERE mac_idx = '127182' ========================2019-07-04 13:16:32======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AADE00EB36902760 sCDKey = 017488729041 sName = SAMSUNG ========================2019-07-04 13:16:32======================== 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 = '017488729041' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-04 14:50:02======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1867B0E1330A670AF1E sCDKey = 622658319188 sName = HOME ========================2019-07-04 14:50:02======================== 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 = '622658319188' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-04 14:50:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sj6953811' ========================2019-07-04 14:50:02======================== SELECT idx FROM macs WHERE mac_addr = '1867B0E1330A670AF1E' AND app_code = '039' ========================2019-07-04 14:50:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '151993' ========================2019-07-04 14:50:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '151993' ========================2019-07-04 14:50:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '151993', '1867B0E1330A670AF1E', '039', 'HOME', '110', '1920', '1080', 'sj6953811', '(주)세종건축건업[이태규]', '622658319188' ) ========================2019-07-04 15:54:48======================== noteurl_start parm_app_code = 051 parm_pc_name = HHY-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B7922E87FB70 sCDKey = 034204296741 sName = HHY-PC ========================2019-07-04 15:54: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 = '034204296741' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-04 15:54:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hhy111' ========================2019-07-04 15:54:48======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7922E87FB70' AND app_code = '051' ========================2019-07-04 15:54:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238715' ========================2019-07-04 15:54:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238715' ========================2019-07-04 15:54: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 ( '238715', 'F44D30B9B7922E87FB70', '051', 'HHY-PC', '109', '1920', '1080', 'hhy111', '[황희영]', '034204296741' ) ========================2019-07-04 16:06:56======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-04 16:06:56======================== 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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-04 16:12:40======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-04 16:12:40======================== 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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-04 16:12:45======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-04 16:12: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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-04 16:17:33======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-04 16:17: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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-04 16:17:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ik549892' ========================2019-07-04 16:17:33======================== SELECT idx FROM macs WHERE mac_addr = 'D4258B944A4914F48463' AND app_code = '051' ========================2019-07-04 16:17:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290012' ========================2019-07-04 16:17:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290012' ========================2019-07-04 16:17: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 ( '290012', 'D4258B944A4914F48463', '051', 'SEOWL17H15185', '109', '1920', '1080', 'ik549892', '지에스케이(GSK)[김인배]', '851095746023' ) ========================2019-07-04 16:26:07======================== noteurl_start parm_app_code = 051 parm_pc_name = HJH-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 455866416454 sName = HJH-PC ========================2019-07-04 16:26:07======================== 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 = '455866416454' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-04 16:26:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2019-07-04 16:26:07======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '051' ========================2019-07-04 16:26:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '286441' ========================2019-07-04 16:26:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '286441' ========================2019-07-04 16:26:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '286441', 'F44D30B9AE60D8075059', '051', 'HJH-PC', '109', '1920', '1080', 'wogus36', '[황재현]', '455866416454' ) ========================2019-07-04 18:03:31======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-H9B3Q13 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 507B9D2AFB7384841678 sCDKey = 315435650547 sName = DESKTOP-H9B3Q13 ========================2019-07-04 18:03: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 = '315435650547' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-04 18:03:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sewonmusic' ========================2019-07-04 18:03:31======================== SELECT idx FROM macs WHERE mac_addr = '507B9D2AFB7384841678' AND app_code = '047' ========================2019-07-04 18:03:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290037' ========================2019-07-04 18:03:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290037' ========================2019-07-04 18:03: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 ( '290037', '507B9D2AFB7384841678', '047', 'DESKTOP-H9B3Q13', '�쐢�룄�슦 10', '0', '0', 'sewonmusic', '세원뮤직[장세원]', '315435650547' )