========================2019-01-23 09:45:16======================== noteurl_start parm_app_code = 039 parm_pc_name = 2 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5C6822A05EBBB4B3 sCDKey = 780420206219 sName = 2 ========================2019-01-23 09:45: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 = '780420206219' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-23 09:45:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssal5707' ========================2019-01-23 09:45:16======================== SELECT idx FROM macs WHERE mac_addr = '408D5C6822A05EBBB4B3' AND app_code = '039' ========================2019-01-23 09:45:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190880' ========================2019-01-23 09:45:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '190880' ========================2019-01-23 09:45:16======================== UPDATE mac_detail SET pc_name = '2', os_type = '90', user_id = 'ssal5707', user_name = '좋은이웃[조형석]', screen_w = '1280', screen_h = '1024', cdkey = '780420206219' WHERE mac_idx = '190880' ========================2019-01-23 11:16:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-46GMA8N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838988BB5B78DE41AB sCDKey = 338396602259 sName = DESKTOP-46GMA8N ========================2019-01-23 11:16: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 = '338396602259' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-23 11:16:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skyeunaa' ========================2019-01-23 11:16:06======================== SELECT idx FROM macs WHERE mac_addr = '98838988BB5B78DE41AB' AND app_code = '039' ========================2019-01-23 11:16:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275096' ========================2019-01-23 11:16:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275096' ========================2019-01-23 11:16: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 ( '275096', '98838988BB5B78DE41AB', '039', 'DESKTOP-46GMA8N', '110', '1920', '1080', 'skyeunaa', '영풍빌딩[최성은]', '338396602259' ) ========================2019-01-23 11:16:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-46GMA8N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838988BB5B78DE41AB sCDKey = 338396602259 sName = DESKTOP-46GMA8N ========================2019-01-23 11:16: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 = '338396602259' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-23 11:35:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BBC0UP7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838984DC75887BB7BC sCDKey = 467945094292 sName = DESKTOP-BBC0UP7 ========================2019-01-23 11:35: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 = '467945094292' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-23 11:35:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kifc1004' ========================2019-01-23 11:35:06======================== SELECT idx FROM macs WHERE mac_addr = '98838984DC75887BB7BC' AND app_code = '039' ========================2019-01-23 11:35:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275099' ========================2019-01-23 11:35:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275099' ========================2019-01-23 11:35: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 ( '275099', '98838984DC75887BB7BC', '039', 'DESKTOP-BBC0UP7', '110', '1920', '1080', 'kifc1004', '(주)광일식품[최란]', '467945094292' ) ========================2019-01-23 14:45:10======================== 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-01-23 14:45: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-23 14:45:16======================== 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-01-23 14:45: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-23 14:45:33======================== 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-01-23 14:45: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-23 14:45:35======================== 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-01-23 14:45: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 = '380552522708' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-23 16:20:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G7AU6JM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838988A90E78DE41AB sCDKey = 853846793831 sName = DESKTOP-G7AU6JM ========================2019-01-23 16:20: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-23 16:20:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-01-23 16:20:11======================== SELECT idx FROM macs WHERE mac_addr = '98838988A90E78DE41AB' AND app_code = '039' ========================2019-01-23 16:20:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275158' ========================2019-01-23 16:20:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275158' ========================2019-01-23 16:20:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275158', '98838988A90E78DE41AB', '039', 'DESKTOP-G7AU6JM', '110', '1920', '1080', 'ijs7740', '(주)고려양행[김기범]', '853846793831' ) ========================2019-01-23 18:22:14======================== noteurl_start parm_app_code = 047 parm_pc_name = PC05-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435130495AEB86DE7 sCDKey = 033894166231 sName = PC05-PC ========================2019-01-23 18:22:14======================== 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 = '033894166231' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-23 18:22:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkco6338' ========================2019-01-23 18:22:14======================== SELECT idx FROM macs WHERE mac_addr = '74D435130495AEB86DE7' AND app_code = '047' ========================2019-01-23 18:22:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275182' ========================2019-01-23 18:22:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275182' ========================2019-01-23 18:22:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '275182', '74D435130495AEB86DE7', '047', 'PC05-PC', '�쐢�룄�슦 7', '0', '0', 'parkco6338', '주식회사 극광[박재호]', '033894166231' )