========================2020-02-18 09:20:23======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FC8JLPD parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3CA0679EFE0710708149 sCDKey = 850547206049 sName = DESKTOP-FC8JLPD ========================2020-02-18 09:20:23======================== 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 = '850547206049' AND r.app_code = '048' AND r.app_block = 0 ========================2020-02-18 09:20:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2020-02-18 09:20:23======================== SELECT idx FROM macs WHERE mac_addr = '3CA0679EFE0710708149' AND app_code = '048' ========================2020-02-18 09:20:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310919' ========================2020-02-18 09:20:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310919' ========================2020-02-18 09:20:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310919', '3CA0679EFE0710708149', '048', 'DESKTOP-FC8JLPD', '�쐢�룄�슦 10', '0', '0', 'chamnara', '(주)참나라 농업회사법인[임준상]', '850547206049' ) ========================2020-02-18 13:07:14======================== 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 = 18CF5EF8C37B36902760 sCDKey = 017488729041 sName = SAMSUNG ========================2020-02-18 13:07:14======================== 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 ========================2020-02-18 13:07:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ldscrs38' ========================2020-02-18 13:07:15======================== SELECT idx FROM macs WHERE mac_addr = '18CF5EF8C37B36902760' AND app_code = '039' ========================2020-02-18 13:07:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289062' ========================2020-02-18 13:07:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289062' ========================2020-02-18 13:07:15======================== 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 = '289062' ========================2020-02-18 13:50:48======================== noteurl_start parm_app_code = 048 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C22B4B2F808E1517 sCDKey = 902396377681 sName = POS-PC ========================2020-02-18 13:50: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 = '902396377681' AND r.app_code = '048' AND r.app_block = 0 ========================2020-02-18 13:50:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qnc05014' ========================2020-02-18 13:50:48======================== SELECT idx FROM macs WHERE mac_addr = '7085C22B4B2F808E1517' AND app_code = '048' ========================2020-02-18 13:50:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '303963' ========================2020-02-18 13:50:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '303963' ========================2020-02-18 13:50:48======================== UPDATE mac_detail SET pc_name = 'POS-PC', os_type = '�쐢�룄�슦 7', user_id = 'qnc05014', user_name = '(주)큐엔씨B2B점[유임묵]', screen_w = '0', screen_h = '0', cdkey = '902396377681' WHERE mac_idx = '303963' ========================2020-02-18 14:03:02======================== noteurl_start parm_app_code = 051 parm_pc_name = 김창원 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB3E060A5DC0D8 sCDKey = 849225073623 sName = 김창원 ========================2020-02-18 14:03: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 = '849225073623' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-18 14:03:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2020-02-18 14:03:02======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E060A5DC0D8' AND app_code = '051' ========================2020-02-18 14:03:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310957' ========================2020-02-18 14:03:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310957' ========================2020-02-18 14:03: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 ( '310957', '64E599FB3E060A5DC0D8', '051', '김창원', '109', '1920', '1080', 'klmm12', '엠제이소프트[김창원]', '849225073623' ) ========================2020-02-18 16:03:47======================== noteurl_start parm_app_code = 039 parm_pc_name = jh-201702040915 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 7427EAD71D4B45AA506 sCDKey = 467063603776 sName = jh-201702040915 ========================2020-02-18 16:03:47======================== 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 = '467063603776' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-18 16:03:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vnfms12' ========================2020-02-18 16:03:48======================== SELECT idx FROM macs WHERE mac_addr = '7427EAD71D4B45AA506' AND app_code = '039' ========================2020-02-18 16:03:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310966' ========================2020-02-18 16:03:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310966' ========================2020-02-18 16:03: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 ( '310966', '7427EAD71D4B45AA506', '039', 'jh-201702040915', '90', '1600', '900', 'vnfms12', '푸른환경[조순자]', '467063603776' ) ========================2020-02-18 16:17:19======================== noteurl_start parm_app_code = 039 parm_pc_name = 가야금속 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5404A6A1556C344136BE sCDKey = 624525041658 sName = 가야금속 ========================2020-02-18 16:17:19======================== 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 = '624525041658' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-18 16:17:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gayasts21' ========================2020-02-18 16:17:19======================== SELECT idx FROM macs WHERE mac_addr = '5404A6A1556C344136BE' AND app_code = '039' ========================2020-02-18 16:17:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310975' ========================2020-02-18 16:17:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310975' ========================2020-02-18 16:17:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310975', '5404A6A1556C344136BE', '039', '가야금속', '110', '1920', '1080', 'gayasts21', '가야금속[하호수]', '624525041658' ) ========================2020-02-18 16:19:57======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HO173BC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24EC99B4741AFEAB5A45 sCDKey = 343408108095 sName = 고은 ========================2020-02-18 16:19: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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2020-02-18 16:19:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2020-02-18 16:19:57======================== SELECT idx FROM macs WHERE mac_addr = '24EC99B4741AFEAB5A45' AND app_code = '046' ========================2020-02-18 16:19:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310979' ========================2020-02-18 16:19:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310979' ========================2020-02-18 16:19: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 ( '310979', '24EC99B4741AFEAB5A45', '046', '고은', '110', '1920', '1080', 'rain1479', '한영사[고경태]', '343408108095' ) ========================2020-02-18 17:01:36======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-0H3NR4F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DB4BC1B3408FD05 sCDKey = 175133741151 sName = DESKTOP-0H3NR4F ========================2020-02-18 17:01: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 = '175133741151' AND r.app_code = '045' AND r.app_block = 0 ========================2020-02-18 17:01:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'windmillent' ========================2020-02-18 17:01:36======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DB4BC1B3408FD05' AND app_code = '045' ========================2020-02-18 17:01:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310989' ========================2020-02-18 17:01:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310989' ========================2020-02-18 17:01: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 ( '310989', '1C1B0DB4BC1B3408FD05', '045', 'DESKTOP-0H3NR4F', '110', '1920', '1080', 'windmillent', '(주)윈드밀이엔티[권지애]', '175133741151' ) ========================2020-02-18 17:36:28======================== noteurl_start parm_app_code = 051 parm_pc_name = 20200214-00 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9026F9CA2E87F18 sCDKey = 586434134077 sName = 20200214-00 ========================2020-02-18 17:36: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 = '586434134077' AND r.app_code = '051' AND r.app_block = 0 ========================2020-02-18 17:36:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kotmi' ========================2020-02-18 17:36:28======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9026F9CA2E87F18' AND app_code = '051' ========================2020-02-18 17:36:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310940' ========================2020-02-18 17:36:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310940' ========================2020-02-18 17:36: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 ( '310940', '8CB0E9026F9CA2E87F18', '051', '20200214-00', '109', '1920', '1080', 'kotmi', '한국섬유기계연구소[권성범]', '586434134077' ) ========================2020-02-18 17:55:42======================== noteurl_start parm_app_code = 039 parm_pc_name = ONE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 08626644F40892FAF3 sCDKey = 747609970812 sName = ONE-PC ========================2020-02-18 17:55:42======================== 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 = '747609970812' AND r.app_code = '039' AND r.app_block = 0 ========================2020-02-18 17:55:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jicy2001' ========================2020-02-18 17:55:42======================== SELECT idx FROM macs WHERE mac_addr = '08626644F40892FAF3' AND app_code = '039' ========================2020-02-18 17:55:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '310994' ========================2020-02-18 17:55:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '310994' ========================2020-02-18 17:55:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '310994', '08626644F40892FAF3', '039', 'ONE-PC', '90', '1920', '1080', 'jicy2001', '대명계전[지천용]', '747609970812' )