========================2018-12-17 08:32:56======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 003067FC151486C2E80F sCDKey = 224412850603 sName = ========================2018-12-17 08:32:56======================== 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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 08:33:11======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 003067FC151486C2E80F sCDKey = 224412850603 sName = 제우산업 ========================2018-12-17 08:33: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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 08:33:27======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 003067FC151486C2E80F sCDKey = 224412850603 sName = 제우산업 ========================2018-12-17 08:33: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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 08:36:02======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 003067FC151486C2E80F sCDKey = 224412850603 sName = 박종길 ========================2018-12-17 08:36: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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 08:36:09======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 003067FC151486C2E80F sCDKey = 224412850603 sName = ========================2018-12-17 08:36: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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 09:18:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KL2Q0V0 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B42E991545AABEC057B8 sCDKey = 753237620546 sName = DESKTOP-KL2Q0V0 ========================2018-12-17 09:18: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 = '753237620546' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-17 09:20:06======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KL2Q0V0 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B42E991545AABEC057B8 sCDKey = 753237620546 sName = DESKTOP-KL2Q0V0 ========================2018-12-17 09:20:06======================== 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 = '753237620546' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-17 09:20:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daehoss' ========================2018-12-17 09:20:06======================== SELECT idx FROM macs WHERE mac_addr = 'B42E991545AABEC057B8' AND app_code = '046' ========================2018-12-17 09:20:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271100' ========================2018-12-17 09:20:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271100' ========================2018-12-17 09:20:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271100', 'B42E991545AABEC057B8', '046', 'DESKTOP-KL2Q0V0', '110', '1680', '1050', 'daehoss', '대호상사[이승호]', '753237620546' ) ========================2018-12-17 10:06:23======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 003067FC151486C2E80F sCDKey = 224412850603 sName = 제우산업 ========================2018-12-17 10:06: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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 10:06:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjk8298' ========================2018-12-17 10:06:23======================== SELECT idx FROM macs WHERE mac_addr = '003067FC151486C2E80F' AND app_code = '039' ========================2018-12-17 10:06:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271094' ========================2018-12-17 10:06:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271094' ========================2018-12-17 10:06:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271094', '003067FC151486C2E80F', '039', '제우산업', '90', '1600', '900', 'pjk8298', '제우산업[박종길]', '224412850603' ) ========================2018-12-17 10:48:52======================== noteurl_start parm_app_code = 021 parm_pc_name = DESKTOP-4I5LM94 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 74D4351E19DD2A8A0D67 sCDKey = yskk84848383 sName = DESKTOP-4I5LM94 ========================2018-12-17 10:48: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 = 'YSKK84848383' AND r.app_code = '021' AND r.app_block = 0 ========================2018-12-17 11:09:42======================== noteurl_start parm_app_code = 039 parm_pc_name = LGPC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = E8B1FCE7734F98912FA6 sCDKey = 982834938334 sName = LGPC ========================2018-12-17 11:09: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 = '982834938334' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 14:49:44======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-4TP2D74 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E98A72A4C26434C sCDKey = 760488924460 sName = DESKTOP-4TP2D74 ========================2018-12-17 14:49: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 = '760488924460' AND r.app_code = '045' AND r.app_block = 0 ========================2018-12-17 14:49:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kitchennice' ========================2018-12-17 14:49:44======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E98A72A4C26434C' AND app_code = '045' ========================2018-12-17 14:49:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271147' ========================2018-12-17 14:49:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271147' ========================2018-12-17 14:49:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271147', 'E0D55E98A72A4C26434C', '045', 'DESKTOP-4TP2D74', '110', '1920', '1080', 'kitchennice', '(주)키친나이스[박천웅]', '760488924460' ) ========================2018-12-17 15:00:12======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-A2NLAHR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 4CEDFB69B3374C35FF2C sCDKey = 356624337579 sName = DESKTOP-A2NLAHR ========================2018-12-17 15:00: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 = '356624337579' AND r.app_code = '047' AND r.app_block = 0 ========================2018-12-17 15:00:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bcd9999' ========================2018-12-17 15:00:12======================== SELECT idx FROM macs WHERE mac_addr = '4CEDFB69B3374C35FF2C' AND app_code = '047' ========================2018-12-17 15:00:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271152' ========================2018-12-17 15:00:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271152' ========================2018-12-17 15:00:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271152', '4CEDFB69B3374C35FF2C', '047', 'DESKTOP-A2NLAHR', '�쐢�룄�슦 10', '0', '0', 'bcd9999', '청라제일철물건재공구[이민욱]', '356624337579' ) ========================2018-12-17 15:24:31======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-3G98F5BFAKO parm_os_type = 90 parm_screen_w = 1400 parm_screen_h = 1050 parm_user_mac = 94DE805125FB3E49842C sCDKey = 029916777495 sName = WIN-3G98F5BFAKO ========================2018-12-17 15:24: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 = '029916777495' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 15:24:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mmshkim' ========================2018-12-17 15:24:31======================== SELECT idx FROM macs WHERE mac_addr = '94DE805125FB3E49842C' AND app_code = '039' ========================2018-12-17 15:24:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271161' ========================2018-12-17 15:24:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271161' ========================2018-12-17 15:24:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271161', '94DE805125FB3E49842C', '039', 'WIN-3G98F5BFAKO', '90', '1400', '1050', 'mmshkim', '(주)금호에이앤디[김문겸]', '029916777495' ) ========================2018-12-17 16:46:35======================== noteurl_start parm_app_code = 045 parm_pc_name = 8-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E5493BAF568C3A8800 sCDKey = 381943393149 sName = 8-PC ========================2018-12-17 16:46: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 = '381943393149' AND r.app_code = '045' AND r.app_block = 0 ========================2018-12-17 16:46:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'guyoung1030' ========================2018-12-17 16:46:35======================== SELECT idx FROM macs WHERE mac_addr = '50E5493BAF568C3A8800' AND app_code = '045' ========================2018-12-17 16:46:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271182' ========================2018-12-17 16:46:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271182' ========================2018-12-17 16:46:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271182', '50E5493BAF568C3A8800', '045', '8-PC', '90', '1920', '1080', 'guyoung1030', '(주)봉농[정구영]', '381943393149' ) ========================2018-12-17 16:51:17======================== noteurl_start parm_app_code = 039 parm_pc_name = JBH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0A8CDE8C3A8B617DE69 sCDKey = 550400830049 sName = JBH-PC ========================2018-12-17 16:51: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-17 16:51:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bmtec' ========================2018-12-17 16:51:17======================== SELECT idx FROM macs WHERE mac_addr = 'A0A8CDE8C3A8B617DE69' AND app_code = '039' ========================2018-12-17 16:51:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '171942' ========================2018-12-17 16:51:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '171942' ========================2018-12-17 16:51:17======================== UPDATE mac_detail SET pc_name = 'JBH-PC', os_type = '110', user_id = 'bmtec', user_name = 'BMTEC[전보현]', screen_w = '1920', screen_h = '1080', cdkey = '550400830049' WHERE mac_idx = '171942'