========================2018-12-27 09:29:31======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AABFAF656EA36BD3 sCDKey = 870286827806 sName = 신우01 ========================2018-12-27 09:29: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-27 09:29:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2018-12-27 09:29:31======================== SELECT idx FROM macs WHERE mac_addr = '24F5AABFAF656EA36BD3' AND app_code = '039' ========================2018-12-27 09:29:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '119387' ========================2018-12-27 09:29:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '119387' ========================2018-12-27 09:29:31======================== UPDATE mac_detail SET pc_name = '신우01', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '119387' ========================2018-12-27 10:04:30======================== noteurl_start parm_app_code = 045 parm_pc_name = 송영훈 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B7BFA6AF825E sCDKey = 114566407891 sName = 송영훈 ========================2018-12-27 10:04: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 = '114566407891' AND r.app_code = '045' AND r.app_block = 0 ========================2018-12-27 10:04:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mailo7' ========================2018-12-27 10:04:30======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7BFA6AF825E' AND app_code = '045' ========================2018-12-27 10:04:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266720' ========================2018-12-27 10:04:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266720' ========================2018-12-27 10:04:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '266720', 'F44D30B9B7BFA6AF825E', '045', '송영훈', '110', '1920', '1080', 'mailo7', '송영훈[송영훈]', '114566407891' ) ========================2018-12-27 11:00:19======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAB21F636EA36BD3 sCDKey = 870286827806 sName = 신우01 ========================2018-12-27 11:00: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-27 11:00:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2018-12-27 11:00:19======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAB21F636EA36BD3' AND app_code = '039' ========================2018-12-27 11:00:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '122325' ========================2018-12-27 11:00:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '122325' ========================2018-12-27 11:00:19======================== UPDATE mac_detail SET pc_name = '신우01', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '122325' ========================2018-12-27 13:07:07======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C6F6535039758C64156 sCDKey = 616845460996 sName = WIN ========================2018-12-27 13:07: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 = '616845460996' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-27 13:07:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwp6767' ========================2018-12-27 13:07:07======================== SELECT idx FROM macs WHERE mac_addr = '1C6F6535039758C64156' AND app_code = '039' ========================2018-12-27 13:07:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '116789' ========================2018-12-27 13:07:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '116789' ========================2018-12-27 13:07:07======================== UPDATE mac_detail SET pc_name = 'WIN', os_type = '110', user_id = 'jwp6767', user_name = '정우사[이윤희]', screen_w = '1920', screen_h = '1080', cdkey = '616845460996' WHERE mac_idx = '116789' ========================2018-12-27 16:04:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732DD904EE2B1141 sCDKey = 887151283293 sName = DESKTOP-IR4BE71 ========================2018-12-27 16:04: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 = '887151283293' AND r.app_code = '047' AND r.app_block = 0 ========================2018-12-27 16:04:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ansiki' ========================2018-12-27 16:04:04======================== SELECT idx FROM macs WHERE mac_addr = '50AF732DD904EE2B1141' AND app_code = '047' ========================2018-12-27 16:04:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272166' ========================2018-12-27 16:04:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272166' ========================2018-12-27 16:04:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272166', '50AF732DD904EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'ansiki', '동명금속[최안식]', '887151283293' )