========================2018-02-19 09:06:55======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 819586585061 sName = 한지수 ========================2018-02-19 09:06: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 = '819586585061' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-19 09:06:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjs1' ========================2018-02-19 09:06:55======================== SELECT idx FROM macs WHERE mac_addr = '6C626D5D391AAE81FA52' AND app_code = '039' ========================2018-02-19 09:06:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240657' ========================2018-02-19 09:06:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240657' ========================2018-02-19 09:06: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 ( '240657', '6C626D5D391AAE81FA52', '039', '한지수', '110', '1680', '1050', 'hjs1', '엠제이소프트[한지수]', '819586585061' ) ========================2018-02-19 14:07:18======================== noteurl_start parm_app_code = 039 parm_pc_name = Sc-201802181353 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC58EEC87181B42DB sCDKey = 460983226381 sName = Sc-201802181353 ========================2018-02-19 14:07: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 = '460983226381' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-19 14:07:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'son1130' ========================2018-02-19 14:07:18======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC58EEC87181B42DB' AND app_code = '039' ========================2018-02-19 14:07:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '215452' ========================2018-02-19 14:07:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '215452' ========================2018-02-19 14:07:18======================== UPDATE mac_detail SET pc_name = 'Sc-201802181353', os_type = '90', user_id = 'son1130', user_name = '스타정보통신[손현숙]', screen_w = '1920', screen_h = '1080', cdkey = '460983226381' WHERE mac_idx = '215452' ========================2018-02-19 16:39:33======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 0C8BFDF6456E7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-02-19 16:39:33======================== 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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-19 16:39:51======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 0C8BFDF6456E7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-02-19 16:39: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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-19 16:42:07======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 0C8BFDF6456E7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-02-19 16:42: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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-19 16:42:49======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 0C8BFDF6456E7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-02-19 16:42:49======================== 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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-19 16:42:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'withusptns' ========================2018-02-19 16:42:49======================== SELECT idx FROM macs WHERE mac_addr = '0C8BFDF6456E7A03CF15' AND app_code = '039' ========================2018-02-19 16:42:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '215175' ========================2018-02-19 16:42:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '215175' ========================2018-02-19 16:42:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '215175', '0C8BFDF6456E7A03CF15', '039', 'HP', '110', '1536', '864', 'withusptns', '위더스파트너스주식회사[노현국]', '587810805864' ) ========================2018-02-19 16:43:07======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 0C8BFDF6456E7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-02-19 16:43: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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0