========================2018-05-08 11:44:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UE29TCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F40669EDD4D3A03B1560 sCDKey = 166394699588 sName = DESKTOP-UE29TCM ========================2018-05-08 11:44: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 = '166394699588' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-08 11:44:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bohyun5566' ========================2018-05-08 11:44:20======================== SELECT idx FROM macs WHERE mac_addr = 'F40669EDD4D3A03B1560' AND app_code = '039' ========================2018-05-08 11:44:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249197' ========================2018-05-08 11:44:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249197' ========================2018-05-08 11:44:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249197', 'F40669EDD4D3A03B1560', '039', 'DESKTOP-UE29TCM', '110', '1920', '1080', 'bohyun5566', '보현전기[고순희]', '166394699588' ) ========================2018-05-08 12:33:49======================== noteurl_start parm_app_code = 047 parm_pc_name = PBPOS-B755KE61E parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C03FD5BF3AFE28EE181D sCDKey = 695746037546 sName = PBPOS-B755KE61E ========================2018-05-08 12:33: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 = '695746037546' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-08 12:33:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'amoross' ========================2018-05-08 12:33:49======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF3AFE28EE181D' AND app_code = '047' ========================2018-05-08 12:33:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249207' ========================2018-05-08 12:33:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249207' ========================2018-05-08 12:33:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249207', 'C03FD5BF3AFE28EE181D', '047', 'PBPOS-B755KE61E', '�쐢�룄�슦 XP', '0', '0', 'amoross', '데르나(derna)[조성길]', '695746037546' ) ========================2018-05-08 12:33:56======================== noteurl_start parm_app_code = 047 parm_pc_name = PBPOS-B755KE61E parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C03FD5BF3AFE28EE181D sCDKey = 695746037546 sName = PBPOS-B755KE61E ========================2018-05-08 12:33: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 = '695746037546' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-08 13:20:18======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QP5RS6S parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE8006ED1C66826DB6 sCDKey = 903738087532 sName = DESKTOP-QP5RS6S ========================2018-05-08 13:20:18======================== 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 = '903738087532' AND r.app_code = '050' AND r.app_block = 0 ========================2018-05-08 13:20:36======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-QP5RS6S parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE8006ED1C66826DB6 sCDKey = 903738087532 sName = DESKTOP-QP5RS6S ========================2018-05-08 13:20:36======================== 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 = '903738087532' AND r.app_code = '050' AND r.app_block = 0 ========================2018-05-08 13:20:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mkp0366' ========================2018-05-08 13:20:36======================== SELECT idx FROM macs WHERE mac_addr = '94DE8006ED1C66826DB6' AND app_code = '050' ========================2018-05-08 13:20:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249215' ========================2018-05-08 13:20:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249215' ========================2018-05-08 13:20: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 ( '249215', '94DE8006ED1C66826DB6', '050', 'DESKTOP-QP5RS6S', '109', '1920', '1080', 'mkp0366', '엠케이프리시젼(주)[엠케이프리시젼(주)]', '903738087532' ) ========================2018-05-08 14:25:13======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 68EDA40EDA0E34627EBF sCDKey = 468270811149 sName = POS-PC ========================2018-05-08 14:25:13======================== 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 = '468270811149' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-08 14:25:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclub12' ========================2018-05-08 14:25:13======================== SELECT idx FROM macs WHERE mac_addr = '68EDA40EDA0E34627EBF' AND app_code = '047' ========================2018-05-08 14:25:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249230' ========================2018-05-08 14:25:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249230' ========================2018-05-08 14:25:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249230', '68EDA40EDA0E34627EBF', '047', 'POS-PC', '�쐢�룄�슦 7', '0', '0', 'petclub12', '주식회사펫클럽[주식회사펫클럽]', '468270811149' ) ========================2018-05-08 14:50:15======================== noteurl_start parm_app_code = 047 parm_pc_name = YWD-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9B78D384E4B58 sCDKey = 534931489173 sName = YWD-PC ========================2018-05-08 14:50: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 = '534931489173' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-08 14:50:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'novasix' ========================2018-05-08 14:50:15======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B78D384E4B58' AND app_code = '047' ========================2018-05-08 14:50:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222488' ========================2018-05-08 14:50:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222488' ========================2018-05-08 14:50:15======================== UPDATE mac_detail SET pc_name = 'YWD-PC', os_type = '�쐢�룄�슦 10', user_id = 'novasix', user_name = 'MJ소프트[여욱동]', screen_w = '0', screen_h = '0', cdkey = '534931489173' WHERE mac_idx = '222488' ========================2018-05-08 15:25:29======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = AC9E174CB0AD14A094E0 sCDKey = 714887021044 sName = 주원테크 ========================2018-05-08 15:25:29======================== 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 = '714887021044' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-08 15:25:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jw2600' ========================2018-05-08 15:25:29======================== SELECT idx FROM macs WHERE mac_addr = 'AC9E174CB0AD14A094E0' AND app_code = '039' ========================2018-05-08 15:25:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249236' ========================2018-05-08 15:25:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249236' ========================2018-05-08 15:25:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249236', 'AC9E174CB0AD14A094E0', '039', '주원테크', '90', '1920', '1080', 'jw2600', '주원테크[김성자]', '714887021044' ) ========================2018-05-08 16:27:15======================== noteurl_start parm_app_code = 039 parm_pc_name = MICRO-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067DC483EA7F53A4 sCDKey = 512846848709 sName = MICRO-PC ========================2018-05-08 16:27: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 = '512846848709' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-08 16:27:56======================== noteurl_start parm_app_code = 039 parm_pc_name = MICRO-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067DC483EA7F53A4 sCDKey = 512846848709 sName = MICRO-PC ========================2018-05-08 16:27: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 = '512846848709' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-08 16:28:50======================== noteurl_start parm_app_code = 039 parm_pc_name = MICRO-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067DC483EA7F53A4 sCDKey = 512846848709 sName = MICRO-PC ========================2018-05-08 16:28: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 = '512846848709' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-08 16:29:10======================== noteurl_start parm_app_code = 039 parm_pc_name = MICRO-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067DC483EA7F53A4 sCDKey = 512846848709 sName = MICRO-PC ========================2018-05-08 16:29:10======================== 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 = '512846848709' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-08 16:29:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs461' ========================2018-05-08 16:29:10======================== SELECT idx FROM macs WHERE mac_addr = '003067DC483EA7F53A4' AND app_code = '039' ========================2018-05-08 16:29:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249250' ========================2018-05-08 16:29:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249250' ========================2018-05-08 16:29:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249250', '003067DC483EA7F53A4', '039', 'MICRO-PC', '90', '1920', '1080', 'bs461', '대신아트[부산지사]', '512846848709' )