========================2023-12-12 09:00:41======================== noteurl_start parm_app_code = 039 parm_pc_name = 장원빈 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = BC0FF3757173618CD68 sCDKey = 716844806210 sName = 장원빈 ========================2023-12-12 09:00:41======================== 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 = '716844806210' AND r.app_code = '039' AND r.app_block = 0 ========================2023-12-12 09:00:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skglass3465' ========================2023-12-12 09:00:41======================== SELECT idx FROM macs WHERE mac_addr = 'BC0FF3757173618CD68' AND app_code = '039' ========================2023-12-12 09:00:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '397485' ========================2023-12-12 09:00:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '397485' ========================2023-12-12 09:00:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '397485', 'BC0FF3757173618CD68', '039', '장원빈', '110', '1536', '864', 'skglass3465', '(주)성광특수강화유리[장병호]', '716844806210' ) ========================2023-12-12 10:06:12======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-F49SSVRF parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C018034B84424039F489 sCDKey = 850635999712 sName = LAPTOP-F49SSVRF ========================2023-12-12 10:06:12======================== 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 = '850635999712' AND r.app_code = '039' AND r.app_block = 0 ========================2023-12-12 10:06:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'j909600' ========================2023-12-12 10:06:12======================== SELECT idx FROM macs WHERE mac_addr = 'C018034B84424039F489' AND app_code = '039' ========================2023-12-12 10:06:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '397491' ========================2023-12-12 10:06:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '397491' ========================2023-12-12 10:06:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '397491', 'C018034B84424039F489', '039', 'LAPTOP-F49SSVRF', '110', '1536', '864', 'j909600', '한양가스[정을호]', '850635999712' ) ========================2023-12-12 11:27:34======================== noteurl_start parm_app_code = 039 parm_pc_name = YUHAN-1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C6B0037632C44B3FEB5 sCDKey = 676167886789 sName = YUHAN-1 ========================2023-12-12 11:27:34======================== 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 = '676167886789' AND r.app_code = '039' AND r.app_block = 0 ========================2023-12-12 11:27:49======================== noteurl_start parm_app_code = 039 parm_pc_name = YUHAN-1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C6B0037632C44B3FEB5 sCDKey = 676167886789 sName = YUHAN-1 ========================2023-12-12 11:27: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 = '676167886789' AND r.app_code = '039' AND r.app_block = 0 ========================2023-12-12 11:29:57======================== noteurl_start parm_app_code = 039 parm_pc_name = YUHAN-1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C6B0037632C44B3FEB5 sCDKey = 676167886789 sName = YUHAN-1 ========================2023-12-12 11:29:57======================== 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 = '676167886789' AND r.app_code = '039' AND r.app_block = 0 ========================2023-12-12 11:29:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yhthkim' ========================2023-12-12 11:29:57======================== SELECT idx FROM macs WHERE mac_addr = '9C6B0037632C44B3FEB5' AND app_code = '039' ========================2023-12-12 11:29:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '397499' ========================2023-12-12 11:29:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '397499' ========================2023-12-12 11:29:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '397499', '9C6B0037632C44B3FEB5', '039', 'YUHAN-1', '110', '1920', '1080', 'yhthkim', '유한종합유통[김태형]', '676167886789' )