========================2018-06-04 10:06:31======================== noteurl_start parm_app_code = 039 parm_pc_name = OWNER1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 909F330F530CDA1CC2BA sCDKey = 191805487369 sName = OWNER1 ========================2018-06-04 10:06: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 = '191805487369' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 10:06:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'fine_eng' ========================2018-06-04 10:06:31======================== SELECT idx FROM macs WHERE mac_addr = '909F330F530CDA1CC2BA' AND app_code = '039' ========================2018-06-04 10:06:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251221' ========================2018-06-04 10:06:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251221' ========================2018-06-04 10:06: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 ( '251221', '909F330F530CDA1CC2BA', '039', 'OWNER1', '90', '1920', '1080', 'fine_eng', '화인엔지니어링(주)[장환식]', '191805487369' ) ========================2018-06-04 10:19:58======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DBD6433AA884826 sCDKey = 979436903568 sName = MAIN ========================2018-06-04 10:19: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 = '979436903568' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 10:19:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhb0260' ========================2018-06-04 10:19:58======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DBD6433AA884826' AND app_code = '039' ========================2018-06-04 10:19:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251222' ========================2018-06-04 10:19:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251222' ========================2018-06-04 10:19: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 ( '251222', '1C1B0DBD6433AA884826', '039', 'MAIN', '110', '1920', '1080', 'lhb0260', '순창종합판넬[이형범]', '979436903568' ) ========================2018-06-04 10:57:20======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2018-06-04 10:57: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 10:57:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2018-06-04 10:57:20======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2018-06-04 10:57:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2018-06-04 10:57:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2018-06-04 10:57:20======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]', screen_w = '1920', screen_h = '1080', cdkey = '173379187341' WHERE mac_idx = '235354' ========================2018-06-04 13:26:03======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0A002700000A6033E3EA sCDKey = 411519416792 sName = AHN-PC ========================2018-06-04 13:26:03======================== 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 = '411519416792' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 13:26:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2018-06-04 13:26:03======================== SELECT idx FROM macs WHERE mac_addr = '0A002700000A6033E3EA' AND app_code = '039' ========================2018-06-04 13:26:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251230' ========================2018-06-04 13:26:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251230' ========================2018-06-04 13:26:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251230', '0A002700000A6033E3EA', '039', 'AHN-PC', '110', '1920', '1080', 'mjdev', '엠제이소프트[최상호]', '411519416792' ) ========================2018-06-04 13:26:12======================== noteurl_start parm_app_code = 039 parm_pc_name = AHN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0A002700000A6033E3EA sCDKey = 411519416792 sName = AHN-PC ========================2018-06-04 13:26: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 = '411519416792' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 13:26:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2018-06-04 13:26:12======================== SELECT idx FROM macs WHERE mac_addr = '0A002700000A6033E3EA' AND app_code = '039' ========================2018-06-04 13:26:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251230' ========================2018-06-04 13:26:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251230' ========================2018-06-04 13:26:12======================== UPDATE mac_detail SET pc_name = 'AHN-PC', os_type = '110', user_id = 'mjdev', user_name = '엠제이소프트[최상호]', screen_w = '1920', screen_h = '1080', cdkey = '411519416792' WHERE mac_idx = '251230' ========================2018-06-04 13:42:14======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D1681714F1F33F sCDKey = 411514916792 sName = KR ========================2018-06-04 13:42: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 = '411514916792' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 13:42:22======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D1681714F1F33F sCDKey = 411519416792 sName = KR ========================2018-06-04 13:42:22======================== 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 = '411519416792' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 13:42:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2018-06-04 13:42:22======================== SELECT idx FROM macs WHERE mac_addr = '080027D1681714F1F33F' AND app_code = '039' ========================2018-06-04 13:42:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '205935' ========================2018-06-04 13:42:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '205935' ========================2018-06-04 13:42:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '205935', '080027D1681714F1F33F', '039', 'KR', '64', '1920', '976', 'mjdev', '엠제이소프트[최상호]', '411519416792' ) ========================2018-06-04 13:57:39======================== noteurl_start parm_app_code = 047 parm_pc_name = USERF-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0B94DB683D104147788 sCDKey = 983203943257 sName = USERF-PC ========================2018-06-04 13:57:39======================== 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 = '983203943257' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-04 13:57:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eleldkf14' ========================2018-06-04 13:57:39======================== SELECT idx FROM macs WHERE mac_addr = 'E0B94DB683D104147788' AND app_code = '047' ========================2018-06-04 13:57:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251254' ========================2018-06-04 13:57:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251254' ========================2018-06-04 13:57:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251254', 'E0B94DB683D104147788', '047', 'USERF-PC', '�쐢�룄�슦 7', '0', '0', 'eleldkf14', '한강[오현식]', '983203943257' ) ========================2018-06-04 14:00:45======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027FAECDE14F1F33F sCDKey = 411519416792 sName = KR ========================2018-06-04 14:00: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 = '411519416792' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 14:00:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2018-06-04 14:00:45======================== SELECT idx FROM macs WHERE mac_addr = '080027FAECDE14F1F33F' AND app_code = '039' ========================2018-06-04 14:00:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251259' ========================2018-06-04 14:00:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251259' ========================2018-06-04 14:00: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 ( '251259', '080027FAECDE14F1F33F', '039', 'KR', '64', '1920', '976', 'mjdev', '엠제이소프트[최상호]', '411519416792' ) ========================2018-06-04 14:06:04======================== noteurl_start parm_app_code = 039 parm_pc_name = KR parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = FFFFFFFFFFFF280D8FDA sCDKey = 411519416792 sName = KR ========================2018-06-04 14:06:04======================== 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 = '411519416792' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 14:24:16======================== noteurl_start parm_app_code = 047 parm_pc_name = 서울회의실 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 002454FC23B1D46761CA sCDKey = 885264505848 sName = 서울회의실 ========================2018-06-04 14:24:16======================== 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 = '885264505848' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-04 14:24:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mailo7' ========================2018-06-04 14:24:16======================== SELECT idx FROM macs WHERE mac_addr = '002454FC23B1D46761CA' AND app_code = '047' ========================2018-06-04 14:24:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251272' ========================2018-06-04 14:24:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251272' ========================2018-06-04 14:24:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251272', '002454FC23B1D46761CA', '047', '서울회의실', '�쐢�룄�슦 10', '0', '0', 'mailo7', '송영훈[송영훈]', '885264505848' ) ========================2018-06-04 14:31:48======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74AC7204CE sCDKey = 217223037343 sName = OFFICE-PC ========================2018-06-04 14:31: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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 14:31:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2018-06-04 14:31:48======================== SELECT idx FROM macs WHERE mac_addr = 'C83A35C8BE74AC7204CE' AND app_code = '039' ========================2018-06-04 14:31:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250374' ========================2018-06-04 14:31:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250374' ========================2018-06-04 14:31: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 ( '250374', 'C83A35C8BE74AC7204CE', '039', 'OFFICE-PC', '110', '1280', '1024', 'sunjin677', '선진FS[김형희]', '217223037343' ) ========================2018-06-04 14:31:55======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74AC7204CE sCDKey = 217223037343 sName = OFFICE-PC ========================2018-06-04 14:31:55======================== 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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-04 18:39:39======================== noteurl_start parm_app_code = 039 parm_pc_name = JBH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0A8CDE8C3A8B617DE69 sCDKey = 550400830049 sName = JBH-PC ========================2018-06-04 18:39:39======================== 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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0