========================2020-06-16 13:36:15======================== noteurl_start parm_app_code = 046 parm_pc_name = DALLAITI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE5B65174258B30 sCDKey = 892232246788 sName = DALLAITI ========================2020-06-16 13:36:15======================== 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 = '892232246788' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-16 13:36:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumnam' ========================2020-06-16 13:36:15======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE5B65174258B30' AND app_code = '046' ========================2020-06-16 13:36:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '160264' ========================2020-06-16 13:36:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '160264' ========================2020-06-16 13:36:15======================== UPDATE mac_detail SET pc_name = 'DALLAITI', os_type = '110', user_id = 'kumnam', user_name = '(주)금남[한진용]', screen_w = '1920', screen_h = '1080', cdkey = '892232246788' WHERE mac_idx = '160264' ========================2020-06-16 16:16:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73338C66EE2B1141 sCDKey = 957349623098 sName = DESKTOP-IR4BE71 ========================2020-06-16 16:16:23======================== 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 = '957349623098' AND r.app_code = '047' AND r.app_block = 0 ========================2020-06-16 16:16:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dsrhs2002' ========================2020-06-16 16:16:23======================== SELECT idx FROM macs WHERE mac_addr = '50AF73338C66EE2B1141' AND app_code = '047' ========================2020-06-16 16:16:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319822' ========================2020-06-16 16:16:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319822' ========================2020-06-16 16:16:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319822', '50AF73338C66EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'dsrhs2002', '(주)동산안전산업자재[나원국]', '957349623098' ) ========================2020-06-16 17:02:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-D6G94K3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 80193478D147662B98B5 sCDKey = 492422317028 sName = DESKTOP-D6G94K3 ========================2020-06-16 17:02: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 = '492422317028' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-16 17:02:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nonono4615' ========================2020-06-16 17:02:43======================== SELECT idx FROM macs WHERE mac_addr = '80193478D147662B98B5' AND app_code = '039' ========================2020-06-16 17:02:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319823' ========================2020-06-16 17:02:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319823' ========================2020-06-16 17:02: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 ( '319823', '80193478D147662B98B5', '039', 'DESKTOP-D6G94K3', '110', '1366', '768', 'nonono4615', '정진케미코[정혜민]', '492422317028' ) ========================2020-06-16 17:41:26======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-S9AD0PFGHLI parm_os_type = 90 parm_screen_w = 1152 parm_screen_h = 864 parm_user_mac = 0024549000C6B0836A8C sCDKey = 523982830539 sName = WIN-S9AD0PFGHLI ========================2020-06-16 17:41: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 = '523982830539' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-16 17:41:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyungilsa01' ========================2020-06-16 17:41:26======================== SELECT idx FROM macs WHERE mac_addr = '0024549000C6B0836A8C' AND app_code = '039' ========================2020-06-16 17:41:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264893' ========================2020-06-16 17:41:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264893' ========================2020-06-16 17:41:26======================== UPDATE mac_detail SET pc_name = 'WIN-S9AD0PFGHLI', os_type = '90', user_id = 'kyungilsa01', user_name = '경일인쇄사[김항복]', screen_w = '1152', screen_h = '864', cdkey = '523982830539' WHERE mac_idx = '264893'