========================2021-03-18 10:39:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-AANLVKA parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B07D64DF4B70E0D0C992 sCDKey = 033981272852 sName = DESKTOP-AANLVKA ========================2021-03-18 10:39:58======================== 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 = '033981272852' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-18 10:39:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hankuk92' ========================2021-03-18 10:39:58======================== SELECT idx FROM macs WHERE mac_addr = 'B07D64DF4B70E0D0C992' AND app_code = '039' ========================2021-03-18 10:39:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339163' ========================2021-03-18 10:39:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339163' ========================2021-03-18 10:39:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339163', 'B07D64DF4B70E0D0C992', '039', 'DESKTOP-AANLVKA', '110', '1536', '864', 'hankuk92', '한국안전[한판근]', '033981272852' ) ========================2021-03-18 13:20:26======================== noteurl_start parm_app_code = 039 parm_pc_name = JR-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1831BFCC24249248D3D8 sCDKey = 720212658677 sName = JR-PC ========================2021-03-18 13:20:26======================== 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 = '720212658677' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-18 13:20:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'study80jin' ========================2021-03-18 13:20:27======================== SELECT idx FROM macs WHERE mac_addr = '1831BFCC24249248D3D8' AND app_code = '039' ========================2021-03-18 13:20:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339187' ========================2021-03-18 13:20:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339187' ========================2021-03-18 13:20:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339187', '1831BFCC24249248D3D8', '039', 'JR-PC', '110', '1920', '1080', 'study80jin', '준메디케어[박경숙]', '720212658677' ) ========================2021-03-18 15:13:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-O3SCTTT parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 9822EF9C3E1D2AC74D66 sCDKey = 893776793135 sName = DESKTOP-O3SCTTT ========================2021-03-18 15:13:32======================== 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 = '893776793135' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-18 15:13:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cui190918' ========================2021-03-18 15:13:32======================== SELECT idx FROM macs WHERE mac_addr = '9822EF9C3E1D2AC74D66' AND app_code = '039' ========================2021-03-18 15:13:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339191' ========================2021-03-18 15:13:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339191' ========================2021-03-18 15:13:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339191', '9822EF9C3E1D2AC74D66', '039', 'DESKTOP-O3SCTTT', '110', '1536', '864', 'cui190918', '청명[최상만]', '893776793135' ) ========================2021-03-18 15:26:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BOTRT91 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FCF8AE29FF225860C181 sCDKey = 852701273187 sName = DESKTOP-BOTRT91 ========================2021-03-18 15:26:00======================== 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 = '852701273187' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-18 15:27:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BOTRT91 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FCF8AE29FF225860C181 sCDKey = 852701273187 sName = DESKTOP-BOTRT91 ========================2021-03-18 15:27:45======================== 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 = '852701273187' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-18 15:27:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk40633' ========================2021-03-18 15:27:45======================== SELECT idx FROM macs WHERE mac_addr = 'FCF8AE29FF225860C181' AND app_code = '039' ========================2021-03-18 15:27:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339207' ========================2021-03-18 15:27:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339207' ========================2021-03-18 15:27:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339207', 'FCF8AE29FF225860C181', '039', 'DESKTOP-BOTRT91', '110', '1536', '864', 'kyk40633', '정우테크[김용규]', '852701273187' )