========================2020-06-22 08:58:48======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J9RK1RE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883891A83651CD3735B sCDKey = korplka11060 sName = DESKTOP-J9RK1RE ========================2020-06-22 08:58:48======================== 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 = 'KORPLKA11060' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-22 09:05:07======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-200622-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 7085C2410B34F274245B sCDKey = 975677425073 sName = POS2-200622-PC ========================2020-06-22 09:05: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 ========================2020-06-22 09:05:45======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-200622-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 7085C2410B34F274245B sCDKey = 975677425073 sName = POS2-200622-PC ========================2020-06-22 09:05: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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-22 09:05:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2020-06-22 09:05:45======================== SELECT idx FROM macs WHERE mac_addr = '7085C2410B34F274245B' AND app_code = '046' ========================2020-06-22 09:05:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320140' ========================2020-06-22 09:05:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320140' ========================2020-06-22 09:05: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 ( '320140', '7085C2410B34F274245B', '046', 'POS2-200622-PC', '90', '1024', '768', 'ami2881', '아미상사[이재훈]', '975677425073' ) ========================2020-06-22 10:42:49======================== 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 ========================2020-06-22 10:42:49======================== 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 ========================2020-06-22 11:15:10======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-1FDFBUG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C9CDD782683067 sCDKey = 316592127001 sName = DESKTOP-1FDFBUG ========================2020-06-22 11:15:10======================== 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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-22 11:15:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-22 11:15:10======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CDD782683067' AND app_code = '048' ========================2020-06-22 11:15:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319874' ========================2020-06-22 11:15:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319874' ========================2020-06-22 11:15:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-1FDFBUG', os_type = '�쐢�룄�슦 10', user_id = 'robustmd', user_name = '로부스트엠디[오경숙]', screen_w = '0', screen_h = '0', cdkey = '316592127001' WHERE mac_idx = '319874' ========================2020-06-22 11:34:43======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-1FDFBUG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C9CDD782683067 sCDKey = 316592127001 sName = DESKTOP-1FDFBUG ========================2020-06-22 11:34: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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-22 11:34:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-22 11:34:43======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CDD782683067' AND app_code = '048' ========================2020-06-22 11:34:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319874' ========================2020-06-22 11:34:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319874' ========================2020-06-22 11:34:43======================== UPDATE mac_detail SET pc_name = 'DESKTOP-1FDFBUG', os_type = '�쐢�룄�슦 10', user_id = 'robustmd', user_name = '로부스트엠디[오경숙]', screen_w = '0', screen_h = '0', cdkey = '316592127001' WHERE mac_idx = '319874' ========================2020-06-22 11:34:47======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-1FDFBUG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C9CDD782683067 sCDKey = 316592127001 sName = DESKTOP-1FDFBUG ========================2020-06-22 11:34:47======================== 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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-22 11:36:34======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-1FDFBUG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99C9CDD782683067 sCDKey = 316592127001 sName = DESKTOP-1FDFBUG ========================2020-06-22 11:36:34======================== 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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-22 11:36:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-22 11:36:34======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CDD782683067' AND app_code = '048' ========================2020-06-22 11:36:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319874' ========================2020-06-22 11:36:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319874' ========================2020-06-22 11:36:34======================== UPDATE mac_detail SET pc_name = 'DESKTOP-1FDFBUG', os_type = '�쐢�룄�슦 10', user_id = 'robustmd', user_name = '로부스트엠디[오경숙]', screen_w = '0', screen_h = '0', cdkey = '316592127001' WHERE mac_idx = '319874' ========================2020-06-22 11:45:27======================== 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 = 24F5AAE5B65174258B30 sCDKey = 892232246788 sName = DALLAITI ========================2020-06-22 11:45:27======================== 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 ========================2020-06-22 11:45:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumnam' ========================2020-06-22 11:45:27======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE5B65174258B30' AND app_code = '046' ========================2020-06-22 11:45:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '160264' ========================2020-06-22 11:45:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '160264' ========================2020-06-22 11:45:27======================== 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 = '160264' ========================2020-06-22 14:21:16======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J9RK1RE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883891A83651CD3735B sCDKey = 283054670964 sName = DESKTOP-J9RK1RE ========================2020-06-22 14:21: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 = '283054670964' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-22 14:22:35======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J9RK1RE parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883891A83651CD3735B sCDKey = 283054670964 sName = DESKTOP-J9RK1RE ========================2020-06-22 14:22: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 = '283054670964' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-22 14:22:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs201' ========================2020-06-22 14:22:36======================== SELECT idx FROM macs WHERE mac_addr = '9883891A83651CD3735B' AND app_code = '046' ========================2020-06-22 14:22:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '297997' ========================2020-06-22 14:22:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '297997' ========================2020-06-22 14:22:36======================== UPDATE mac_detail SET pc_name = 'DESKTOP-J9RK1RE', os_type = '110', user_id = 'bs201', user_name = '진흥기공[진흥기공]', screen_w = '1366', screen_h = '768', cdkey = '283054670964' WHERE mac_idx = '297997' ========================2020-06-22 16:06:43======================== noteurl_start parm_app_code = 039 parm_pc_name = MASTER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 00245431C4C728ADBB7 sCDKey = 662258677375 sName = MASTER-PC ========================2020-06-22 16:06: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 = '662258677375' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-22 16:06:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'koo6706' ========================2020-06-22 16:06:43======================== SELECT idx FROM macs WHERE mac_addr = '00245431C4C728ADBB7' AND app_code = '039' ========================2020-06-22 16:06:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320190' ========================2020-06-22 16:06:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320190' ========================2020-06-22 16:06:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320190', '00245431C4C728ADBB7', '039', 'MASTER-PC', '90', '1440', '900', 'koo6706', '한일건기[유광민]', '662258677375' ) ========================2020-06-22 16:45:31======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00FFA098738776D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-22 16:45:31======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-22 16:45:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2020-06-22 16:45:32======================== SELECT idx FROM macs WHERE mac_addr = '00FFA098738776D7F1ED' AND app_code = '039' ========================2020-06-22 16:45:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320139' ========================2020-06-22 16:45:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320139' ========================2020-06-22 16:45:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320139', '00FFA098738776D7F1ED', '039', 'HANDO', '110', '1920', '1080', 'hando77', '한도교역[한도교역]', '173379187341' )