========================2018-10-05 09:36:55======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-20150330ZP parm_os_type = 90 parm_screen_w = 1776 parm_screen_h = 1000 parm_user_mac = FCAA1467F6F9C2CAC037 sCDKey = 752997096570 sName = WIN7-20150330ZP ========================2018-10-05 09:36: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 = '752997096570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-05 09:36:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kpmaterials' ========================2018-10-05 09:36:55======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA1467F6F9C2CAC037' AND app_code = '039' ========================2018-10-05 09:36:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259968' ========================2018-10-05 09:36:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259968' ========================2018-10-05 09:36: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 ( '259968', 'FCAA1467F6F9C2CAC037', '039', 'WIN7-20150330ZP', '90', '1776', '1000', 'kpmaterials', '케이피매터리얼즈[박규]', '752997096570' ) ========================2018-10-05 10:09:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OVR533B parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 780CB863720C62C6CED0 sCDKey = 506359904945 sName = DESKTOP-OVR533B ========================2018-10-05 10:09: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 = '506359904945' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 10:16:31======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OVR533B parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 780CB863720C62C6CED0 sCDKey = 506359904945 sName = DESKTOP-OVR533B ========================2018-10-05 10:16: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 = '506359904945' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 10:16:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'coopet' ========================2018-10-05 10:16:31======================== SELECT idx FROM macs WHERE mac_addr = '780CB863720C62C6CED0' AND app_code = '046' ========================2018-10-05 10:16:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261585' ========================2018-10-05 10:16:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261585' ========================2018-10-05 10:16: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 ( '261585', '780CB863720C62C6CED0', '046', 'DESKTOP-OVR533B', '110', '1366', '768', 'coopet', '쿠펫[허옥남]', '506359904945' ) ========================2018-10-05 11:55:32======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80E98CF5EEE7DC0E sCDKey = 527769017292 sName = ADMIN-PC ========================2018-10-05 11:55: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 = '527769017292' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-05 11:55:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yytk77' ========================2018-10-05 11:55:32======================== SELECT idx FROM macs WHERE mac_addr = '94DE80E98CF5EEE7DC0E' AND app_code = '039' ========================2018-10-05 11:55:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261597' ========================2018-10-05 11:55:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261597' ========================2018-10-05 11:55: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 ( '261597', '94DE80E98CF5EEE7DC0E', '039', 'ADMIN-PC', '90', '1920', '1080', 'yytk77', '왕왕테크[진거부]', '527769017292' ) ========================2018-10-05 12:52:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 831910938114 sName = DESKTOP-4LJET51 ========================2018-10-05 12:52: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 = '831910938114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:52:27======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 831910938114 sName = NBBSUS ========================2018-10-05 12:52:27======================== 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 = '831910938114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:52:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 591718846901 sName = NBBSUS ========================2018-10-05 12:52: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 = '591718846901' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:53:15======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 831910938114 sName = 오진오 ========================2018-10-05 12:53: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 = '831910938114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:53:34======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 831910938114 sName = nbbsus ========================2018-10-05 12:53: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 = '831910938114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:53:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 591718846901 sName = nbbsus ========================2018-10-05 12:53: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 = '591718846901' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:54:13======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 831910938114 sName = DESKTOP-4LJET51 ========================2018-10-05 12:54:13======================== 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 = '831910938114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:54:23======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 591718846901 sName = DESKTOP-4LJET51 ========================2018-10-05 12:54:23======================== 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 = '591718846901' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 12:54:48======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4LJET51 parm_os_type = 110 parm_screen_w = 3072 parm_screen_h = 1728 parm_user_mac = AC2B6EBC4FBCE4B48321 sCDKey = 831910938114 sName = DESKTOP-4LJET51 ========================2018-10-05 12:54:48======================== 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 = '831910938114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-05 14:03:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DAERIM-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8113239F27132A69AEA sCDKey = 204945315397 sName = DAERIM-PC ========================2018-10-05 14:03:29======================== 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 = '204945315397' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-05 14:03:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daerim1921' ========================2018-10-05 14:03:29======================== SELECT idx FROM macs WHERE mac_addr = 'E8113239F27132A69AEA' AND app_code = '039' ========================2018-10-05 14:03:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260452' ========================2018-10-05 14:03:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260452' ========================2018-10-05 14:03:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260452', 'E8113239F27132A69AEA', '039', 'DAERIM-PC', '90', '1600', '900', 'daerim1921', '대림[공이택]', '204945315397' ) ========================2018-10-05 14:03:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DAERIM-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8113239F27132A69AEA sCDKey = 204945315397 sName = DAERIM-PC ========================2018-10-05 14:03: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 = '204945315397' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-05 17:22:22======================== noteurl_start parm_app_code = 048 parm_pc_name = KCG-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D304C7862A6138453 sCDKey = 557205780622 sName = KCG-PC ========================2018-10-05 17:22: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 = '557205780622' AND r.app_code = '048' AND r.app_block = 0 ========================2018-10-05 17:22:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2018-10-05 17:22:22======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '048' ========================2018-10-05 17:22:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237866' ========================2018-10-05 17:22:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237866' ========================2018-10-05 17:22:22======================== UPDATE mac_detail SET pc_name = 'KCG-PC', os_type = '�쐢�룄�슦 10', user_id = 'gyu1001', user_name = '창규식품[권창규]', screen_w = '0', screen_h = '0', cdkey = '557205780622' WHERE mac_idx = '237866'