========================2018-02-01 09:36:28======================== noteurl_start parm_app_code = 047 parm_pc_name = 한지수 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 128305455054 sName = 한지수 ========================2018-02-01 09:36: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 = '128305455054' AND r.app_code = '047' AND r.app_block = 0 ========================2018-02-01 09:36:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjs1' ========================2018-02-01 09:36:28======================== SELECT idx FROM macs WHERE mac_addr = '6C626D5D391AAE81FA52' AND app_code = '047' ========================2018-02-01 09:36:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240983' ========================2018-02-01 09:36:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240983' ========================2018-02-01 09:36:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240983', '6C626D5D391AAE81FA52', '047', '한지수', '�쐢�룄�슦 10', '0', '0', 'hjs1', '엠제이소프트[한지수]', '128305455054' ) ========================2018-02-01 12:24:39======================== noteurl_start parm_app_code = 046 parm_pc_name = LAPTOP-L43LE055 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = E82A447CC8ED3699F095 sCDKey = 003400982708 sName = LAPTOP-L43LE055 ========================2018-02-01 12:24: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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-01 13:03:30======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8113230D76FC0927C7E sCDKey = 246099625917 sName = USER-PC ========================2018-02-01 13:03: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 = '246099625917' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-01 13:04:30======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8113230D76FC0927C7E sCDKey = 246099625917 sName = USER-PC ========================2018-02-01 13: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 = '246099625917' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-01 13:04:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tjwlst' ========================2018-02-01 13:04:30======================== SELECT idx FROM macs WHERE mac_addr = 'E8113230D76FC0927C7E' AND app_code = '039' ========================2018-02-01 13:04:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239536' ========================2018-02-01 13:04:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239536' ========================2018-02-01 13: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 ( '239536', 'E8113230D76FC0927C7E', '039', 'USER-PC', '90', '1920', '1080', 'tjwlst', '서진센서[조성춘]', '246099625917' ) ========================2018-02-01 13:19:43======================== noteurl_start parm_app_code = 050 parm_pc_name = 03-00882 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 24F5AABFAE76F0731E46 sCDKey = 114919380891 sName = 03-00882 ========================2018-02-01 13:19:43======================== 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 = '114919380891' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-01 13:19:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n00347' ========================2018-02-01 13:19:43======================== SELECT idx FROM macs WHERE mac_addr = '24F5AABFAE76F0731E46' AND app_code = '050' ========================2018-02-01 13:19:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239014' ========================2018-02-01 13:19:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239014' ========================2018-02-01 13:19:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239014', '24F5AABFAE76F0731E46', '050', '03-00882', '90', '1600', '900', 'n00347', '(주)엔바이콘[남우현]', '114919380891' ) ========================2018-02-01 13:19:52======================== noteurl_start parm_app_code = 050 parm_pc_name = 03-00882 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 24F5AABFAE76F0731E46 sCDKey = 114919380891 sName = 03-00882 ========================2018-02-01 13:19: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 = '114919380891' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-01 14:08:45======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D027887E1A048A2F7929 sCDKey = 356619195645 sName = USER-PC ========================2018-02-01 14:08:45======================== 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 = '356619195645' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-01 14:08:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ed1130' ========================2018-02-01 14:08:45======================== SELECT idx FROM macs WHERE mac_addr = 'D027887E1A048A2F7929' AND app_code = '039' ========================2018-02-01 14:08:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241025' ========================2018-02-01 14:08:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241025' ========================2018-02-01 14:08:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241025', 'D027887E1A048A2F7929', '039', 'USER-PC', '90', '1920', '1080', 'ed1130', '원푸드[최은실]', '356619195645' ) ========================2018-02-01 14:08:51======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D027887E1A048A2F7929 sCDKey = 356619195645 sName = USER-PC ========================2018-02-01 14:08:51======================== 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 = '356619195645' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-01 14:45:06======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F2332FCAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2018-02-01 14:45: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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-01 14:47:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F2332FCAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2018-02-01 14:47:56======================== 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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-01 14:47:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chojaeseong' ========================2018-02-01 14:47:56======================== SELECT idx FROM macs WHERE mac_addr = '702C1F2332FCAA233C88' AND app_code = '046' ========================2018-02-01 14:47:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241032' ========================2018-02-01 14:47:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241032' ========================2018-02-01 14:47:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241032', '702C1F2332FCAA233C88', '046', 'DESKTOP-RIU7E7C', '110', '1366', '768', 'chojaeseong', '미소매점[조재성]', '003400982708' ) ========================2018-02-01 17:50:22======================== noteurl_start parm_app_code = 039 parm_pc_name = AASA parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C8F733BC6D8AF2EE8C sCDKey = 210742859361 sName = AASA ========================2018-02-01 17:50:22======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-01 17:50:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2018-02-01 17:50:22======================== SELECT idx FROM macs WHERE mac_addr = 'C8F733BC6D8AF2EE8C' AND app_code = '039' ========================2018-02-01 17:50:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241038' ========================2018-02-01 17:50:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241038' ========================2018-02-01 17:50:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241038', 'C8F733BC6D8AF2EE8C', '039', 'AASA', '110', '1366', '768', 'julee37', '개성자바라, 스텐나라[이순녀]', '210742859361' )