========================2021-01-06 09:20:05======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PET parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04CB1D92998119493 sCDKey = 685230340148 sName = POS-PET ========================2021-01-06 09:20:05======================== 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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2021-01-06 09:20:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclubgj' ========================2021-01-06 09:20:05======================== SELECT idx FROM macs WHERE mac_addr = '00E04CB1D92998119493' AND app_code = '046' ========================2021-01-06 09:20:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334049' ========================2021-01-06 09:20:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334049' ========================2021-01-06 09:20:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334049', '00E04CB1D92998119493', '046', 'POS-PET', '110', '1024', '768', 'petclubgj', '펫클럽퍼스트도그[김기은]', '685230340148' ) ========================2021-01-06 11:15:47======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-18DKFHL parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 5891CFD32D63B2C724DC sCDKey = 258852625716 sName = DESKTOP-18DKFHL ========================2021-01-06 11:15:47======================== 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 = '258852625716' AND r.app_code = '045' AND r.app_block = 0 ========================2021-01-06 11:15:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daelim59' ========================2021-01-06 11:15:47======================== SELECT idx FROM macs WHERE mac_addr = '5891CFD32D63B2C724DC' AND app_code = '045' ========================2021-01-06 11:15:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334066' ========================2021-01-06 11:15:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334066' ========================2021-01-06 11:15:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334066', '5891CFD32D63B2C724DC', '045', 'DESKTOP-18DKFHL', '110', '1280', '720', 'daelim59', '엔터팩쇼핑몰[김정희]', '258852625716' ) ========================2021-01-06 15:00:40======================== noteurl_start parm_app_code = 051 parm_pc_name = 문성일 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691FA56E5D258648A sCDKey = 049624493773 sName = 문성일 ========================2021-01-06 15:00: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 = '049624493773' AND r.app_code = '051' AND r.app_block = 0 ========================2021-01-06 15:00:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsoon0402' ========================2021-01-06 15:00:40======================== SELECT idx FROM macs WHERE mac_addr = '94C691FA56E5D258648A' AND app_code = '051' ========================2021-01-06 15:00:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334091' ========================2021-01-06 15:00:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334091' ========================2021-01-06 15:00:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334091', '94C691FA56E5D258648A', '051', '문성일', '109', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '049624493773' ) ========================2021-01-06 15:48:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4TOERKK parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A0D37A0A4AD8C2CA84F2 sCDKey = 451277482449 sName = DESKTOP-4TOERKK ========================2021-01-06 15:48:08======================== 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 = '451277482449' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-06 15:51:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4TOERKK parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A0D37A0A4AD8C2CA84F2 sCDKey = 415277482449 sName = DESKTOP-4TOERKK ========================2021-01-06 15:51: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 = '415277482449' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-06 15:51:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xjql7' ========================2021-01-06 15:51:07======================== SELECT idx FROM macs WHERE mac_addr = 'A0D37A0A4AD8C2CA84F2' AND app_code = '039' ========================2021-01-06 15:51:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331449' ========================2021-01-06 15:51:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331449' ========================2021-01-06 15:51: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 ( '331449', 'A0D37A0A4AD8C2CA84F2', '039', 'DESKTOP-4TOERKK', '110', '1366', '768', 'xjql7', '제일물류[복석만]', '415277482449' )