========================2019-12-05 10:02:51======================== noteurl_start parm_app_code = 045 parm_pc_name = PPSPPS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF46CA28FEABB365 sCDKey = 160292300001 sName = PPSPPS ========================2019-12-05 10:02: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 = '160292300001' AND r.app_code = '045' AND r.app_block = 0 ========================2019-12-05 10:02:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samwon6440' ========================2019-12-05 10:02:51======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF46CA28FEABB365' AND app_code = '045' ========================2019-12-05 10:02:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304564' ========================2019-12-05 10:02:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304564' ========================2019-12-05 10:02:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '304564', 'BC5FF46CA28FEABB365', '045', 'PPSPPS', '110', '1920', '1080', 'samwon6440', '삼원유통[박범진]', '160292300001' ) ========================2019-12-05 14:09:13======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PIEA0NK parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838940E5D538A538E2 sCDKey = 767095042850 sName = 광주전라지사 ========================2019-12-05 14:09: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 = '767095042850' AND r.app_code = '047' AND r.app_block = 0 ========================2019-12-05 14:09:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'emekorea' ========================2019-12-05 14:09:13======================== SELECT idx FROM macs WHERE mac_addr = '98838940E5D538A538E2' AND app_code = '047' ========================2019-12-05 14:09:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304591' ========================2019-12-05 14:09:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304591' ========================2019-12-05 14:09: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 ( '304591', '98838940E5D538A538E2', '047', '광주전라지사 ', '�쐢�룄�슦 10', '0', '0', 'emekorea', '이엠이코리아[김덕인]', '767095042850' ) ========================2019-12-05 14:59:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FF23KKD parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B42E99C45ABC326E4F33 sCDKey = 754481133414 sName = DESKTOP-FF23KKD ========================2019-12-05 14:59: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 = '754481133414' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-05 14:59:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sungheej7' ========================2019-12-05 14:59:02======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C45ABC326E4F33' AND app_code = '039' ========================2019-12-05 14:59:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304595' ========================2019-12-05 14:59:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304595' ========================2019-12-05 14:59: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 ( '304595', 'B42E99C45ABC326E4F33', '039', 'DESKTOP-FF23KKD', '110', '1680', '1050', 'sungheej7', '금강팩[정성희]', '754481133414' ) ========================2019-12-05 15:39:56======================== noteurl_start parm_app_code = 048 parm_pc_name = CHOISH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 305A3A58E5C6782808EF sCDKey = 867768264557 sName = CHOISH-PC ========================2019-12-05 15:39: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 = '867768264557' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 15:39:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mjdev' ========================2019-12-05 15:39:56======================== SELECT idx FROM macs WHERE mac_addr = '305A3A58E5C6782808EF' AND app_code = '048' ========================2019-12-05 15:39:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304601' ========================2019-12-05 15:39:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304601' ========================2019-12-05 15:39:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '304601', '305A3A58E5C6782808EF', '048', 'CHOISH-PC', '�쐢�룄�슦 10', '0', '0', 'mjdev', '엠제이소프트[최상호]', '867768264557' ) ========================2019-12-05 16:41:28======================== noteurl_start parm_app_code = parm_pc_name = parm_os_type = parm_screen_w = parm_screen_h = parm_user_mac = sCDKey = 433586618041 sName = 니기미 ========================2019-12-05 16:41: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 = '433586618041' AND r.app_code = '' AND r.app_block = 0 ========================2019-12-05 16:41:38======================== noteurl_start parm_app_code = parm_pc_name = parm_os_type = parm_screen_w = parm_screen_h = parm_user_mac = sCDKey = 433586618041 sName = 니기미 ========================2019-12-05 16:41:38======================== 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 = '433586618041' AND r.app_code = '' AND r.app_block = 0 ========================2019-12-05 16:41:54======================== noteurl_start parm_app_code = parm_pc_name = parm_os_type = parm_screen_w = parm_screen_h = parm_user_mac = sCDKey = 433586618041 sName = 니기미 ========================2019-12-05 16:41:54======================== 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 = '433586618041' AND r.app_code = '' AND r.app_block = 0 ========================2019-12-05 16:42:56======================== noteurl_start parm_app_code = parm_pc_name = parm_os_type = parm_screen_w = parm_screen_h = parm_user_mac = sCDKey = 433586618041 sName = ㅇㅇㅇ ========================2019-12-05 16:42: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 = '433586618041' AND r.app_code = '' AND r.app_block = 0 ========================2019-12-05 16:43:04======================== noteurl_start parm_app_code = parm_pc_name = parm_os_type = parm_screen_w = parm_screen_h = parm_user_mac = sCDKey = 433586618041 sName = 김준표 ========================2019-12-05 16:43: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 = '433586618041' AND r.app_code = '' AND r.app_block = 0 ========================2019-12-05 17:23:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-89JL3UI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99C453186E70992A sCDKey = 088696413564 sName = DESKTOP-89JL3UI ========================2019-12-05 17:23: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 = '088696413564' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-05 17:23:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'flash019' ========================2019-12-05 17:23:31======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C453186E70992A' AND app_code = '039' ========================2019-12-05 17:23:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304623' ========================2019-12-05 17:23:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304623' ========================2019-12-05 17:23: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 ( '304623', 'B42E99C453186E70992A', '039', 'DESKTOP-89JL3UI', '110', '1920', '1080', 'flash019', '대명PTC[한영주]', '088696413564' ) ========================2019-12-05 18:27:05======================== noteurl_start parm_app_code = 048 parm_pc_name = 2F4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A0510B6D69A1FC12F463 sCDKey = 434133617514 sName = 2F4 ========================2019-12-05 18:27:05======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 18:27:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-12-05 18:27:05======================== SELECT idx FROM macs WHERE mac_addr = 'A0510B6D69A1FC12F463' AND app_code = '048' ========================2019-12-05 18:27:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '298430' ========================2019-12-05 18:27:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '298430' ========================2019-12-05 18:27:06======================== UPDATE mac_detail SET pc_name = '2F4', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '298430' ========================2019-12-05 18:32:30======================== noteurl_start parm_app_code = 048 parm_pc_name = 2F1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 2F1 ========================2019-12-05 18:32:30======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 18:32:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-12-05 18:32:30======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2019-12-05 18:32:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2019-12-05 18:32:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2019-12-05 18:32:30======================== UPDATE mac_detail SET pc_name = '2F1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '268463' ========================2019-12-05 18:32:42======================== noteurl_start parm_app_code = 048 parm_pc_name = 2F1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 2F1 ========================2019-12-05 18:32: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 18:32:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-12-05 18:32:42======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2019-12-05 18:32:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2019-12-05 18:32:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2019-12-05 18:32:42======================== UPDATE mac_detail SET pc_name = '2F1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '268463' ========================2019-12-05 18:35:39======================== noteurl_start parm_app_code = 048 parm_pc_name = 2F2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DD940A00B06E21 sCDKey = 434133617514 sName = 2F2 ========================2019-12-05 18:35: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 18:35:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-12-05 18:35:39======================== SELECT idx FROM macs WHERE mac_addr = '988389DD940A00B06E21' AND app_code = '048' ========================2019-12-05 18:35:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285233' ========================2019-12-05 18:35:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285233' ========================2019-12-05 18:35:39======================== UPDATE mac_detail SET pc_name = '2F2', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '285233' ========================2019-12-05 20:50:20======================== noteurl_start parm_app_code = 048 parm_pc_name = 1F1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DF4DC7CCEDF28C sCDKey = 434133617514 sName = 1F1 ========================2019-12-05 20:50: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 20:50:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-12-05 20:50:20======================== SELECT idx FROM macs WHERE mac_addr = '988389DF4DC7CCEDF28C' AND app_code = '048' ========================2019-12-05 20:50:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '299002' ========================2019-12-05 20:50:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '299002' ========================2019-12-05 20:50:20======================== UPDATE mac_detail SET pc_name = '1F1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '299002' ========================2019-12-05 20:50:28======================== noteurl_start parm_app_code = 048 parm_pc_name = 1F1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DF4DC7CCEDF28C sCDKey = 434133617514 sName = 1F1 ========================2019-12-05 20:50: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-05 20:50:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-12-05 20:50:28======================== SELECT idx FROM macs WHERE mac_addr = '988389DF4DC7CCEDF28C' AND app_code = '048' ========================2019-12-05 20:50:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '299002' ========================2019-12-05 20:50:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '299002' ========================2019-12-05 20:50:28======================== UPDATE mac_detail SET pc_name = '1F1', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '299002'