========================2019-02-28 10:33:38======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A01D48F97BAC7A03CF15 sCDKey = 587810805864 sName = HP ========================2019-02-28 10:33:38======================== 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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-28 10:33:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'withusptns' ========================2019-02-28 10:33:38======================== SELECT idx FROM macs WHERE mac_addr = 'A01D48F97BAC7A03CF15' AND app_code = '039' ========================2019-02-28 10:33:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '185341' ========================2019-02-28 10:33:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '185341' ========================2019-02-28 10:33:38======================== UPDATE mac_detail SET pc_name = 'HP', os_type = '110', user_id = 'withusptns', user_name = '위더스파트너스주식회사[노현국]', screen_w = '1536', screen_h = '864', cdkey = '587810805864' WHERE mac_idx = '185341' ========================2019-02-28 10:33:45======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A01D48F97BAC7A03CF15 sCDKey = 587810805864 sName = HP ========================2019-02-28 10:33: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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2019-02-28 11:28:22======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00089FD8E06BA41C65F sCDKey = 834962125925 sName = 전시회 전용 ========================2019-02-28 11:28: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 11:28:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-02-28 11:28:22======================== SELECT idx FROM macs WHERE mac_addr = '00089FD8E06BA41C65F' AND app_code = '046' ========================2019-02-28 11:28:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278621' ========================2019-02-28 11:28:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278621' ========================2019-02-28 11:28:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '278621', '00089FD8E06BA41C65F', '046', '전시회 전용', '90', '1024', '768', 'ericaan', '주식회사 메종드파리[안진현]', '834962125925' ) ========================2019-02-28 11:28:27======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00089FD8E06BA41C65F sCDKey = 834962125925 sName = 전시회 전용 ========================2019-02-28 11:28: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 11:28:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-02-28 11:28:27======================== SELECT idx FROM macs WHERE mac_addr = '00089FD8E06BA41C65F' AND app_code = '046' ========================2019-02-28 11:28:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278621' ========================2019-02-28 11:28:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278621' ========================2019-02-28 11:28:27======================== UPDATE mac_detail SET pc_name = '전시회 전용', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '278621' ========================2019-02-28 11:29:57======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23111599EA2DEFA sCDKey = 834962125925 sName = 경리부 ========================2019-02-28 11: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 11:29:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-02-28 11:29:57======================== SELECT idx FROM macs WHERE mac_addr = '7085C23111599EA2DEFA' AND app_code = '046' ========================2019-02-28 11:29:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267799' ========================2019-02-28 11:29:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267799' ========================2019-02-28 11:29:57======================== UPDATE mac_detail SET pc_name = '경리부', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1920', screen_h = '1080', cdkey = '834962125925' WHERE mac_idx = '267799' ========================2019-02-28 11:56:49======================== noteurl_start parm_app_code = 046 parm_pc_name = APDR0TZGCPUDVDY parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0F073E815922C sCDKey = 834926125925 sName = 2층매장 ========================2019-02-28 11:56: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 = '834926125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 11:57:01======================== noteurl_start parm_app_code = 046 parm_pc_name = APDR0TZGCPUDVDY parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0F073E815922C sCDKey = 834962125925 sName = 2층매장 ========================2019-02-28 11:57: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 11:57:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-02-28 11:57:01======================== SELECT idx FROM macs WHERE mac_addr = '00190F0F073E815922C' AND app_code = '046' ========================2019-02-28 11:57:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273188' ========================2019-02-28 11:57:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273188' ========================2019-02-28 11:57:01======================== UPDATE mac_detail SET pc_name = '2층매장', os_type = '64', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '273188' ========================2019-02-28 12:35:57======================== noteurl_start parm_app_code = 046 parm_pc_name = SJ-20141219NCCE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0AA05640CBE2CA sCDKey = 834962125925 sName = 1층 매장 ========================2019-02-28 12:35: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 12:35:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-02-28 12:35:57======================== SELECT idx FROM macs WHERE mac_addr = '00190F0AA05640CBE2CA' AND app_code = '046' ========================2019-02-28 12:35:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268192' ========================2019-02-28 12:35:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268192' ========================2019-02-28 12:35:57======================== UPDATE mac_detail SET pc_name = '1층 매장', os_type = '64', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '268192' ========================2019-02-28 13:28:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7M644CJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC74C27870A406 sCDKey = 807375456416 sName = DESKTOP-7M644CJ ========================2019-02-28 13:28:02======================== 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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-28 13:28:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2019-02-28 13:28:02======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC74C27870A406' AND app_code = '047' ========================2019-02-28 13:28:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278633' ========================2019-02-28 13:28:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278633' ========================2019-02-28 13:28:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '278633', 'F44D30BC74C27870A406', '047', 'DESKTOP-7M644CJ', '�쐢�룄�슦 10', '0', '0', 'gana4807', '(주)가나24시동물병원[김창규]', '807375456416' ) ========================2019-02-28 14:53:37======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7M644CJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC74C87870A406 sCDKey = 807375456416 sName = DESKTOP-7M644CJ ========================2019-02-28 14:53: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-28 15:24:53======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7M644CJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC74C87870A406 sCDKey = 807375456416 sName = DESKTOP-7M644CJ ========================2019-02-28 15:24: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-28 15:24:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2019-02-28 15:24:53======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC74C87870A406' AND app_code = '047' ========================2019-02-28 15:24:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278647' ========================2019-02-28 15:24:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278647' ========================2019-02-28 15:24:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '278647', 'F44D30BC74C87870A406', '047', 'DESKTOP-7M644CJ', '�쐢�룄�슦 10', '0', '0', 'gana4807', '(주)가나24시동물병원[김창규]', '807375456416' ) ========================2019-02-28 15:47:11======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7M644CJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC74C27870A406 sCDKey = 807375456416 sName = DESKTOP-7M644CJ ========================2019-02-28 15:47: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 = '807375456416' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-28 15:47:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gana4807' ========================2019-02-28 15:47:11======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC74C27870A406' AND app_code = '047' ========================2019-02-28 15:47:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278633' ========================2019-02-28 15:47:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278633' ========================2019-02-28 15:47:11======================== UPDATE mac_detail SET pc_name = 'DESKTOP-7M644CJ', os_type = '�쐢�룄�슦 10', user_id = 'gana4807', user_name = '(주)가나24시동물병원[김창규]', screen_w = '0', screen_h = '0', cdkey = '807375456416' WHERE mac_idx = '278633' ========================2019-02-28 16:05:58======================== noteurl_start parm_app_code = 050 parm_pc_name = 고대원-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AC7EA90EBE208E sCDKey = 380552522708 sName = 고대원-PC ========================2019-02-28 16:05: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-02-28 16:05:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'snip' ========================2019-02-28 16:05:58======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AC7EA90EBE208E' AND app_code = '050' ========================2019-02-28 16:05:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274962' ========================2019-02-28 16:05:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274962' ========================2019-02-28 16:05:58======================== UPDATE mac_detail SET pc_name = '고대원-PC', os_type = '90', user_id = 'snip', user_name = '성남산업진흥재단[김선규]', screen_w = '1920', screen_h = '1080', cdkey = '380552522708' WHERE mac_idx = '274962' ========================2019-02-28 17:16:35======================== noteurl_start parm_app_code = 046 parm_pc_name = CREATIVECOM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3085A99AE950BE8B1CF1 sCDKey = SRP-350plus sName = CREATIVECOM ========================2019-02-28 17:16: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 = 'SRP350PLUS' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 17:16:40======================== noteurl_start parm_app_code = 046 parm_pc_name = CREATIVECOM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3085A99AE950BE8B1CF1 sCDKey = SRP-350plus sName = CREATIVECOM ========================2019-02-28 17:16: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 = 'SRP350PLUS' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 18:08:18======================== noteurl_start parm_app_code = 046 parm_pc_name = DANJINAIL_CS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F48E389BBF47A44C2DA1 sCDKey = 916970945314 sName = DANJINAIL_CS ========================2019-02-28 18:08: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-28 18:08:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2019-02-28 18:08:18======================== SELECT idx FROM macs WHERE mac_addr = 'F48E389BBF47A44C2DA1' AND app_code = '046' ========================2019-02-28 18:08:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278672' ========================2019-02-28 18:08:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278672' ========================2019-02-28 18:08: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 ( '278672', 'F48E389BBF47A44C2DA1', '046', 'DANJINAIL_CS', '110', '1920', '1080', 'danjinail', '단지네네일가게[임재완]', '916970945314' )