========================2020-04-22 08:51:13======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 803253F4639D6DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2020-04-22 08:51: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-22 08:51:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-04-22 08:51:13======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-04-22 08:51:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312854' ========================2020-04-22 08:51:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312854' ========================2020-04-22 08:51:13======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '312854' ========================2020-04-22 08:51:24======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 803253F4639D6DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2020-04-22 08:51: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-22 08:51:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-04-22 08:51:25======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-04-22 08:51:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312854' ========================2020-04-22 08:51:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312854' ========================2020-04-22 08:51:25======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '312854' ========================2020-04-22 10:29:25======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-IM6C3MC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4BED9EB0CBAA0B91B2B sCDKey = 429712037749 sName = DESKTOP-IM6C3MC ========================2020-04-22 10:29:25======================== 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 = '429712037749' AND r.app_code = '051' AND r.app_block = 0 ========================2020-04-22 10:29:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dyetec' ========================2020-04-22 10:29:25======================== SELECT idx FROM macs WHERE mac_addr = 'D4BED9EB0CBAA0B91B2B' AND app_code = '051' ========================2020-04-22 10:29:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313387' ========================2020-04-22 10:29:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313387' ========================2020-04-22 10:29:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313387', 'D4BED9EB0CBAA0B91B2B', '051', 'DESKTOP-IM6C3MC', '109', '1920', '1080', 'dyetec', 'DYETEC연구원[조석진]', '429712037749' ) ========================2020-04-22 10:32:15======================== noteurl_start parm_app_code = 051 parm_pc_name = 손용환PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D43591A742B25D46D8 sCDKey = 429712037749 sName = 손용환PC ========================2020-04-22 10:32: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 = '429712037749' AND r.app_code = '051' AND r.app_block = 0 ========================2020-04-22 10:32:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dyetec' ========================2020-04-22 10:32:15======================== SELECT idx FROM macs WHERE mac_addr = '74D43591A742B25D46D8' AND app_code = '051' ========================2020-04-22 10:32:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315955' ========================2020-04-22 10:32:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315955' ========================2020-04-22 10:32:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315955', '74D43591A742B25D46D8', '051', '손용환PC', '109', '1920', '1080', 'dyetec', 'DYETEC연구원[조석진]', '429712037749' ) ========================2020-04-22 16:56:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FE7R8VG parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 2ECCABAC3B12DA9B2A92 sCDKey = 378087224489 sName = DESKTOP-FE7R8VG ========================2020-04-22 16:56: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 = '378087224489' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-22 16:56:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jyounger72' ========================2020-04-22 16:56:13======================== SELECT idx FROM macs WHERE mac_addr = '2ECCABAC3B12DA9B2A92' AND app_code = '039' ========================2020-04-22 16:56:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315928' ========================2020-04-22 16:56:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315928' ========================2020-04-22 16:56:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315928', '2ECCABAC3B12DA9B2A92', '039', 'DESKTOP-FE7R8VG', '110', '2560', '1080', 'jyounger72', 'Easy-M[이제영]', '378087224489' )