========================2020-07-21 10:27:02======================== noteurl_start parm_app_code = 047 parm_pc_name = KIMNAMSU-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38D547280D73A209683B sCDKey = 151383996000 sName = KIMNAMSU-PC ========================2020-07-21 10:27: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 = '151383996000' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-21 10:29:40======================== noteurl_start parm_app_code = 047 parm_pc_name = KIMNAMSU-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 38D547280D73A209683B sCDKey = 188728650429 sName = KIMNAMSU-PC ========================2020-07-21 10:29: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 = '188728650429' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-21 10:29:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kak0936' ========================2020-07-21 10:29:40======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73A209683B' AND app_code = '047' ========================2020-07-21 10:29:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317409' ========================2020-07-21 10:29:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317409' ========================2020-07-21 10:29: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 ( '317409', '38D547280D73A209683B', '047', 'KIMNAMSU-PC', '�쐢�룄�슦 10', '0', '0', 'kak0936', '[김남수]', '188728650429' ) ========================2020-07-21 13:06:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-20M7PTI parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 960 parm_user_mac = 8C89A5654E1C88E00C33 sCDKey = 040781807564 sName = DESKTOP-20M7PTI ========================2020-07-21 13:06: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 = '040781807564' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-21 13:06:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jkw7906' ========================2020-07-21 13:06:42======================== SELECT idx FROM macs WHERE mac_addr = '8C89A5654E1C88E00C33' AND app_code = '039' ========================2020-07-21 13:06:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308341' ========================2020-07-21 13:06:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308341' ========================2020-07-21 13:06:42======================== UPDATE mac_detail SET pc_name = 'DESKTOP-20M7PTI', os_type = '110', user_id = 'jkw7906', user_name = '카우하이텍[주카우]', screen_w = '1536', screen_h = '960', cdkey = '040781807564' WHERE mac_idx = '308341' ========================2020-07-21 13:32:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-92URQJ5 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E8039A655A768EC6633C sCDKey = 040781807564 sName = DESKTOP-92URQJ5 ========================2020-07-21 13:32: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 = '040781807564' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-21 13:32:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jkw7906' ========================2020-07-21 13:32:45======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A655A768EC6633C' AND app_code = '039' ========================2020-07-21 13:32:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321558' ========================2020-07-21 13:32:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321558' ========================2020-07-21 13:32:45======================== UPDATE mac_detail SET pc_name = 'DESKTOP-92URQJ5', os_type = '110', user_id = 'jkw7906', user_name = '카우하이텍[주카우]', screen_w = '1536', screen_h = '864', cdkey = '040781807564' WHERE mac_idx = '321558' ========================2020-07-21 13:32:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-92URQJ5 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E8039A655A768EC6633C sCDKey = 040781807564 sName = DESKTOP-92URQJ5 ========================2020-07-21 13: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 = '040781807564' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-21 13:50:58======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 13: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 13:50:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 13:50:58======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 13:50:58======================== 값이 없을 경우 ========================2020-07-21 13:51:39======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 13:51:39======================== 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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 13:51:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 13:51:39======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 13:51:39======================== 값이 없을 경우 ========================2020-07-21 13:52:00======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 13:52:00======================== 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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 13:52:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 13:52:01======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 13:52:01======================== 값이 없을 경우 ========================2020-07-21 13:52:22======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 13:52: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 13:52:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 13:52:22======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 13:52:22======================== 값이 없을 경우 ========================2020-07-21 13:55:04======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 13:55:04======================== 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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 13:55:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 13:55:04======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 13:55:04======================== 값이 없을 경우 ========================2020-07-21 13:55:29======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FFU158G parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 34CFF63B340902F63433 sCDKey = 434133617514 sName = DESKTOP-FFU158G ========================2020-07-21 13:55:29======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-21 13:55:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2020-07-21 13:55:30======================== SELECT idx FROM macs WHERE mac_addr = '34CFF63B340902F63433' AND app_code = '048' ========================2020-07-21 13:55:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322330' ========================2020-07-21 13:55:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322330' ========================2020-07-21 13:55:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322330', '34CFF63B340902F63433', '048', 'DESKTOP-FFU158G', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2020-07-21 13:55:34======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FFU158G parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 34CFF63B340902F63433 sCDKey = 434133617514 sName = DESKTOP-FFU158G ========================2020-07-21 13:55: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-21 13:55:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2020-07-21 13:55:34======================== SELECT idx FROM macs WHERE mac_addr = '34CFF63B340902F63433' AND app_code = '048' ========================2020-07-21 13:55:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322330' ========================2020-07-21 13:55:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322330' ========================2020-07-21 13:55:34======================== UPDATE mac_detail SET pc_name = 'DESKTOP-FFU158G', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '322330' ========================2020-07-21 13:56:45======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 13:56: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 13:56:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 13:56:45======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 13:56:45======================== 값이 없을 경우 ========================2020-07-21 14:03:27======================== noteurl_start parm_app_code = 046 parm_pc_name = HANSEO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF485682F646F7D14 sCDKey = 382846985937 sName = HANSEO ========================2020-07-21 14:03: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 = '382846985937' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-21 14:03:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanseo5054' ========================2020-07-21 14:03:27======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF485682F646F7D14' AND app_code = '046' ========================2020-07-21 14:03:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322343' ========================2020-07-21 14:03:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322343' ========================2020-07-21 14:03:27======================== UPDATE mac_detail SET pc_name = 'HANSEO', os_type = '64', user_id = 'hanseo5054', user_name = '주식회사한서종합물류[조명애]', screen_w = '1024', screen_h = '768', cdkey = '382846985937' WHERE mac_idx = '322343' ========================2020-07-21 16:30:23======================== noteurl_start parm_app_code = 047 parm_pc_name = LEESUNGWOO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 309C23A7F46E967137FA sCDKey = 374153147566 sName = LEESUNGWOO ========================2020-07-21 16:30: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 = '374153147566' AND r.app_code = '047' AND r.app_block = 0