========================2020-11-20 08:44:33======================== noteurl_start parm_app_code = 046 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1008B18E9CFDEE1999FD sCDKey = 618350604114 sName = LEE-PC ========================2020-11-20 08:44: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 = '618350604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-20 08:44:53======================== noteurl_start parm_app_code = 046 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1008B18E9CFDEE1999FD sCDKey = 618650604114 sName = LEE-PC ========================2020-11-20 08:44: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-20 08:45:01======================== noteurl_start parm_app_code = 046 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1008B18E9CFDEE1999FD sCDKey = 618650604114 sName = LEE-PC ========================2020-11-20 08:45: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-20 08:45:20======================== noteurl_start parm_app_code = 046 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1008B18E9CFDEE1999FD sCDKey = 618650604114 sName = LEE-PC ========================2020-11-20 08:45:20======================== 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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-20 08:46:36======================== noteurl_start parm_app_code = 046 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1008B18E9CFDEE1999FD sCDKey = 618650604114 sName = LEE-PC ========================2020-11-20 08:46: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-20 11:47:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EDP67VD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9166C5CC6548898 sCDKey = 924488709708 sName = DESKTOP-EDP67VD ========================2020-11-20 11:47: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 = '924488709708' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-20 11:47:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yanghh1004' ========================2020-11-20 11:47:25======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9166C5CC6548898' AND app_code = '039' ========================2020-11-20 11:47:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330528' ========================2020-11-20 11:47:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330528' ========================2020-11-20 11:47:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330528', '8CB0E9166C5CC6548898', '039', 'DESKTOP-EDP67VD', '110', '1920', '1080', 'yanghh1004', '[양효현]', '924488709708' ) ========================2020-11-20 11:58:07======================== noteurl_start parm_app_code = 046 parm_pc_name = LEE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1008B18E9CFDEE1999FD sCDKey = 618650604114 sName = LEE-PC ========================2020-11-20 11:58: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-20 11:58:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daelim1060' ========================2020-11-20 11:58:07======================== SELECT idx FROM macs WHERE mac_addr = '1008B18E9CFDEE1999FD' AND app_code = '046' ========================2020-11-20 11:58:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '231019' ========================2020-11-20 11:58:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '231019' ========================2020-11-20 11:58:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '231019', '1008B18E9CFDEE1999FD', '046', 'LEE-PC', '90', '1366', '768', 'daelim1060', '대림농자재[이완구]', '618650604114' ) ========================2020-11-20 14:09:12======================== noteurl_start parm_app_code = 050 parm_pc_name = GT-D15041A parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0862663720423624250E sCDKey = 783859378736 sName = GT-D15041A ========================2020-11-20 14:09: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 = '783859378736' AND r.app_code = '050' AND r.app_block = 0 ========================2020-11-20 14:09:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'glotec' ========================2020-11-20 14:09:12======================== SELECT idx FROM macs WHERE mac_addr = '0862663720423624250E' AND app_code = '050' ========================2020-11-20 14:09:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329928' ========================2020-11-20 14:09:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329928' ========================2020-11-20 14:09: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 ( '329928', '0862663720423624250E', '050', 'GT-D15041A', '90', '1920', '1080', 'glotec', '글로텍엔지니어링[안도영]', '783859378736' )