========================2019-02-07 09:21:54======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 9C5C8E873A6CDE048C14 sCDKey = 170172852468 sName = MSDN-SPECIAL ========================2019-02-07 09:21: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 = '170172852468' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-07 09:21:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sasimi2918' ========================2019-02-07 09:21:54======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E873A6CDE048C14' AND app_code = '039' ========================2019-02-07 09:21:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274589' ========================2019-02-07 09:21:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274589' ========================2019-02-07 09:21:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274589', '9C5C8E873A6CDE048C14', '039', 'MSDN-SPECIAL', '90', '1680', '1050', 'sasimi2918', '다랑참치[맹병열]', '170172852468' ) ========================2019-02-07 09:29:57======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:29:57======================== 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 ========================2019-02-07 09:29:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:29:57======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:29:57======================== 값이 없을 경우 ========================2019-02-07 09:35:52======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:35: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:35:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:35:52======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:35:52======================== 값이 없을 경우 ========================2019-02-07 09:36:35======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:36: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:36:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:36:35======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:36:35======================== 값이 없을 경우 ========================2019-02-07 09:36:58======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:36: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:36:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:36:58======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:36:58======================== 값이 없을 경우 ========================2019-02-07 09:38:32======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:38:32======================== 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 ========================2019-02-07 09:38:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:38:32======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:38:32======================== 값이 없을 경우 ========================2019-02-07 09:38:57======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:38:57======================== 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 ========================2019-02-07 09:38:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:38:57======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:38:57======================== 값이 없을 경우 ========================2019-02-07 09:39:19======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:39: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:39:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:39:19======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:39:19======================== 값이 없을 경우 ========================2019-02-07 09:40:30======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:40: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:40:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:40:30======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:40:30======================== 값이 없을 경우 ========================2019-02-07 09:41:50======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:41:50======================== 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 ========================2019-02-07 09:41:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:41:50======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:41:50======================== 값이 없을 경우 ========================2019-02-07 09:44:07======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:44: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:44:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:44:07======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:44:07======================== 값이 없을 경우 ========================2019-02-07 09:51:23======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:51:23======================== 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 ========================2019-02-07 09:51:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:51:23======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:51:23======================== 값이 없을 경우 ========================2019-02-07 09:52:30======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:52: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:52:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:52:30======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:52:30======================== 값이 없을 경우 ========================2019-02-07 09:56:25======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 09:56:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:56:25======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:56:25======================== 값이 없을 경우 ========================2019-02-07 09:56:43======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 09:56:43======================== 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 ========================2019-02-07 09:56:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 09:56:43======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 09:56:43======================== 값이 없을 경우 ========================2019-02-07 10:00:17======================== noteurl_start parm_app_code = 046 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D16817280D8FDA sCDKey = 473748127893 sName = VB ========================2019-02-07 10:00: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 = '473748127893' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 10:00:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2019-02-07 10:00:17======================== SELECT idx FROM macs WHERE mac_addr = '080027D16817280D8FDA' AND app_code = '046' ========================2019-02-07 10:00:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '196416' ========================2019-02-07 10:00:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '196416' ========================2019-02-07 10:00: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 ( '196416', '080027D16817280D8FDA', '046', 'VB', '64', '1920', '976', 'aej123456', '엠제이소프트[안은준]', '473748127893' ) ========================2019-02-07 10:00:42======================== noteurl_start parm_app_code = 046 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D16817280D8FDA sCDKey = 473748127893 sName = VB ========================2019-02-07 10:00: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 = '473748127893' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-07 10:15:11======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 000F004186FE242D3F92 sCDKey = mjsof2019020 sName = USER-PC ========================2019-02-07 10:15:11======================== 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 = 'MJSOF2019020' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-07 10:18:44======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A0A185301A567F sCDKey = 975677425073 sName = POS2-190127 ========================2019-02-07 10:18:44======================== 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 ========================2019-02-07 10:18:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 10:18:44======================== SELECT idx FROM macs WHERE mac_addr = '241C04A0A185301A567F' AND app_code = '046' ========================2019-02-07 10:18:44======================== 값이 없을 경우 ========================2019-02-07 10:22:16======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 000F004186FE242D3F92 sCDKey = 682850602194 sName = USER-PC ========================2019-02-07 10:22: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 = '682850602194' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-07 10:22:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klosed' ========================2019-02-07 10:22:16======================== SELECT idx FROM macs WHERE mac_addr = '000F004186FE242D3F92' AND app_code = '039' ========================2019-02-07 10:22:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275181' ========================2019-02-07 10:22:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275181' ========================2019-02-07 10:22:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275181', '000F004186FE242D3F92', '039', 'USER-PC', '90', '1366', '768', 'klosed', '아성유리문[양세훈]', '682850602194' ) ========================2019-02-07 16:55:33======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D6500A5D002CB9A sCDKey = 259187292107 sName = 크린베라텍 ========================2019-02-07 16:55:33======================== 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 = '259187292107' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-07 16:55:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bosskimminsu' ========================2019-02-07 16:55:33======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D6500A5D002CB9A' AND app_code = '039' ========================2019-02-07 16:55:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276027' ========================2019-02-07 16:55:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276027' ========================2019-02-07 16:55:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '276027', '1C1B0D6500A5D002CB9A', '039', '크린베라텍', '110', '1920', '1080', 'bosskimminsu', '크린베라텍[김민수]', '259187292107' ) ========================2019-02-07 17:58:36======================== noteurl_start parm_app_code = 047 parm_pc_name = COUNTER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C27B88F4D863441C sCDKey = 616623290210 sName = COUNTER-PC ========================2019-02-07 17:58: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 = '616623290210' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-07 17:58:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'se7entoy' ========================2019-02-07 17:58:36======================== SELECT idx FROM macs WHERE mac_addr = '7085C27B88F4D863441C' AND app_code = '047' ========================2019-02-07 17:58:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '276459' ========================2019-02-07 17:58:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '276459' ========================2019-02-07 17:58: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 ( '276459', '7085C27B88F4D863441C', '047', 'COUNTER-PC', '�쐢�룄�슦 7', '0', '0', 'se7entoy', '세븐토이[최선우]', '616623290210' ) ========================2019-02-07 18:41:40======================== noteurl_start parm_app_code = 046 parm_pc_name = POS1-190127 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 241C04A04C01301A567F sCDKey = 975677425073 sName = POS1-190127 ========================2019-02-07 18:41:40======================== 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 ========================2019-02-07 18:41:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2019-02-07 18:41:40======================== SELECT idx FROM macs WHERE mac_addr = '241C04A04C01301A567F' AND app_code = '046' ========================2019-02-07 18:41:40======================== 값이 없을 경우