========================2019-04-10 10:00:20======================== noteurl_start parm_app_code = 050 parm_pc_name = SUNHWAKIM parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D8FC934236AAA2C3D2B9 sCDKey = 452775506015 sName = JUNGHYUN ========================2019-04-10 10:00: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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2019-04-10 10:00:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecstel' ========================2019-04-10 10:00:20======================== SELECT idx FROM macs WHERE mac_addr = 'D8FC934236AAA2C3D2B9' AND app_code = '050' ========================2019-04-10 10:00:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282955' ========================2019-04-10 10:00:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282955' ========================2019-04-10 10:00: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 ( '282955', 'D8FC934236AAA2C3D2B9', '050', 'JUNGHYUN', '109', '1680', '1050', 'ecstel', '(주)이씨에스텔레콤[유지해]', '452775506015' ) ========================2019-04-10 12:45:38======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0519E447F566 sCDKey = C86000CBB9A8 sName = subpos ========================2019-04-10 12:45: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 = 'C86000CBB9A8' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-10 12:45:52======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E89A8FDB0519E447F566 sCDKey = 865918677414 sName = subpos ========================2019-04-10 12:45:52======================== 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 = '865918677414' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-10 12:45:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sprit01' ========================2019-04-10 12:45:52======================== SELECT idx FROM macs WHERE mac_addr = 'E89A8FDB0519E447F566' AND app_code = '046' ========================2019-04-10 12:45:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282980' ========================2019-04-10 12:45:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282980' ========================2019-04-10 12:45:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '282980', 'E89A8FDB0519E447F566', '046', 'subpos', '90', '1920', '1080', 'sprit01', '신화종합상사[이재훈]', '865918677414' ) ========================2019-04-10 12:47:58======================== noteurl_start parm_app_code = 051 parm_pc_name = 배미숙 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F8BC1260161538D0A90B sCDKey = 670894355181 sName = 배미숙 ========================2019-04-10 12:47: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 = '670894355181' AND r.app_code = '051' AND r.app_block = 0 ========================2019-04-10 12:47:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'across' ========================2019-04-10 12:47:58======================== SELECT idx FROM macs WHERE mac_addr = 'F8BC1260161538D0A90B' AND app_code = '051' ========================2019-04-10 12:47:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256671' ========================2019-04-10 12:47:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256671' ========================2019-04-10 12:47:58======================== UPDATE mac_detail SET pc_name = '배미숙', os_type = '109', user_id = 'across', user_name = '아크로스[김현철]', screen_w = '1920', screen_h = '1080', cdkey = '670894355181' WHERE mac_idx = '256671' ========================2019-04-10 12:48:09======================== noteurl_start parm_app_code = 051 parm_pc_name = 배미숙 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F8BC1260161538D0A90B sCDKey = 670894355181 sName = 배미숙 ========================2019-04-10 12:48: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 = '670894355181' AND r.app_code = '051' AND r.app_block = 0 ========================2019-04-10 12:48:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'across' ========================2019-04-10 12:48:09======================== SELECT idx FROM macs WHERE mac_addr = 'F8BC1260161538D0A90B' AND app_code = '051' ========================2019-04-10 12:48:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256671' ========================2019-04-10 12:48:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256671' ========================2019-04-10 12:48:09======================== UPDATE mac_detail SET pc_name = '배미숙', os_type = '109', user_id = 'across', user_name = '아크로스[김현철]', screen_w = '1920', screen_h = '1080', cdkey = '670894355181' WHERE mac_idx = '256671' ========================2019-04-10 22:08:50======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 181DEA744974D87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-04-10 22:08: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-04-10 22:08:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-04-10 22:08:50======================== SELECT idx FROM macs WHERE mac_addr = '181DEA744974D87CAEF4' AND app_code = '048' ========================2019-04-10 22:08:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283043' ========================2019-04-10 22:08:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283043' ========================2019-04-10 22:08:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283043', '181DEA744974D87CAEF4', '048', '김수영', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2019-04-10 22:09:02======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 181DEA744974D87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-04-10 22:09: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0