========================2019-06-21 09:18:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OT5HQ7M parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C45444586BFF16B96DB0 sCDKey = 870947340146 sName = DESKTOP-OT5HQ7M ========================2019-06-21 09:18: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 = '870947340146' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-21 09:18:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nomul6837' ========================2019-06-21 09:18:31======================== SELECT idx FROM macs WHERE mac_addr = 'C45444586BFF16B96DB0' AND app_code = '039' ========================2019-06-21 09:18:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288887' ========================2019-06-21 09:18:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288887' ========================2019-06-21 09:18:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '288887', 'C45444586BFF16B96DB0', '039', 'DESKTOP-OT5HQ7M', '110', '1366', '768', 'nomul6837', '독도렌탈[하철만]', '870947340146' ) ========================2019-06-21 14:58:31======================== noteurl_start parm_app_code = 050 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = ECA86BF58962AE400728 sCDKey = 453035850767 sName = USER-PC ========================2019-06-21 14:58: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 = '453035850767' AND r.app_code = '050' AND r.app_block = 0 ========================2019-06-21 14:58:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'happyehwa' ========================2019-06-21 14:58:31======================== SELECT idx FROM macs WHERE mac_addr = 'ECA86BF58962AE400728' AND app_code = '050' ========================2019-06-21 14:58:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288919' ========================2019-06-21 14:58:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288919' ========================2019-06-21 14:58:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '288919', 'ECA86BF58962AE400728', '050', 'USER-PC', '90', '1600', '900', 'happyehwa', '이화영아원[김혜선]', '453035850767' ) ========================2019-06-21 15:08:15======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AF52EF1942362F3 sCDKey = 886618054887 sName = ADMINISTRATOR ========================2019-06-21 15:08: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 = '886618054887' AND r.app_code = '046' AND r.app_block = 0 ========================2019-06-21 15:08:32======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AF52EF1942362F3 sCDKey = 886618054887 sName = ADMINISTRATOR ========================2019-06-21 15:08: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 = '886618054887' AND r.app_code = '046' AND r.app_block = 0 ========================2019-06-21 15:08:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'snow96321' ========================2019-06-21 15:08:32======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AF52EF1942362F3' AND app_code = '046' ========================2019-06-21 15:08:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288925' ========================2019-06-21 15:08:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288925' ========================2019-06-21 15:08:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '288925', 'B8975AF52EF1942362F3', '046', 'ADMINISTRATOR', '90', '1024', '768', 'snow96321', '총각종합식자재[권익환]', '886618054887' ) ========================2019-06-21 15:18:55======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-G1U2KPQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA14E7190E2A27F870 sCDKey = 013188732434 sName = DESKTOP-G1U2KPQ ========================2019-06-21 15:18: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 = '013188732434' AND r.app_code = '045' AND r.app_block = 0 ========================2019-06-21 15:18:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkhcjn' ========================2019-06-21 15:18:55======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14E7190E2A27F870' AND app_code = '045' ========================2019-06-21 15:18:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288927' ========================2019-06-21 15:18:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288927' ========================2019-06-21 15:18:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '288927', 'FCAA14E7190E2A27F870', '045', 'DESKTOP-G1U2KPQ', '110', '1920', '1080', 'kkhcjn', '토모로[강경희]', '013188732434' ) ========================2019-06-21 16:37:33======================== noteurl_start parm_app_code = 039 parm_pc_name = TINK-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00012E67AA7D64854189 sCDKey = 041272903447 sName = TINK-PC ========================2019-06-21 16:37: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 = '041272903447' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-21 16:37:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tink019' ========================2019-06-21 16:37:33======================== SELECT idx FROM macs WHERE mac_addr = '00012E67AA7D64854189' AND app_code = '039' ========================2019-06-21 16:37:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288939' ========================2019-06-21 16:37:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288939' ========================2019-06-21 16:37: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 ( '288939', '00012E67AA7D64854189', '039', 'TINK-PC', '90', '1280', '1024', 'tink019', 'TINK[이상회]', '041272903447' )