========================2024-12-13 11:29:57======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74563C9B4201789DB938 sCDKey = 769778698282 sName = 태진1 ========================2024-12-13 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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-13 11:29:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-13 11:29:57======================== SELECT idx FROM macs WHERE mac_addr = '74563C9B4201789DB938' AND app_code = '047' ========================2024-12-13 11:29:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414740' ========================2024-12-13 11:29:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414740' ========================2024-12-13 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 ( '414740', '74563C9B4201789DB938', '047', '태진1', '�쐢�룄�슦 10', '0', '0', 'tj0989', '(주)태진산업[조해원]', '769778698282' ) ========================2024-12-13 13:46:43======================== 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 = 50AF73319740EE2B1141 sCDKey = 194336256640 sName = DESKTOP-IR4BE71 ========================2024-12-13 13:46: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 = '194336256640' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-13 13:46:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'md0850' ========================2024-12-13 13:46:43======================== SELECT idx FROM macs WHERE mac_addr = '50AF73319740EE2B1141' AND app_code = '047' ========================2024-12-13 13:46:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414748' ========================2024-12-13 13:46:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414748' ========================2024-12-13 13:46: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 ( '414748', '50AF73319740EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'md0850', '철물 만돌이[이수옥]', '194336256640' ) ========================2024-12-13 13:56:27======================== 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 = 50AF733323F9EE2B1141 sCDKey = 194336256640 sName = DESKTOP-IR4BE71 ========================2024-12-13 13:56:27======================== 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 = '194336256640' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-13 13:56:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'md0850' ========================2024-12-13 13:56:27======================== SELECT idx FROM macs WHERE mac_addr = '50AF733323F9EE2B1141' AND app_code = '047' ========================2024-12-13 13:56:27======================== 값이 없을 경우 ========================2024-12-13 14:00:55======================== 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 = 50AF733323F9EE2B1141 sCDKey = 194336256640 sName = DESKTOP-IR4BE71 ========================2024-12-13 14:00: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 = '194336256640' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-13 14:00:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'md0850' ========================2024-12-13 14:00:55======================== SELECT idx FROM macs WHERE mac_addr = '50AF733323F9EE2B1141' AND app_code = '047' ========================2024-12-13 14:00:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414751' ========================2024-12-13 14:00:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414751' ========================2024-12-13 14:00: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 ( '414751', '50AF733323F9EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'md0850', '철물 만돌이[이수옥]', '194336256640' )