========================2018-03-26 09:32:49======================== noteurl_start parm_app_code = 045 parm_pc_name = MASTER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4061864CDC4DEE482FDF sCDKey = 108939469800 sName = MASTER-PC ========================2018-03-26 09:32:49======================== 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 = '108939469800' AND r.app_code = '045' AND r.app_block = 0 ========================2018-03-26 09:32:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dbfintl' ========================2018-03-26 09:32:49======================== SELECT idx FROM macs WHERE mac_addr = '4061864CDC4DEE482FDF' AND app_code = '045' ========================2018-03-26 09:32:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245445' ========================2018-03-26 09:32:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245445' ========================2018-03-26 09:32:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245445', '4061864CDC4DEE482FDF', '045', 'MASTER-PC', '90', '1920', '1080', 'dbfintl', '주식회사 서머힐[최종원]', '108939469800' ) ========================2018-03-26 09:46:46======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-180324 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E5FEBA1EE1BAE66 sCDKey = 854339586637 sName = WIN7-180324 ========================2018-03-26 09:46:46======================== 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 = '854339586637' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-26 09:46:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds8445' ========================2018-03-26 09:46:46======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E5FEBA1EE1BAE66' AND app_code = '039' ========================2018-03-26 09:46:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245448' ========================2018-03-26 09:46:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245448' ========================2018-03-26 09:46:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245448', 'E0D55E5FEBA1EE1BAE66', '039', 'WIN7-180324', '90', '1920', '1080', 'ds8445', '(주)대신분체산업[조영구]', '854339586637' ) ========================2018-03-26 11:01:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-25EQ2R8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F8633FDE15CADAB017AA sCDKey = 492270825060 sName = DESKTOP-25EQ2R8 ========================2018-03-26 11:01:18======================== 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 = '492270825060' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-26 11:01:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rkdxk67' ========================2018-03-26 11:01:18======================== SELECT idx FROM macs WHERE mac_addr = 'F8633FDE15CADAB017AA' AND app_code = '039' ========================2018-03-26 11:01:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245462' ========================2018-03-26 11:01:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245462' ========================2018-03-26 11:01:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245462', 'F8633FDE15CADAB017AA', '039', 'DESKTOP-25EQ2R8', '110', '1920', '1080', 'rkdxk67', '재현[이형종]', '492270825060' ) ========================2018-03-26 15:07:07======================== noteurl_start parm_app_code = 047 parm_pc_name = KIM parm_os_type = �쐢�룄�슦 8.1 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435ECDB9CBE59138A sCDKey = 007924545318 sName = KIM ========================2018-03-26 15: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 = '007924545318' AND r.app_code = '047' AND r.app_block = 0 ========================2018-03-26 15:07:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ninanonam' ========================2018-03-26 15:07:07======================== SELECT idx FROM macs WHERE mac_addr = '74D435ECDB9CBE59138A' AND app_code = '047' ========================2018-03-26 15:07:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245498' ========================2018-03-26 15:07:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245498' ========================2018-03-26 15:07:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245498', '74D435ECDB9CBE59138A', '047', 'KIM', '�쐢�룄�슦 8.1', '0', '0', 'ninanonam', '위튼버그교육[김희남]', '007924545318' ) ========================2018-03-26 15:08:40======================== noteurl_start parm_app_code = 048 parm_pc_name = KIM parm_os_type = �쐢�룄�슦 8.1 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435ECDB9CBE59138A sCDKey = 436155231700 sName = KIM ========================2018-03-26 15:08:40======================== 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 = '436155231700' AND r.app_code = '048' AND r.app_block = 0 ========================2018-03-26 15:08:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ninanonam' ========================2018-03-26 15:08:40======================== SELECT idx FROM macs WHERE mac_addr = '74D435ECDB9CBE59138A' AND app_code = '048' ========================2018-03-26 15:08:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245499' ========================2018-03-26 15:08:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245499' ========================2018-03-26 15:08:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245499', '74D435ECDB9CBE59138A', '048', 'KIM', '�쐢�룄�슦 8.1', '0', '0', 'ninanonam', '위튼버그교육[김희남]', '436155231700' ) ========================2018-03-26 15:43:02======================== noteurl_start parm_app_code = 047 parm_pc_name = KIM parm_os_type = �쐢�룄�슦 8.1 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435ECDB9CBE59138A sCDKey = 471697962089 sName = KIM ========================2018-03-26 15:43: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 = '471697962089' AND r.app_code = '047' AND r.app_block = 0 ========================2018-03-26 15:43:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wittenglish' ========================2018-03-26 15:43:02======================== SELECT idx FROM macs WHERE mac_addr = '74D435ECDB9CBE59138A' AND app_code = '047' ========================2018-03-26 15:43:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245498' ========================2018-03-26 15:43:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245498' ========================2018-03-26 15:43:02======================== UPDATE mac_detail SET pc_name = 'KIM', os_type = '�쐢�룄�슦 8.1', user_id = 'wittenglish', user_name = '(주)위튼버그교육[김희남]', screen_w = '0', screen_h = '0', cdkey = '471697962089' WHERE mac_idx = '245498' ========================2018-03-26 15:44:06======================== noteurl_start parm_app_code = 048 parm_pc_name = KIM parm_os_type = �쐢�룄�슦 8.1 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435ECDB9CBE59138A sCDKey = 302107681506 sName = KIM ========================2018-03-26 15:44: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 = '302107681506' AND r.app_code = '048' AND r.app_block = 0 ========================2018-03-26 15:44:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wittenglish' ========================2018-03-26 15:44:06======================== SELECT idx FROM macs WHERE mac_addr = '74D435ECDB9CBE59138A' AND app_code = '048' ========================2018-03-26 15:44:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245499' ========================2018-03-26 15:44:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245499' ========================2018-03-26 15:44:06======================== UPDATE mac_detail SET pc_name = 'KIM', os_type = '�쐢�룄�슦 8.1', user_id = 'wittenglish', user_name = '(주)위튼버그교육[김희남]', screen_w = '0', screen_h = '0', cdkey = '302107681506' WHERE mac_idx = '245499' ========================2018-03-26 16:20:47======================== noteurl_start parm_app_code = 039 parm_pc_name = BLUEON parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 909F330FC991C6640FE sCDKey = 021195728335 sName = BLUEON ========================2018-03-26 16:20: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 = '021195728335' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-26 16:20:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dkenl7' ========================2018-03-26 16:20:47======================== SELECT idx FROM macs WHERE mac_addr = '909F330FC991C6640FE' AND app_code = '039' ========================2018-03-26 16:20:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245509' ========================2018-03-26 16:20:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245509' ========================2018-03-26 16:20: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 ( '245509', '909F330FC991C6640FE', '039', 'BLUEON', '110', '1920', '1080', 'dkenl7', 'BLUEON[전성진]', '021195728335' ) ========================2018-03-26 16:22:34======================== noteurl_start parm_app_code = 039 parm_pc_name = BLUEON parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 909F330FC991C6640FE sCDKey = 939642990293 sName = 써니홈 ========================2018-03-26 16:22: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 = '939642990293' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-26 16:22:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dkenl8' ========================2018-03-26 16:22:34======================== SELECT idx FROM macs WHERE mac_addr = '909F330FC991C6640FE' AND app_code = '039' ========================2018-03-26 16:22:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245509' ========================2018-03-26 16:22:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245509' ========================2018-03-26 16:22:34======================== UPDATE mac_detail SET pc_name = '써니홈', os_type = '110', user_id = 'dkenl8', user_name = '써니홈[전성진]', screen_w = '1920', screen_h = '1080', cdkey = '939642990293' WHERE mac_idx = '245509'