========================2023-06-08 13:32:28======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PO1T7LB parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122CC01087CEE8DAB sCDKey = 278112997938 sName = DESKTOP-PO1T7LB ========================2023-06-08 13:32:28======================== 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 = '278112997938' AND r.app_code = '047' AND r.app_block = 0 ========================2023-06-08 13:32:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ppple1' ========================2023-06-08 13:32:28======================== SELECT idx FROM macs WHERE mac_addr = '581122CC01087CEE8DAB' AND app_code = '047' ========================2023-06-08 13:32:28======================== 값이 없을 경우 ========================2023-06-08 13:34:53======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-PO1T7LB parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122CC01087CEE8DAB sCDKey = 278112997938 sName = DESKTOP-PO1T7LB ========================2023-06-08 13:34:53======================== 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 = '278112997938' AND r.app_code = '047' AND r.app_block = 0 ========================2023-06-08 13:34:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ppple1' ========================2023-06-08 13:34:53======================== SELECT idx FROM macs WHERE mac_addr = '581122CC01087CEE8DAB' AND app_code = '047' ========================2023-06-08 13:34:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '388875' ========================2023-06-08 13:34:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '388875' ========================2023-06-08 13:34:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '388875', '581122CC01087CEE8DAB', '047', 'DESKTOP-PO1T7LB', '�쐢�룄�슦 10', '0', '0', 'ppple1', '영기수산[박영기]', '278112997938' ) ========================2023-06-08 17:13:17======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-859DPZ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30CFC469686C6835 sCDKey = 360238283345 sName = DESKTOP-859DPZ ========================2023-06-08 17:13:17======================== 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 = '360238283345' AND r.app_code = '045' AND r.app_block = 0 ========================2023-06-08 17:13:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'efus1009' ========================2023-06-08 17:13:17======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30CFC469686C6835' AND app_code = '045' ========================2023-06-08 17:13:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '388902' ========================2023-06-08 17:13:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '388902' ========================2023-06-08 17:13:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '388902', 'F44D30CFC469686C6835', '045', 'DESKTOP-859DPZ', '110', '1920', '1080', 'efus1009', '주식회사 이퍼스[주식회사 이퍼스]', '360238283345' ) ========================2023-06-08 17:28:05======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-4C9PU2U parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30CFC486686C6835 sCDKey = 360238283345 sName = DESKTOP-4C9PU2U ========================2023-06-08 17:28:05======================== 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 = '360238283345' AND r.app_code = '045' AND r.app_block = 0 ========================2023-06-08 17:28:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'efus1009' ========================2023-06-08 17:28:05======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30CFC486686C6835' AND app_code = '045' ========================2023-06-08 17:28:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '388903' ========================2023-06-08 17:28:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '388903' ========================2023-06-08 17:28:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '388903', 'F44D30CFC486686C6835', '045', 'DESKTOP-4C9PU2U', '110', '1920', '1080', 'efus1009', '주식회사 이퍼스[주식회사 이퍼스]', '360238283345' )