========================2019-12-27 07:28:14======================== noteurl_start parm_app_code = 048 parm_pc_name = 2F1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 181DEA744974D87CAEF4 sCDKey = 434133617514 sName = 2F1 ========================2019-12-27 07:28:14======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-12-27 09:40:50======================== noteurl_start parm_app_code = 047 parm_pc_name = SDH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F4B52017918E1C4E35F8 sCDKey = 231851322592 sName = SDH ========================2019-12-27 09:40: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 = '231851322592' AND r.app_code = '047' AND r.app_block = 0 ========================2019-12-27 09:40:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2019-12-27 09:40:50======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52017918E1C4E35F8' AND app_code = '047' ========================2019-12-27 09:40:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306413' ========================2019-12-27 09:40:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306413' ========================2019-12-27 09:40: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 ( '306413', 'F4B52017918E1C4E35F8', '047', 'SDH', '�쐢�룄�슦 10', '0', '0', 'hak79', '[이봉학1]', '231851322592' ) ========================2019-12-27 10:13:06======================== noteurl_start parm_app_code = 046 parm_pc_name = 이주임 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E840F2FDA5C62E40B8E5 sCDKey = 377477337766 sName = 이주임 ========================2019-12-27 10:13: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 = '377477337766' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-27 12:49:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = CCB0DA25847922360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-12-27 12:49:44======================== 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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-27 12:50:27======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0JEK6G3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = CCB0DA25847922360AE8 sCDKey = 748873380621 sName = DESKTOP-0JEK6G3 ========================2019-12-27 12:50: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 = '748873380621' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-27 12:50:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs396' ========================2019-12-27 12:50:28======================== SELECT idx FROM macs WHERE mac_addr = 'CCB0DA25847922360AE8' AND app_code = '039' ========================2019-12-27 12:50:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '207747' ========================2019-12-27 12:50:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '207747' ========================2019-12-27 12:50:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-0JEK6G3', os_type = '110', user_id = 'bs396', user_name = '거흥중기[이윤복]', screen_w = '1366', screen_h = '768', cdkey = '748873380621' WHERE mac_idx = '207747' ========================2019-12-27 14:36:05======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HKD864B parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 503EAAACB7F4CA0A81B sCDKey = 396428663639 sName = DESKTOP-HKD864B ========================2019-12-27 14:36:05======================== 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 = '396428663639' AND r.app_code = '046' AND r.app_block = 0 ========================2019-12-27 14:36:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eric2030' ========================2019-12-27 14:36:05======================== SELECT idx FROM macs WHERE mac_addr = '503EAAACB7F4CA0A81B' AND app_code = '046' ========================2019-12-27 14:36:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306448' ========================2019-12-27 14:36:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306448' ========================2019-12-27 14:36:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '306448', '503EAAACB7F4CA0A81B', '046', 'DESKTOP-HKD864B', '110', '1920', '1080', 'eric2030', '호일컴퍼니[정영우]', '396428663639' ) ========================2019-12-27 17:08:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-P1VQ764 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A85E4514622380000FE6 sCDKey = 393153152776 sName = DESKTOP-P1VQ764 ========================2019-12-27 17:08: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 = '393153152776' AND r.app_code = '039' AND r.app_block = 0 ========================2019-12-27 17:08:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhee8933' ========================2019-12-27 17:08:37======================== SELECT idx FROM macs WHERE mac_addr = 'A85E4514622380000FE6' AND app_code = '039' ========================2019-12-27 17:08:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306473' ========================2019-12-27 17:08:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306473' ========================2019-12-27 17:08: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 ( '306473', 'A85E4514622380000FE6', '039', 'DESKTOP-P1VQ764', '110', '1920', '1080', 'jhee8933', '씨엔씨(C&C)[심영주]', '393153152776' )