========================2019-11-13 10:32:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4VAE0M4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30A8B0A3182A00B4 sCDKey = 777168301680 sName = DESKTOP-4VAE0M4 ========================2019-11-13 10:32:17======================== 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 = '777168301680' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 10:32:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'thdrlans6' ========================2019-11-13 10:32:17======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30A8B0A3182A00B4' AND app_code = '039' ========================2019-11-13 10:32:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302677' ========================2019-11-13 10:32:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302677' ========================2019-11-13 10:32:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302677', 'F44D30A8B0A3182A00B4', '039', 'DESKTOP-4VAE0M4', '110', '1920', '1080', 'thdrlans6', '(유)새만금건설중기[송기문]', '777168301680' ) ========================2019-11-13 11:14:50======================== noteurl_start parm_app_code = 047 parm_pc_name = OKPOS parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975AACF10676634BC0 sCDKey = 749447224532 sName = OKPOS ========================2019-11-13 11:14: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-11-13 11:14:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nexus' ========================2019-11-13 11:14:50======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AACF10676634BC0' AND app_code = '047' ========================2019-11-13 11:14:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291062' ========================2019-11-13 11:14:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291062' ========================2019-11-13 11:14:50======================== UPDATE mac_detail SET pc_name = 'OKPOS', os_type = '�쐢�룄�슦 7', user_id = 'nexus', user_name = '넥서스메디케어[박종국]', screen_w = '0', screen_h = '0', cdkey = '749447224532' WHERE mac_idx = '291062' ========================2019-11-13 13:08:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3LDT7LF parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 9883893EBFAF9C512FFF sCDKey = 282901866192 sName = DESKTOP-3LDT7LF ========================2019-11-13 13:08:24======================== 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 = '282901866192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 13:08:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chltjsdhr12' ========================2019-11-13 13:08:24======================== SELECT idx FROM macs WHERE mac_addr = '9883893EBFAF9C512FFF' AND app_code = '039' ========================2019-11-13 13:08:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302692' ========================2019-11-13 13:08:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302692' ========================2019-11-13 13:08:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302692', '9883893EBFAF9C512FFF', '039', 'DESKTOP-3LDT7LF', '110', '1536', '864', 'chltjsdhr12', '성원테크[한광현]', '282901866192' ) ========================2019-11-13 14:12:18======================== noteurl_start parm_app_code = 039 parm_pc_name = BOSUNG-3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00CFE054C80DC63CE48B sCDKey = 188538452662 sName = BOSUNG-3 ========================2019-11-13 14:12: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 = '188538452662' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 14:12:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qhtjd4873' ========================2019-11-13 14:12:18======================== SELECT idx FROM macs WHERE mac_addr = '00CFE054C80DC63CE48B' AND app_code = '039' ========================2019-11-13 14:12:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302709' ========================2019-11-13 14:12:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302709' ========================2019-11-13 14:12: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 ( '302709', '00CFE054C80DC63CE48B', '039', 'BOSUNG-3', '110', '1920', '1080', 'qhtjd4873', '주식획사 보성[전인영]', '188538452662' ) ========================2019-11-13 14:12:28======================== noteurl_start parm_app_code = 039 parm_pc_name = BOSUNG-3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00CFE054C80DC63CE48B sCDKey = 188538452662 sName = BOSUNG-3 ========================2019-11-13 14:12:28======================== 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 = '188538452662' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 14:43:37======================== noteurl_start parm_app_code = 046 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AAB48079803560BC sCDKey = 322585453850 sName = SAMSUNG ========================2019-11-13 14:43:37======================== 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 = '322585453850' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-13 14:43:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimswar' ========================2019-11-13 14:43:37======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAB48079803560BC' AND app_code = '046' ========================2019-11-13 14:43:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302720' ========================2019-11-13 14:43:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302720' ========================2019-11-13 14:43:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302720', '24F5AAB48079803560BC', '046', 'SAMSUNG', '110', '1366', '768', 'kimswar', '태정상사[김태헌]', '322585453850' ) ========================2019-11-13 16:51:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MER586N parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D24FEECD632C4 sCDKey = 420441618513 sName = DESKTOP-MER586N ========================2019-11-13 16:51:08======================== 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 = '420441618513' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 16:52:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MER586N parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D24FEECD632C4 sCDKey = 420441618513 sName = DESKTOP-MER586N ========================2019-11-13 16:52:39======================== 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 = '420441618513' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 16:53:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MER586N parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D24FEECD632C4 sCDKey = 420414618513 sName = DESKTOP-MER586N ========================2019-11-13 16:53:00======================== 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 = '420414618513' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 16:53:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumho1511' ========================2019-11-13 16:53:00======================== SELECT idx FROM macs WHERE mac_addr = '9883892D24FEECD632C4' AND app_code = '039' ========================2019-11-13 16:53:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236807' ========================2019-11-13 16:53:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236807' ========================2019-11-13 16:53:00======================== UPDATE mac_detail SET pc_name = 'DESKTOP-MER586N', os_type = '110', user_id = 'kumho1511', user_name = '금호[설준욱]', screen_w = '1366', screen_h = '768', cdkey = '420414618513' WHERE mac_idx = '236807' ========================2019-11-13 16:57:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MER586N parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892D24FEECD632C4 sCDKey = 420414618513 sName = DESKTOP-MER586N ========================2019-11-13 16:57: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 = '420414618513' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-13 16:57:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumho1511' ========================2019-11-13 16:57:49======================== SELECT idx FROM macs WHERE mac_addr = '9883892D24FEECD632C4' AND app_code = '039' ========================2019-11-13 16:57:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236807' ========================2019-11-13 16:57:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236807' ========================2019-11-13 16:57:49======================== UPDATE mac_detail SET pc_name = 'DESKTOP-MER586N', os_type = '110', user_id = 'kumho1511', user_name = '금호[설준욱]', screen_w = '1366', screen_h = '768', cdkey = '420414618513' WHERE mac_idx = '236807'