========================2018-01-10 09:42:06======================== noteurl_start parm_app_code = 039 parm_pc_name = HANUL-WOOKYUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883892C9822F418804D sCDKey = 412794676239 sName = HANUL-WOOKYUNG ========================2018-01-10 09:42:06======================== 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 = '412794676239' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 09:42:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'industry2' ========================2018-01-10 09:42:06======================== SELECT idx FROM macs WHERE mac_addr = '9883892C9822F418804D' AND app_code = '039' ========================2018-01-10 09:42:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197838' ========================2018-01-10 09:42:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '197838' ========================2018-01-10 09:42:06======================== UPDATE mac_detail SET pc_name = 'HANUL-WOOKYUNG', os_type = '110', user_id = 'industry2', user_name = '(주)한울[이공엽]', screen_w = '1920', screen_h = '1080', cdkey = '412794676239' WHERE mac_idx = '197838' ========================2018-01-10 10:56:33======================== noteurl_start parm_app_code = 039 parm_pc_name = USERR-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E8039A61CD464261FE64 sCDKey = 133584601679 sName = USERR-PC ========================2018-01-10 10:56:33======================== 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 = '133584601679' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 10:56:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ekdltm3994' ========================2018-01-10 10:56:33======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A61CD464261FE64' AND app_code = '039' ========================2018-01-10 10:56:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '210358' ========================2018-01-10 10:56:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '210358' ========================2018-01-10 10:56:33======================== UPDATE mac_detail SET pc_name = 'USERR-PC', os_type = '90', user_id = 'ekdltm3994', user_name = '다이스산업[김도현]', screen_w = '1366', screen_h = '768', cdkey = '133584601679' WHERE mac_idx = '210358' ========================2018-01-10 11:10:12======================== noteurl_start parm_app_code = 047 parm_pc_name = PARK-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D050999946FB986465BA sCDKey = 833615657120 sName = PARK-PC ========================2018-01-10 11:10: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 = '833615657120' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:10:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:10:12======================== SELECT idx FROM macs WHERE mac_addr = 'D050999946FB986465BA' AND app_code = '047' ========================2018-01-10 11:10:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238845' ========================2018-01-10 11:10:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238845' ========================2018-01-10 11:10:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238845', 'D050999946FB986465BA', '047', 'PARK-PC', '�쐢�룄�슦 7', '0', '0', 'parkstool', 'PARK'S TOOL[박동훈]', '833615657120' ) ========================2018-01-10 11:13:44======================== noteurl_start parm_app_code = 047 parm_pc_name = PARK-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D050999946FB986465BA sCDKey = 833615657120 sName = PARK-PC ========================2018-01-10 11:13:44======================== 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 = '833615657120' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:13:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:13:44======================== SELECT idx FROM macs WHERE mac_addr = 'D050999946FB986465BA' AND app_code = '047' ========================2018-01-10 11:13:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238845' ========================2018-01-10 11:13:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238845' ========================2018-01-10 11:13:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238845', 'D050999946FB986465BA', '047', 'PARK-PC', '�쐢�룄�슦 7', '0', '0', 'parkstool', 'PARK'S TOOL[박동훈]', '833615657120' ) ========================2018-01-10 11:14:20======================== noteurl_start parm_app_code = 047 parm_pc_name = PARK-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D050999946FB986465BA sCDKey = 833615657120 sName = PARK-PC ========================2018-01-10 11:14: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 = '833615657120' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:14:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:14:20======================== SELECT idx FROM macs WHERE mac_addr = 'D050999946FB986465BA' AND app_code = '047' ========================2018-01-10 11:14:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238845' ========================2018-01-10 11:14:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238845' ========================2018-01-10 11:14: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 ( '238845', 'D050999946FB986465BA', '047', 'PARK-PC', '�쐢�룄�슦 7', '0', '0', 'parkstool', 'PARK'S TOOL[박동훈]', '833615657120' ) ========================2018-01-10 11:14:59======================== noteurl_start parm_app_code = 047 parm_pc_name = PARK-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D050999946FB986465BA sCDKey = 833615657120 sName = PARK-PC ========================2018-01-10 11:14:59======================== 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 = '833615657120' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:14:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:14:59======================== SELECT idx FROM macs WHERE mac_addr = 'D050999946FB986465BA' AND app_code = '047' ========================2018-01-10 11:14:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238845' ========================2018-01-10 11:14:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238845' ========================2018-01-10 11:14:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238845', 'D050999946FB986465BA', '047', 'PARK-PC', '�쐢�룄�슦 7', '0', '0', 'parkstool', 'PARK'S TOOL[박동훈]', '833615657120' ) ========================2018-01-10 11:15:34======================== noteurl_start parm_app_code = 047 parm_pc_name = PARK-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D050999946FB986465BA sCDKey = 455042820559 sName = PARK-PC ========================2018-01-10 11:15:34======================== 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 = '455042820559' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:15:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:15:34======================== SELECT idx FROM macs WHERE mac_addr = 'D050999946FB986465BA' AND app_code = '047' ========================2018-01-10 11:15:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238845' ========================2018-01-10 11:15:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238845' ========================2018-01-10 11:15:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238845', 'D050999946FB986465BA', '047', 'PARK-PC', '�쐢�룄�슦 7', '0', '0', 'parkstool', 'PARK'S TOOL[박동훈]', '455042820559' ) ========================2018-01-10 11:17: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 = 64E599FB3E060A5DC0D8 sCDKey = 486979617356 sName = 김창원 ========================2018-01-10 11:17: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 = '486979617356' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:17:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2018-01-10 11:17:16======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E060A5DC0D8' AND app_code = '047' ========================2018-01-10 11:17:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223850' ========================2018-01-10 11:17:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223850' ========================2018-01-10 11:17:16======================== UPDATE mac_detail SET pc_name = '김창원', os_type = '�쐢�룄�슦 10', user_id = 'klmm12', user_name = '엠제이소프트[김창원]', screen_w = '0', screen_h = '0', cdkey = '486979617356' WHERE mac_idx = '223850' ========================2018-01-10 11:17:38======================== noteurl_start parm_app_code = 047 parm_pc_name = 김창원 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 64E599FB3E060A5DC0D8 sCDKey = 455042820559 sName = 김창원 ========================2018-01-10 11:17: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 = '455042820559' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:17:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:17:38======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E060A5DC0D8' AND app_code = '047' ========================2018-01-10 11:17:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223850' ========================2018-01-10 11:17:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223850' ========================2018-01-10 11:17:38======================== UPDATE mac_detail SET pc_name = '김창원', os_type = '�쐢�룄�슦 10', user_id = 'parkstool', user_name = 'PARK'S TOOL[박동훈]', screen_w = '0', screen_h = '0', cdkey = '455042820559' WHERE mac_idx = '223850' ========================2018-01-10 11:19:32======================== noteurl_start parm_app_code = 047 parm_pc_name = 김창원 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 64E599FB3E060A5DC0D8 sCDKey = 455042820559 sName = 김창원 ========================2018-01-10 11:19:32======================== 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 = '455042820559' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:19:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:19:32======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E060A5DC0D8' AND app_code = '047' ========================2018-01-10 11:19:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223850' ========================2018-01-10 11:19:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223850' ========================2018-01-10 11:19:32======================== UPDATE mac_detail SET pc_name = '김창원', os_type = '�쐢�룄�슦 10', user_id = 'parkstool', user_name = 'PARK'S TOOL[박동훈]', screen_w = '0', screen_h = '0', cdkey = '455042820559' WHERE mac_idx = '223850' ========================2018-01-10 11:20:33======================== noteurl_start parm_app_code = 047 parm_pc_name = PARK-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D050999946FB986465BA sCDKey = 188650376041 sName = PARK-PC ========================2018-01-10 11:20:33======================== 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 = '188650376041' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-10 11:20:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkstool' ========================2018-01-10 11:20:33======================== SELECT idx FROM macs WHERE mac_addr = 'D050999946FB986465BA' AND app_code = '047' ========================2018-01-10 11:20:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238845' ========================2018-01-10 11:20:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238845' ========================2018-01-10 11:20:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238845', 'D050999946FB986465BA', '047', 'PARK-PC', '�쐢�룄�슦 7', '0', '0', 'parkstool', 'PARKS TOOL[박동훈]', '188650376041' ) ========================2018-01-10 12:56:45======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-HF0J90M parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 3C9509CEF5733AD14C57 sCDKey = 548696432089 sName = DESKTOP-HF0J90M ========================2018-01-10 12:56: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 = '548696432089' AND r.app_code = '045' AND r.app_block = 0 ========================2018-01-10 12:56:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onco' ========================2018-01-10 12:56:45======================== SELECT idx FROM macs WHERE mac_addr = '3C9509CEF5733AD14C57' AND app_code = '045' ========================2018-01-10 12:56:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238863' ========================2018-01-10 12:56:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238863' ========================2018-01-10 12:56: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 ( '238863', '3C9509CEF5733AD14C57', '045', 'DESKTOP-HF0J90M', '110', '1536', '864', 'onco', 'onco/온코[은순조]', '548696432089' ) ========================2018-01-10 16:00:12======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 00E1160999A3A49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-10 16:00: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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 16:00:50======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 00E1160999A3A49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-10 16:00: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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 16:04:21======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 00E1160999A3A49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-10 16:04:21======================== 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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 16:04:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k9025' ========================2018-01-10 16:04:21======================== SELECT idx FROM macs WHERE mac_addr = '00E1160999A3A49B53B7' AND app_code = '039' ========================2018-01-10 16:04:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '165618' ========================2018-01-10 16:04:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '165618' ========================2018-01-10 16:04:21======================== UPDATE mac_detail SET pc_name = 'PC', os_type = '110', user_id = 'k9025', user_name = '(주)중동물류[김양곤]', screen_w = '1536', screen_h = '864', cdkey = '755192599021' WHERE mac_idx = '165618' ========================2018-01-10 16:32:23======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = ========================2018-01-10 16:32: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-10 16:32:35======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-10 16:32:35======================== 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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-10 16:40:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5MR7LEB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883893DE698825F895F sCDKey = 982020621805 sName = DESKTOP-5MR7LEB ========================2018-01-10 16:40:34======================== 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 = '982020621805' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 16:41:55======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = ========================2018-01-10 16:41: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-10 16:42:07======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-10 16:42:07======================== 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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-10 16:42:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5MR7LEB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883893DE698825F895F sCDKey = 982020621805 sName = DESKTOP-5MR7LEB ========================2018-01-10 16:42: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 = '982020621805' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-10 16:42:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'besttech' ========================2018-01-10 16:42:23======================== SELECT idx FROM macs WHERE mac_addr = '9883893DE698825F895F' AND app_code = '039' ========================2018-01-10 16:42:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236695' ========================2018-01-10 16:42:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236695' ========================2018-01-10 16:42: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 ( '236695', '9883893DE698825F895F', '039', 'DESKTOP-5MR7LEB', '110', '1920', '1080', 'besttech', 'besttech[유복균]', '982020621805' ) ========================2018-01-10 16:42:50======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-10 16:42: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-10 16:43:43======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-10 16:43:43======================== 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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-10 16:43:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'iicooii' ========================2018-01-10 16:43:43======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A64E5C2CF7C7D7' AND app_code = '050' ========================2018-01-10 16:43:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '159882' ========================2018-01-10 16:43:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '159882' ========================2018-01-10 16:43:43======================== UPDATE mac_detail SET pc_name = '경상북도환경연수원', os_type = '90', user_id = 'iicooii', user_name = '경상북도환경연수원[이진숙]', screen_w = '1920', screen_h = '1080', cdkey = '922590601683' WHERE mac_idx = '159882' ========================2018-01-10 17:15:34======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-10 17:15:34======================== 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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0