========================2018-11-12 09:45:53======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C417FE6D1E3020B7FA4 sCDKey = 337887153847 sName = SAMSUNG-PC ========================2018-11-12 09:45: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 = '337887153847' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-12 09:45:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sagisori' ========================2018-11-12 09:45:53======================== SELECT idx FROM macs WHERE mac_addr = 'C417FE6D1E3020B7FA4' AND app_code = '039' ========================2018-11-12 09:45:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267309' ========================2018-11-12 09:45:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267309' ========================2018-11-12 09:45: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 ( '267309', 'C417FE6D1E3020B7FA4', '039', 'SAMSUNG-PC', '90', '1366', '768', 'sagisori', '다복유통[양승복]', '337887153847' ) ========================2018-11-12 09:52:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-E0O7P3A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = BC5FF44833EEBA8C1C0D sCDKey = 777291722588 sName = DESKTOP-E0O7P3A ========================2018-11-12 09:52:46======================== 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 = '777291722588' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-12 09:52:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jongey100' ========================2018-11-12 09:52:46======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF44833EEBA8C1C0D' AND app_code = '039' ========================2018-11-12 09:52:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267387' ========================2018-11-12 09:52:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267387' ========================2018-11-12 09:52: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 ( '267387', 'BC5FF44833EEBA8C1C0D', '039', 'DESKTOP-E0O7P3A', '110', '1920', '1200', 'jongey100', '유승산업[차상종]', '777291722588' ) ========================2018-11-12 10:51:18======================== noteurl_start parm_app_code = 045 parm_pc_name = YWD-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B78D384E4B58 sCDKey = 488729833624 sName = YWD-PC ========================2018-11-12 10:51: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 = '488729833624' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-12 10:51:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'novasix' ========================2018-11-12 10:51:18======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B78D384E4B58' AND app_code = '045' ========================2018-11-12 10:51:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '224709' ========================2018-11-12 10:51:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '224709' ========================2018-11-12 10:51:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '224709', 'F44D30B9B78D384E4B58', '045', 'YWD-PC', '110', '1920', '1080', 'novasix', 'MJ소프트[여욱동]', '488729833624' ) ========================2018-11-12 13:21:46======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-S9AD0PFGHLI parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 0024549000C6B0836A8C sCDKey = 523982830539 sName = WIN-S9AD0PFGHLI ========================2018-11-12 13:21:46======================== 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 = '523982830539' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-12 13:21:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyungilsa01' ========================2018-11-12 13:21:46======================== SELECT idx FROM macs WHERE mac_addr = '0024549000C6B0836A8C' AND app_code = '039' ========================2018-11-12 13:21:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264893' ========================2018-11-12 13:21:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264893' ========================2018-11-12 13:21: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 ( '264893', '0024549000C6B0836A8C', '039', 'WIN-S9AD0PFGHLI', '90', '1280', '1024', 'kyungilsa01', '경일인쇄사[김항복]', '523982830539' ) ========================2018-11-12 13:29:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-O8A62J6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1062E5094B99ECF8BA07 sCDKey = 523982830539 sName = DESKTOP-O8A62J6 ========================2018-11-12 13:29:11======================== 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 = '523982830539' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-12 16:13:58======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AEF0FF1942362F3 sCDKey = 734356754890 sName = ADMINISTRATOR ========================2018-11-12 16:13: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 = '734356754890' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-12 16:13:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'oracompany2' ========================2018-11-12 16:13:58======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AEF0FF1942362F3' AND app_code = '046' ========================2018-11-12 16:13:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267468' ========================2018-11-12 16:13:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267468' ========================2018-11-12 16:13: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 ( '267468', 'B8975AEF0FF1942362F3', '046', 'ADMINISTRATOR', '90', '1024', '768', 'oracompany2', '오라컴퍼니[권용백]', '734356754890' ) ========================2018-11-12 17:29:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-79R7DNP parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 74DFBFEDBE3DF8A95364 sCDKey = 271272727084 sName = DESKTOP-79R7DNP ========================2018-11-12 17:29:46======================== 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 = '271272727084' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-12 17:29:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssbgoo' ========================2018-11-12 17:29:46======================== SELECT idx FROM macs WHERE mac_addr = '74DFBFEDBE3DF8A95364' AND app_code = '039' ========================2018-11-12 17:29:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '230383' ========================2018-11-12 17:29:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '230383' ========================2018-11-12 17:29:46======================== UPDATE mac_detail SET pc_name = 'DESKTOP-79R7DNP', os_type = '110', user_id = 'ssbgoo', user_name = '영남복집[신순복]', screen_w = '1280', screen_h = '720', cdkey = '271272727084' WHERE mac_idx = '230383' ========================2018-11-12 17:29:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-79R7DNP parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 74DFBFEDBE3DF8A95364 sCDKey = 271272727084 sName = DESKTOP-79R7DNP ========================2018-11-12 17:29: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 = '271272727084' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-12 17:41:57======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN7-01 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D05099A46DDE626CE3E9 sCDKey = 222859365472 sName = WIN7-01 ========================2018-11-12 17:41: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 = '222859365472' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-12 17:41:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ajm5265' ========================2018-11-12 17:41:57======================== SELECT idx FROM macs WHERE mac_addr = 'D05099A46DDE626CE3E9' AND app_code = '046' ========================2018-11-12 17:41:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267486' ========================2018-11-12 17:41:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267486' ========================2018-11-12 17:41:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267486', 'D05099A46DDE626CE3E9', '046', 'WIN7-01', '90', '1920', '1080', 'ajm5265', '주식회사광문[안정미]', '222859365472' )