========================2019-11-11 09:26:51======================== noteurl_start parm_app_code = 039 parm_pc_name = 2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C6822A05EBBB4B3 sCDKey = 780420206219 sName = 2 ========================2019-11-11 09:26: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 = '780420206219' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-11 09:26:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssal5707' ========================2019-11-11 09:26:51======================== SELECT idx FROM macs WHERE mac_addr = '408D5C6822A05EBBB4B3' AND app_code = '039' ========================2019-11-11 09:26:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190880' ========================2019-11-11 09:26:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '190880' ========================2019-11-11 09:26:51======================== UPDATE mac_detail SET pc_name = '2', os_type = '90', user_id = 'ssal5707', user_name = '좋은이웃[조형석]', screen_w = '1920', screen_h = '1080', cdkey = '780420206219' WHERE mac_idx = '190880' ========================2019-11-11 09:28:18======================== noteurl_start parm_app_code = 039 parm_pc_name = USER0001 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 50B7C38B8376B22E4 sCDKey = 924492519244 sName = USER0001 ========================2019-11-11 09:28: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 = '924492519244' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-11 09:28:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjj5652' ========================2019-11-11 09:28:18======================== SELECT idx FROM macs WHERE mac_addr = '50B7C38B8376B22E4' AND app_code = '039' ========================2019-11-11 09:28:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302407' ========================2019-11-11 09:28:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302407' ========================2019-11-11 09:28: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 ( '302407', '50B7C38B8376B22E4', '039', 'USER0001', '110', '1366', '768', 'cjj5652', '진영메디칼[최정진]', '924492519244' ) ========================2019-11-11 10:51:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LR06MRP parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 448A5BB7369580A863C7 sCDKey = 060415940283 sName = DESKTOP-LR06MRP ========================2019-11-11 10:51: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 = '060415940283' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-11 10:51:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jgmoonk' ========================2019-11-11 10:51:51======================== SELECT idx FROM macs WHERE mac_addr = '448A5BB7369580A863C7' AND app_code = '039' ========================2019-11-11 10:51:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302499' ========================2019-11-11 10:51:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302499' ========================2019-11-11 10:51:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302499', '448A5BB7369580A863C7', '039', 'DESKTOP-LR06MRP', '110', '1360', '768', 'jgmoonk', '사천유통[문재규]', '060415940283' ) ========================2019-11-11 14:44:48======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-0OILSAC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F12F50DECA0EAAC sCDKey = 788532054684 sName = DESKTOP-0OILSAC ========================2019-11-11 14:44: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 = '788532054684' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-11 14:44:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hijaje' ========================2019-11-11 14:44:48======================== SELECT idx FROM macs WHERE mac_addr = '702C1F12F50DECA0EAAC' AND app_code = '046' ========================2019-11-11 14:44:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302458' ========================2019-11-11 14:44:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302458' ========================2019-11-11 14:44:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302458', '702C1F12F50DECA0EAAC', '046', 'DESKTOP-0OILSAC', '110', '1920', '1080', 'hijaje', '헌인자재[박철교]', '788532054684' ) ========================2019-11-11 15:59:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-J57SLFQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E900E19F34703F4E sCDKey = 567698298290 sName = DESKTOP-J57SLFQ ========================2019-11-11 15:59: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 = '567698298290' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-11 15:59:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'isshin21c' ========================2019-11-11 15:59:50======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E900E19F34703F4E' AND app_code = '039' ========================2019-11-11 15:59:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302530' ========================2019-11-11 15:59:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302530' ========================2019-11-11 15:59:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302530', '8CB0E900E19F34703F4E', '039', 'DESKTOP-J57SLFQ', '110', '1920', '1080', 'isshin21c', 'SB BESTECH[신인숙]', '567698298290' )