========================2023-05-12 10:15:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0V9N0LG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = C87F54C3BE6DDC042F38 sCDKey = 487546950548 sName = DESKTOP-0V9N0LG ========================2023-05-12 10:15:13======================== 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 = '487546950548' AND r.app_code = '039' AND r.app_block = 0 ========================2023-05-12 10:15:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kbel21' ========================2023-05-12 10:15:13======================== SELECT idx FROM macs WHERE mac_addr = 'C87F54C3BE6DDC042F38' AND app_code = '039' ========================2023-05-12 10:15:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387684' ========================2023-05-12 10:15:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '387684' ========================2023-05-12 10:15:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '387684', 'C87F54C3BE6DDC042F38', '039', 'DESKTOP-0V9N0LG', '110', '1600', '900', 'kbel21', '(주)금보엘리베이터[(주)금보엘리베이터]', '487546950548' ) ========================2023-05-12 13:24:36======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-UA5BNDS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E1A8F2B5CFFDF5F sCDKey = 029378936382 sName = DESKTOP-UA5BNDS ========================2023-05-12 13:24:36======================== 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 = '029378936382' AND r.app_code = '047' AND r.app_block = 0 ========================2023-05-12 13:24:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'carrymore' ========================2023-05-12 13:24:36======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E1A8F2B5CFFDF5F' AND app_code = '047' ========================2023-05-12 13:24:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387700' ========================2023-05-12 13:24:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '387700' ========================2023-05-12 13:24:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '387700', 'E0D55E1A8F2B5CFFDF5F', '047', 'DESKTOP-UA5BNDS', '�쐢�룄�슦 10', '0', '0', 'carrymore', '캐리모어(CARRYMORE)[김휘종]', '029378936382' ) ========================2023-05-12 17:13:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-256GJ7V parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00012E537A89926B4A4B sCDKey = 436230153290 sName = DESKTOP-256GJ7V ========================2023-05-12 17:13:24======================== 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 = '436230153290' AND r.app_code = '039' AND r.app_block = 0 ========================2023-05-12 17:13:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ohk6670' ========================2023-05-12 17:13:24======================== SELECT idx FROM macs WHERE mac_addr = '00012E537A89926B4A4B' AND app_code = '039' ========================2023-05-12 17:13:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '387725' ========================2023-05-12 17:13:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '387725' ========================2023-05-12 17:13:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '387725', '00012E537A89926B4A4B', '039', 'DESKTOP-256GJ7V', '110', '1600', '900', 'ohk6670', '[오현근]', '436230153290' ) ========================2023-05-12 17:53:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VRLJB0E parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D02788E54AE694BDA248 sCDKey = 707754695109 sName = DESKTOP-VRLJB0E ========================2023-05-12 17:53: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 = '707754695109' AND r.app_code = '039' AND r.app_block = 0 ========================2023-05-12 17:53:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'asd1234' ========================2023-05-12 17:53:55======================== SELECT idx FROM macs WHERE mac_addr = 'D02788E54AE694BDA248' AND app_code = '039' ========================2023-05-12 17:53:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '386806' ========================2023-05-12 17:53:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '386806' ========================2023-05-12 17:53: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 ( '386806', 'D02788E54AE694BDA248', '039', 'DESKTOP-VRLJB0E', '110', '1920', '1080', 'asd1234', '다누리건축철물[전창흥]', '707754695109' )