========================2020-04-02 09:08:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-P1T2M53 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 7085C27B3F1C7C99C535 sCDKey = 760170211075 sName = DESKTOP-P1T2M53 ========================2020-04-02 09:08:03======================== 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 = '760170211075' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-02 09:08:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kunok1' ========================2020-04-02 09:08:03======================== SELECT idx FROM macs WHERE mac_addr = '7085C27B3F1C7C99C535' AND app_code = '039' ========================2020-04-02 09:08:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314509' ========================2020-04-02 09:08:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314509' ========================2020-04-02 09:08:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314509', '7085C27B3F1C7C99C535', '039', 'DESKTOP-P1T2M53', '110', '2560', '1080', 'kunok1', '근옥테크[고상수]', '760170211075' ) ========================2020-04-02 09:48:42======================== noteurl_start parm_app_code = 046 parm_pc_name = CSPUMP-1811-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 78F29E90D67DC8DE7DEE sCDKey = 975677425073 sName = CSPUMP-1811-PC ========================2020-04-02 09:48:42======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-02 09:48:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2020-04-02 09:48:42======================== SELECT idx FROM macs WHERE mac_addr = '78F29E90D67DC8DE7DEE' AND app_code = '046' ========================2020-04-02 09:48:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314513' ========================2020-04-02 09:48:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314513' ========================2020-04-02 09:48:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314513', '78F29E90D67DC8DE7DEE', '046', 'CSPUMP-1811-PC', '90', '1024', '768', 'ami2881', '아미상사[이재훈]', '975677425073' ) ========================2020-04-02 09:56:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KLO5UJH parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 5800E3CD92655650DE9F sCDKey = 714618525075 sName = DESKTOP-KLO5UJH ========================2020-04-02 09:56: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 = '714618525075' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-02 10:21:30======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MACM5LGDO3J parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E063318A0542139329 sCDKey = 375508873226 sName = WIN-MACM5LGDO3J ========================2020-04-02 10:21:30======================== 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 = '375508873226' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-02 10:21:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wdjs86101' ========================2020-04-02 10:21:31======================== SELECT idx FROM macs WHERE mac_addr = '00E063318A0542139329' AND app_code = '039' ========================2020-04-02 10:21:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291139' ========================2020-04-02 10:21:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291139' ========================2020-04-02 10:21:31======================== UPDATE mac_detail SET pc_name = 'WIN-MACM5LGDO3J', os_type = '90', user_id = 'wdjs86101', user_name = '월드장식[탁경숙]', screen_w = '1920', screen_h = '1080', cdkey = '375508873226' WHERE mac_idx = '291139' ========================2020-04-02 10:54:25======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-G5QR05P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A85E45B5DE14CCF6E5A9 sCDKey = 866364297135 sName = DESKTOP-G5QR05P ========================2020-04-02 10:54:25======================== 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 = '866364297135' AND r.app_code = '047' AND r.app_block = 0 ========================2020-04-02 10:54:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc3013' ========================2020-04-02 10:54:25======================== SELECT idx FROM macs WHERE mac_addr = 'A85E45B5DE14CCF6E5A9' AND app_code = '047' ========================2020-04-02 10:54:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314520' ========================2020-04-02 10:54:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314520' ========================2020-04-02 10:54:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314520', 'A85E45B5DE14CCF6E5A9', '047', 'DESKTOP-G5QR05P', '�쐢�룄�슦 10', '0', '0', 'blc3013', '구월1동성당[구월1동성당]', '866364297135' ) ========================2020-04-02 13:08:15======================== noteurl_start parm_app_code = 039 parm_pc_name = KIM-PC parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = D0509953E48F80325AE sCDKey = 020243409774 sName = KIM-PC ========================2020-04-02 13:08: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 = '020243409774' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-02 13:08:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumku' ========================2020-04-02 13:08:15======================== SELECT idx FROM macs WHERE mac_addr = 'D0509953E48F80325AE' AND app_code = '039' ========================2020-04-02 13:08:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314246' ========================2020-04-02 13:08:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314246' ========================2020-04-02 13:08:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314246', 'D0509953E48F80325AE', '039', 'KIM-PC', '110', '1360', '768', 'kumku', '(주)금구[(주)금구]', '020243409774' )