========================2019-02-12 10:12:47======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T9VJOTGC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F2B0150C2935A58 sCDKey = 903583545456 sName = LAPTOP-T9VJOTGC ========================2019-02-12 10:12:47======================== 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 = '903583545456' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-12 10:12:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyj418' ========================2019-02-12 10:12:47======================== SELECT idx FROM macs WHERE mac_addr = '702C1F2B0150C2935A58' AND app_code = '039' ========================2019-02-12 10:12:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275831' ========================2019-02-12 10:12:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275831' ========================2019-02-12 10:12:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275831', '702C1F2B0150C2935A58', '039', 'LAPTOP-T9VJOTGC', '110', '1366', '768', 'kyj418', '미양수산[김영진]', '903583545456' ) ========================2019-02-12 10:12:58======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T9VJOTGC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F2B0150C2935A58 sCDKey = 903583545456 sName = LAPTOP-T9VJOTGC ========================2019-02-12 10:12: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 = '903583545456' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-12 11:34:44======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AEB484D942362F3 sCDKey = 448194486995 sName = ADMINISTRATOR ========================2019-02-12 11:34: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 = '448194486995' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-12 11:34:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lfk0011' ========================2019-02-12 11:34:44======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AEB484D942362F3' AND app_code = '046' ========================2019-02-12 11:34:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276861' ========================2019-02-12 11:34:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276861' ========================2019-02-12 11:34:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276861', 'B8975AEB484D942362F3', '046', 'ADMINISTRATOR', '90', '1024', '768', 'lfk0011', '(주)라이프코리아[김상운]', '448194486995' ) ========================2019-02-12 16:19:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-191 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = F44D30BC80368EC04F30 sCDKey = 029916777495 sName = DESKTOP-191 ========================2019-02-12 16:19:22======================== 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 = '029916777495' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-12 16:21:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-191 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = F44D30BC80368EC04F30 sCDKey = 029916777495 sName = DESKTOP-191 ========================2019-02-12 16:21:16======================== 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 = '029916777495' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-12 16:21:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mmshkim' ========================2019-02-12 16:21:16======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC80368EC04F30' AND app_code = '039' ========================2019-02-12 16:21:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275085' ========================2019-02-12 16:21:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275085' ========================2019-02-12 16:21:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275085', 'F44D30BC80368EC04F30', '039', 'DESKTOP-191', '110', '1680', '1050', 'mmshkim', '(주)금호에이앤디[김문겸]', '029916777495' )