========================2021-10-28 09:59:41======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-S0AD23J parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 646E69B9A4692C4DD9E6 sCDKey = 226231526622 sName = DESKTOP-S0AD23J ========================2021-10-28 09:59:41======================== 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 = '226231526622' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 09:59:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daumsoft' ========================2021-10-28 09:59:42======================== SELECT idx FROM macs WHERE mac_addr = '646E69B9A4692C4DD9E6' AND app_code = '050' ========================2021-10-28 09:59:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353489' ========================2021-10-28 09:59:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353489' ========================2021-10-28 09:59: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 ( '353489', '646E69B9A4692C4DD9E6', '050', 'DESKTOP-S0AD23J', '109', '1536', '864', 'daumsoft', '다음소프트[다음소프트]', '226231526622' ) ========================2021-10-28 09:59:46======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-0NF5130 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A85E45B4A7B158E8599E sCDKey = 950428290210 sName = DESKTOP-0NF5130 ========================2021-10-28 09:59:46======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 09:59:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 09:59:46======================== SELECT idx FROM macs WHERE mac_addr = 'A85E45B4A7B158E8599E' AND app_code = '050' ========================2021-10-28 09:59:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353488' ========================2021-10-28 09:59:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353488' ========================2021-10-28 09:59:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353488', 'A85E45B4A7B158E8599E', '050', 'DESKTOP-0NF5130', '109', '1920', '1080', 'jinsung1', '진성이엔지[김형민]', '950428290210' ) ========================2021-10-28 10:19:18======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 3CA067D6697160EC6108 sCDKey = 950428290210 sName = DESKTOP-16H89QL ========================2021-10-28 10:19:18======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:19:45======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 3CA067D6697160EC6108 sCDKey = 708128512512 sName = DESKTOP-16H89QL ========================2021-10-28 10:19:45======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:20:04======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 3CA067D6697160EC6108 sCDKey = 708128512512 sName = DESKTOP-16H89QL ========================2021-10-28 10:20:04======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:20:46======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 3CA067D6697160EC6108 sCDKey = 950428290210 sName = DESKTOP-16H89QL ========================2021-10-28 10:20:46======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:35:18======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-BSRF5PL parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2C4D54D8DAA856E047CB sCDKey = 708128512512 sName = DESKTOP-BSRF5PL ========================2021-10-28 10:35:18======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:53:55======================== noteurl_start parm_app_code = 050 parm_pc_name = ANDREW parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E04A6A55F6E8AFD2C8 sCDKey = 226231526622 sName = ANDREW ========================2021-10-28 10: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 = '226231526622' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:56:07======================== noteurl_start parm_app_code = 050 parm_pc_name = ANDREW parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E04A6A55F6E8AFD2C8 sCDKey = 226231526622 sName = ANDREW ========================2021-10-28 10:56:07======================== 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 = '226231526622' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:56:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daumsoft' ========================2021-10-28 10:56:07======================== SELECT idx FROM macs WHERE mac_addr = '00E04A6A55F6E8AFD2C8' AND app_code = '050' ========================2021-10-28 10:56:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '335743' ========================2021-10-28 10:56:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '335743' ========================2021-10-28 10:56:07======================== UPDATE mac_detail SET pc_name = 'ANDREW', os_type = '109', user_id = 'daumsoft', user_name = '다음소프트[다음소프트]', screen_w = '1920', screen_h = '1080', cdkey = '226231526622' WHERE mac_idx = '335743' ========================2021-10-28 10:57:35======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-S0AD23J parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 646E69B9A4692C4DD9E6 sCDKey = 226231526622 sName = DESKTOP-S0AD23J ========================2021-10-28 10:57:35======================== 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 = '226231526622' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 10:57:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daumsoft' ========================2021-10-28 10:57:35======================== SELECT idx FROM macs WHERE mac_addr = '646E69B9A4692C4DD9E6' AND app_code = '050' ========================2021-10-28 10:57:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353489' ========================2021-10-28 10:57:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353489' ========================2021-10-28 10:57:35======================== UPDATE mac_detail SET pc_name = 'DESKTOP-S0AD23J', os_type = '109', user_id = 'daumsoft', user_name = '다음소프트[다음소프트]', screen_w = '1536', screen_h = '864', cdkey = '226231526622' WHERE mac_idx = '353489' ========================2021-10-28 11:05:52======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-CQNOS7D parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E3BF2BC434A03E sCDKey = 468519436834 sName = DESKTOP-CQNOS7D ========================2021-10-28 11:05:52======================== 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 = '468519436834' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 11:07:22======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-CQNOS7D parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E3BF2BC434A03E sCDKey = 468519436834 sName = DESKTOP-CQNOS7D ========================2021-10-28 11:07:22======================== 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 = '468519436834' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 11:07:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'scmlife' ========================2021-10-28 11:07:22======================== SELECT idx FROM macs WHERE mac_addr = '309C23E3BF2BC434A03E' AND app_code = '050' ========================2021-10-28 11:07:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324266' ========================2021-10-28 11:07:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324266' ========================2021-10-28 11:07:22======================== UPDATE mac_detail SET pc_name = 'DESKTOP-CQNOS7D', os_type = '109', user_id = 'scmlife', user_name = '에스씨엠생명과학[김다함]', screen_w = '1920', screen_h = '1080', cdkey = '468519436834' WHERE mac_idx = '324266' ========================2021-10-28 14:40:16======================== 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 = B88687D8C89074258B30 sCDKey = 892232246788 sName = DALLAITI ========================2021-10-28 14:40:16======================== 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 ========================2021-10-28 14:40:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumnam' ========================2021-10-28 14:40:16======================== SELECT idx FROM macs WHERE mac_addr = 'B88687D8C89074258B30' AND app_code = '046' ========================2021-10-28 14:40:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '230508' ========================2021-10-28 14:40:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '230508' ========================2021-10-28 14:40:16======================== 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 = '230508' ========================2021-10-28 15:24:09======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME-W10 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D0509966D6F9A0C7B67C sCDKey = 363792448074 sName = HOME-W10 ========================2021-10-28 15:24:09======================== 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 = '363792448074' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-28 15:24:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ysengpark' ========================2021-10-28 15:24:09======================== SELECT idx FROM macs WHERE mac_addr = 'D0509966D6F9A0C7B67C' AND app_code = '039' ========================2021-10-28 15:24:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353521' ========================2021-10-28 15:24:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353521' ========================2021-10-28 15:24:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353521', 'D0509966D6F9A0C7B67C', '039', 'HOME-W10', '110', '1680', '1050', 'ysengpark', '유성기계[김용석]', '363792448074' ) ========================2021-10-28 16:42:53======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 950428290210 sName = DESKTOP-16H89QL ========================2021-10-28 16:42: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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 16:42:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 16:42:53======================== SELECT idx FROM macs WHERE mac_addr = 'A81E84321F3B60EC6108' AND app_code = '050' ========================2021-10-28 16:42:53======================== 값이 없을 경우 ========================2021-10-28 16:43:54======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 950428290210 sName = DESKTOP-16H89QL ========================2021-10-28 16:43:54======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 16:43:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 16:43:54======================== SELECT idx FROM macs WHERE mac_addr = 'A81E84321F3B60EC6108' AND app_code = '050' ========================2021-10-28 16:43:54======================== 값이 없을 경우 ========================2021-10-28 16:54:05======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 950428290210 sName = USER ========================2021-10-28 16:54: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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 16:54:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 16:54:05======================== SELECT idx FROM macs WHERE mac_addr = 'A81E84321F3B60EC6108' AND app_code = '050' ========================2021-10-28 16:54:05======================== 값이 없을 경우 ========================2021-10-28 16:54:26======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 950428290210 sName = USER ========================2021-10-28 16:54: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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 16:54:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 16:54:26======================== SELECT idx FROM macs WHERE mac_addr = 'A81E84321F3B60EC6108' AND app_code = '050' ========================2021-10-28 16:54:26======================== 값이 없을 경우 ========================2021-10-28 16:55:12======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 950428290210 sName = DESKTOP-16H89QL ========================2021-10-28 16:55:12======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 16:55:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 16:55:12======================== SELECT idx FROM macs WHERE mac_addr = 'A81E84321F3B60EC6108' AND app_code = '050' ========================2021-10-28 16:55:12======================== 값이 없을 경우 ========================2021-10-28 17:11:28======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 708128512512 sName = DESKTOP-16H89QL ========================2021-10-28 17:11: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 17:15:01======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-16H89QL parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A81E84321F3B60EC6108 sCDKey = 950428290210 sName = DESKTOP-16H89QL ========================2021-10-28 17:15:01======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-10-28 17:15:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung1' ========================2021-10-28 17:15:01======================== SELECT idx FROM macs WHERE mac_addr = 'A81E84321F3B60EC6108' AND app_code = '050' ========================2021-10-28 17:15:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353542' ========================2021-10-28 17:15:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353542' ========================2021-10-28 17:15:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353542', 'A81E84321F3B60EC6108', '050', 'DESKTOP-16H89QL', '109', '1920', '1080', 'jinsung1', '진성이엔지[김형민]', '950428290210' )