========================2020-06-08 09:48:05======================== noteurl_start parm_app_code = 048 parm_pc_name = 얼마예요 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D22F1ADD18FA2D0 sCDKey = 780547338320 sName = 얼마예요 ========================2020-06-08 09:48: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-08 09:48:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-06-08 09:48:05======================== SELECT idx FROM macs WHERE mac_addr = '18C04D22F1ADD18FA2D0' AND app_code = '048' ========================2020-06-08 09:48:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319230' ========================2020-06-08 09:48:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319230' ========================2020-06-08 09:48: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 ( '319230', '18C04D22F1ADD18FA2D0', '048', '얼마예요', '�쐢�룄�슦 10', '0', '0', 'aone0022', '(주)에이원메디칼[강창중]', '780547338320' ) ========================2020-06-08 09:50:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-UB72EP3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509974A307C25D4CCE sCDKey = 698296768630 sName = DESKTOP-UB72EP3 ========================2020-06-08 09:50:58======================== 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 = '698296768630' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 09:50:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xjwlsenqn' ========================2020-06-08 09:50:58======================== SELECT idx FROM macs WHERE mac_addr = 'D0509974A307C25D4CCE' AND app_code = '046' ========================2020-06-08 09:50:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319191' ========================2020-06-08 09:50:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319191' ========================2020-06-08 09:50:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319191', 'D0509974A307C25D4CCE', '046', 'DESKTOP-UB72EP3', '110', '1920', '1080', 'xjwlsenqn', '펫하우스[박성환]', '698296768630' ) ========================2020-06-08 09:52:19======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-UB72EP3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509974A307C25D4CCE sCDKey = 698296768630 sName = 펫하우스가좌 ========================2020-06-08 09:52:19======================== 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 = '698296768630' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 09:52:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xjwlsenqn' ========================2020-06-08 09:52:20======================== SELECT idx FROM macs WHERE mac_addr = 'D0509974A307C25D4CCE' AND app_code = '046' ========================2020-06-08 09:52:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319191' ========================2020-06-08 09:52:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319191' ========================2020-06-08 09:52:20======================== UPDATE mac_detail SET pc_name = '펫하우스가좌', os_type = '110', user_id = 'xjwlsenqn', user_name = '펫하우스[박성환]', screen_w = '1920', screen_h = '1080', cdkey = '698296768630' WHERE mac_idx = '319191' ========================2020-06-08 09:54:37======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HPFTTFS parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 705DCCF051B4A68259A2 sCDKey = 721130173697 sName = DESKTOP-HPFTTFS ========================2020-06-08 09:54:37======================== 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 = '721130173697' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 09:54:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samwon6440' ========================2020-06-08 09:54:37======================== SELECT idx FROM macs WHERE mac_addr = '705DCCF051B4A68259A2' AND app_code = '046' ========================2020-06-08 09:54:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319232' ========================2020-06-08 09:54:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319232' ========================2020-06-08 09:54:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319232', '705DCCF051B4A68259A2', '046', 'DESKTOP-HPFTTFS', '110', '1680', '1050', 'samwon6440', '삼원유통[박범진]', '721130173697' ) ========================2020-06-08 10:37:59======================== noteurl_start parm_app_code = 046 parm_pc_name = PETHOUSE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C22937816E43E360 sCDKey = 698296768630 sName = 펫하우스옥련 ========================2020-06-08 10:37:59======================== 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 = '698296768630' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 10:37:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xjwlsenqn' ========================2020-06-08 10:37:59======================== SELECT idx FROM macs WHERE mac_addr = '7085C22937816E43E360' AND app_code = '046' ========================2020-06-08 10:37:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '209084' ========================2020-06-08 10:37:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '209084' ========================2020-06-08 10:37:59======================== UPDATE mac_detail SET pc_name = '펫하우스옥련', os_type = '110', user_id = 'xjwlsenqn', user_name = '펫하우스[박성환]', screen_w = '1920', screen_h = '1080', cdkey = '698296768630' WHERE mac_idx = '209084' ========================2020-06-08 11:36:28======================== noteurl_start parm_app_code = 045 parm_pc_name = PC2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B5202016FFFC73883F sCDKey = 524753985227 sName = PC2 ========================2020-06-08 11:36: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 = '524753985227' AND r.app_code = '045' AND r.app_block = 0 ========================2020-06-08 11:36:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kds1' ========================2020-06-08 11:36:28======================== SELECT idx FROM macs WHERE mac_addr = 'F4B5202016FFFC73883F' AND app_code = '045' ========================2020-06-08 11:36:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319247' ========================2020-06-08 11:36:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319247' ========================2020-06-08 11:36:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319247', 'F4B5202016FFFC73883F', '045', 'PC2', '110', '1920', '1080', 'kds1', '메인로드[오정호]', '524753985227' ) ========================2020-06-08 13:08:45======================== noteurl_start parm_app_code = 046 parm_pc_name = MG parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C96893398119493 sCDKey = 518069715941 sName = MG ========================2020-06-08 13:08: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 = '518069715941' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 13:08:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wss6011' ========================2020-06-08 13:08:45======================== SELECT idx FROM macs WHERE mac_addr = '00E04C96893398119493' AND app_code = '046' ========================2020-06-08 13:08:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319259' ========================2020-06-08 13:08:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319259' ========================2020-06-08 13:08:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319259', '00E04C96893398119493', '046', 'MG', '110', '1024', '768', 'wss6011', '청주신선낚시[위상선]', '518069715941' ) ========================2020-06-08 13:56:25======================== 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-06-08 13:56: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 = '375508873226' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-08 13:56:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wdjs86101' ========================2020-06-08 13:56:26======================== SELECT idx FROM macs WHERE mac_addr = '00E063318A0542139329' AND app_code = '039' ========================2020-06-08 13:56:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291139' ========================2020-06-08 13:56:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291139' ========================2020-06-08 13:56:26======================== 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-06-08 14:55:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6S1CBU2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 181DEA80F6018A3B632C sCDKey = 414867616982 sName = DESKTOP-6S1CBU2 ========================2020-06-08 14:55: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 = '414867616982' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-08 14:55:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khh0457' ========================2020-06-08 14:55:03======================== SELECT idx FROM macs WHERE mac_addr = '181DEA80F6018A3B632C' AND app_code = '039' ========================2020-06-08 14:55:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319268' ========================2020-06-08 14:55:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319268' ========================2020-06-08 14:55: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 ( '319268', '181DEA80F6018A3B632C', '039', 'DESKTOP-6S1CBU2', '110', '1920', '1080', 'khh0457', '동아특수공구[김현호]', '414867616982' ) ========================2020-06-08 14:55:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6S1CBU2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 181DEA80F6018A3B632C sCDKey = 414867616982 sName = DESKTOP-6S1CBU2 ========================2020-06-08 14: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 = '414867616982' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-08 15:23:18======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-POVGE87 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05D28E01AB8B2B16C sCDKey = 602999716586 sName = 22번 ========================2020-06-08 15:23: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 = '602999716586' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 15:23:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjo0505' ========================2020-06-08 15:23:18======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D28E01AB8B2B16C' AND app_code = '046' ========================2020-06-08 15:23:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319276' ========================2020-06-08 15:23:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319276' ========================2020-06-08 15:23:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319276', '2CF05D28E01AB8B2B16C', '046', '22번', '110', '1920', '1080', 'cjo0505', '우송건재[최종은]', '602999716586' ) ========================2020-06-08 15:26:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RPFIS2T parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05D28E013562AFF15 sCDKey = 602999716586 sName = 23번 ========================2020-06-08 15:26: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 = '602999716586' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-08 15:26:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjo0505' ========================2020-06-08 15:26:55======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D28E013562AFF15' AND app_code = '046' ========================2020-06-08 15:26:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319278' ========================2020-06-08 15:26:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319278' ========================2020-06-08 15:26: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 ( '319278', '2CF05D28E013562AFF15', '046', '23번', '110', '1920', '1080', 'cjo0505', '우송건재[최종은]', '602999716586' ) ========================2020-06-08 18:16:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RG0S4RN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E085DD28D6E257AE4D sCDKey = 422114683375 sName = DESKTOP-RG0S4RN ========================2020-06-08 18:16: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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-08 18:16:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2020-06-08 18:16:26======================== SELECT idx FROM macs WHERE mac_addr = '50E085DD28D6E257AE4D' AND app_code = '039' ========================2020-06-08 18:16:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317235' ========================2020-06-08 18:16:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317235' ========================2020-06-08 18:16:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '317235', '50E085DD28D6E257AE4D', '039', 'DESKTOP-RG0S4RN', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' ) ========================2020-06-08 18:56:24======================== noteurl_start ========================2020-06-08 18:56: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 = '' AND r.app_code = '' AND r.app_block = 0