========================2018-01-03 09:43:22======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-SMJG59FC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 646E69B13A298043E48A sCDKey = 983166690172 sName = LAPTOP-SMJG59FC ========================2018-01-03 09:43: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 = '983166690172' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 09:43:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bkzzz77' ========================2018-01-03 09:43:22======================== SELECT idx FROM macs WHERE mac_addr = '646E69B13A298043E48A' AND app_code = '039' ========================2018-01-03 09:43:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238018' ========================2018-01-03 09:43:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238018' ========================2018-01-03 09:43: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 ( '238018', '646E69B13A298043E48A', '039', 'LAPTOP-SMJG59FC', '110', '1920', '1080', 'bkzzz77', '어린이백화점[윤병근]', '983166690172' ) ========================2018-01-03 13:03:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4TOERKK parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 14C91310B16CC2CA84F2 sCDKey = 415277482449 sName = DESKTOP-4TOERKK ========================2018-01-03 13:03: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 = '415277482449' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 13:03:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xjql7' ========================2018-01-03 13:03:57======================== SELECT idx FROM macs WHERE mac_addr = '14C91310B16CC2CA84F2' AND app_code = '039' ========================2018-01-03 13:03:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190049' ========================2018-01-03 13:03:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '190049' ========================2018-01-03 13:03: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 ( '190049', '14C91310B16CC2CA84F2', '039', 'DESKTOP-4TOERKK', '110', '1366', '768', 'xjql7', '제일물류[복석만]', '415277482449' ) ========================2018-01-03 13:04:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4TOERKK parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 14C91310B16CC2CA84F2 sCDKey = 415277482449 sName = DESKTOP-4TOERKK ========================2018-01-03 13:04:15======================== 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 = '415277482449' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 14:27:15======================== noteurl_start parm_app_code = 047 parm_pc_name = MONKEYSUNCLE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAD977E39CE1216E sCDKey = 708074012918 sName = MONKEYSUNCLE ========================2018-01-03 14:27:15======================== 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 = '708074012918' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-03 14:27:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'idealinkkr' ========================2018-01-03 14:27:15======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAD977E39CE1216E' AND app_code = '047' ========================2018-01-03 14:27:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238076' ========================2018-01-03 14:27:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238076' ========================2018-01-03 14:27:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238076', '24F5AAD977E39CE1216E', '047', 'MONKEYSUNCLE', '�쐢�룄�슦 10', '0', '0', 'idealinkkr', '아이디어링크코리아[ 진일기]', '708074012918' ) ========================2018-01-03 14:40:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UQ8MEIH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30AF41F48ECD7199 sCDKey = 474740641298 sName = DESKTOP-UQ8MEIH ========================2018-01-03 14:40: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 = '474740641298' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 14:40:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'minsunjs' ========================2018-01-03 14:40:50======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AF41F48ECD7199' AND app_code = '039' ========================2018-01-03 14:40:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236633' ========================2018-01-03 14:40:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236633' ========================2018-01-03 14:40:50======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UQ8MEIH', os_type = '110', user_id = 'minsunjs', user_name = '해피랜드[박종성]', screen_w = '1920', screen_h = '1080', cdkey = '474740641298' WHERE mac_idx = '236633' ========================2018-01-03 14:42:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UQ8MEIH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30AF41F48ECD7199 sCDKey = 474740641298 sName = DESKTOP-UQ8MEIH ========================2018-01-03 14:42: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 = '474740641298' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 15:43:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2ND8BVU parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 24F5AADEE84A221F7D39 sCDKey = 408240824082 sName = DESKTOP-2ND8BVU ========================2018-01-03 15:43:29======================== 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 = '408240824082' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 16:11:48======================== noteurl_start parm_app_code = 047 parm_pc_name = HHY-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9B7922E87FB70 sCDKey = 298270150760 sName = HHY-PC ========================2018-01-03 16:11: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 = '298270150760' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-03 16:11:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hhy111' ========================2018-01-03 16:11:48======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7922E87FB70' AND app_code = '047' ========================2018-01-03 16:11:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238094' ========================2018-01-03 16:11:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238094' ========================2018-01-03 16:11: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 ( '238094', 'F44D30B9B7922E87FB70', '047', 'HHY-PC', '�쐢�룄�슦 10', '0', '0', 'hhy111', '[황희영]', '298270150760' ) ========================2018-01-03 16:49:23======================== noteurl_start parm_app_code = 047 parm_pc_name = HJH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 737376171670 sName = HJH-PC ========================2018-01-03 16:49: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 = '737376171670' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-03 16:49:47======================== noteurl_start parm_app_code = 047 parm_pc_name = HJH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 950224410979 sName = HJH-PC ========================2018-01-03 16:49: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 = '950224410979' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-03 16:49:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2018-01-03 16:49:47======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '047' ========================2018-01-03 16:49:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229613' ========================2018-01-03 16:49:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229613' ========================2018-01-03 16:49:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '229613', 'F44D30B9AE60D8075059', '047', 'HJH-PC', '�쐢�룄�슦 10', '0', '0', 'wogus36', '[황재현]', '950224410979' ) ========================2018-01-03 17:18:09======================== noteurl_start parm_app_code = 039 parm_pc_name = K-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00012E3011A73471A76E sCDKey = 262571538337 sName = K-PC ========================2018-01-03 17:18:09======================== 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 = '262571538337' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-03 17:18:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimj1121' ========================2018-01-03 17:18:09======================== SELECT idx FROM macs WHERE mac_addr = '00012E3011A73471A76E' AND app_code = '039' ========================2018-01-03 17:18:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238108' ========================2018-01-03 17:18:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238108' ========================2018-01-03 17:18:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238108', '00012E3011A73471A76E', '039', 'K-PC', '90', '1024', '768', 'kimj1121', '가산파레트[이상욱]', '262571538337' ) ========================2018-01-03 22:01:20======================== noteurl_start parm_app_code = 039 parm_pc_name = BOKJU-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E811327F064F44C7D611 sCDKey = 807529902917 sName = BOKJU-PC ========================2018-01-03 22:01: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 = '807529902917' AND r.app_code = '039' AND r.app_block = 0