========================2021-03-31 16:29:35======================== noteurl_start parm_app_code = 050 parm_pc_name = 김은경 parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 4CCC6A976C75AA5FC018 sCDKey = 126618681151 sName = Capefn ========================2021-03-31 16:29:35======================== 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 = '126618681151' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 16:29:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'capefn' ========================2021-03-31 16:29:35======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A976C75AA5FC018' AND app_code = '050' ========================2021-03-31 16:29:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340101' ========================2021-03-31 16:29:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340101' ========================2021-03-31 16:29:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340101', '4CCC6A976C75AA5FC018', '050', 'Capefn', '109', '1680', '1050', 'capefn', '케이프투자증권[김은경]', '126618681151' ) ========================2021-03-31 17:05:43======================== noteurl_start parm_app_code = 050 parm_pc_name = 김은경 parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 4CCC6A976C75AA5FC018 sCDKey = 126618681151 sName = 케이프투자증권 ========================2021-03-31 17:05: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 = '126618681151' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 17:06:38======================== noteurl_start parm_app_code = 050 parm_pc_name = 김은경 parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 4CCC6A976C75AA5FC018 sCDKey = 126618681151 sName = 케이프투자증권 ========================2021-03-31 17:06:38======================== 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 = '126618681151' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 17:08:25======================== noteurl_start parm_app_code = 050 parm_pc_name = WANSOON0331 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11CB6638856 sCDKey = 571544737699 sName = WANSOON0331 ========================2021-03-31 17:08: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 17:09:13======================== noteurl_start parm_app_code = 050 parm_pc_name = WANSOON0331 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11CB6638856 sCDKey = 571544737699 sName = WANSOON0331 ========================2021-03-31 17:09: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 17:09:56======================== noteurl_start parm_app_code = 050 parm_pc_name = WANSOON0331 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0C5899AC11CB6638856 sCDKey = 571544737699 sName = WANSOON0331 ========================2021-03-31 17:09: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 = '571544737699' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 17:09:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hancomm' ========================2021-03-31 17:09:56======================== SELECT idx FROM macs WHERE mac_addr = 'A0C5899AC11CB6638856' AND app_code = '050' ========================2021-03-31 17:09:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340108' ========================2021-03-31 17:09:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340108' ========================2021-03-31 17:09: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 ( '340108', 'A0C5899AC11CB6638856', '050', 'WANSOON0331', '109', '1920', '1080', 'hancomm', '한컴[이수진]', '571544737699' ) ========================2021-03-31 17:23:55======================== noteurl_start ========================2021-03-31 17:23: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 = '' AND r.app_code = '' AND r.app_block = 0 ========================2021-03-31 17:28:21======================== noteurl_start parm_app_code = 050 parm_pc_name = 김은경 parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 4CCC6A976C75AA5FC018 sCDKey = 126618681151 sName = 김은경 ========================2021-03-31 17:28:21======================== 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 = '126618681151' AND r.app_code = '050' AND r.app_block = 0 ========================2021-03-31 17:53:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QK5TBM4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30C864F6CA736D09 sCDKey = 486979247325 sName = DESKTOP-QK5TBM4 ========================2021-03-31 17:53: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 = '486979247325' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-31 17:53:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjy6384' ========================2021-03-31 17:53:43======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30C864F6CA736D09' AND app_code = '039' ========================2021-03-31 17:53:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340123' ========================2021-03-31 17:53:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340123' ========================2021-03-31 17:53: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 ( '340123', 'F44D30C864F6CA736D09', '039', 'DESKTOP-QK5TBM4', '110', '1920', '1080', 'kjy6384', '니드인테리어[김미진]', '486979247325' )