========================2019-11-12 09:09:43======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2019-11-12 09:09:43======================== 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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 09:09:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2019-11-12 09:09:43======================== SELECT idx FROM macs WHERE mac_addr = 'C83A35C8BE74846BB25F' AND app_code = '039' ========================2019-11-12 09:09:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284851' ========================2019-11-12 09:09:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '284851' ========================2019-11-12 09:09:43======================== UPDATE mac_detail SET pc_name = 'OFFICE-PC', os_type = '110', user_id = 'sunjin677', user_name = '선진FS[김형희]', screen_w = '1280', screen_h = '1024', cdkey = '217223037343' WHERE mac_idx = '284851' ========================2019-11-12 09:09:51======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2019-11-12 09:09:51======================== 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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 13:57:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-P0HOJVF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 80E82C2F03374E0D03A2 sCDKey = 887299034147 sName = DESKTOP-P0HOJVF ========================2019-11-12 13:57: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 = '887299034147' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 13:57:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'beejoelec' ========================2019-11-12 13:57:47======================== SELECT idx FROM macs WHERE mac_addr = '80E82C2F03374E0D03A2' AND app_code = '039' ========================2019-11-12 13:57:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302621' ========================2019-11-12 13:57:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302621' ========================2019-11-12 13:57: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 ( '302621', '80E82C2F03374E0D03A2', '039', 'DESKTOP-P0HOJVF', '110', '1920', '1080', 'beejoelec', '(주)비조전자[서이택]', '887299034147' ) ========================2019-11-12 16:06:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NILR1SD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D508332FD32B9 sCDKey = 584082333081 sName = DESKTOP-NILR1SD ========================2019-11-12 16:06:13======================== 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 = '584082333081' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 16:06:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NILR1SD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D508332FD32B9 sCDKey = 584082333081 sName = DESKTOP-NILR1SD ========================2019-11-12 16:06:21======================== 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 = '584082333081' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 16:06:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NILR1SD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D508332FD32B9 sCDKey = 584082333081 sName = 상동기업 ========================2019-11-12 16:06: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 = '584082333081' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 16:11:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NILR1SD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BCAEC56D508332FD32B9 sCDKey = 584082333082 sName = DESKTOP-NILR1SD ========================2019-11-12 16:11: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 = '584082333082' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 16:11:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dyc913' ========================2019-11-12 16:11:01======================== SELECT idx FROM macs WHERE mac_addr = 'BCAEC56D508332FD32B9' AND app_code = '039' ========================2019-11-12 16:11:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302607' ========================2019-11-12 16:11:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302607' ========================2019-11-12 16:11:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302607', 'BCAEC56D508332FD32B9', '039', 'DESKTOP-NILR1SD', '110', '1920', '1080', 'dyc913', '상동기업[조대연]', '584082333082' ) ========================2019-11-12 17:57:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3LM9B8U parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C7A734FA093374F sCDKey = 788679587839 sName = DESKTOP-3LM9B8U ========================2019-11-12 17:57:18======================== 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 = '788679587839' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-12 17:57:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'iya0248' ========================2019-11-12 17:57:18======================== SELECT idx FROM macs WHERE mac_addr = '408D5C7A734FA093374F' AND app_code = '039' ========================2019-11-12 17:57:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302647' ========================2019-11-12 17:57:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302647' ========================2019-11-12 17:57:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302647', '408D5C7A734FA093374F', '039', 'DESKTOP-3LM9B8U', '110', '1920', '1080', 'iya0248', '인스모어(쁘띠모)[인윤애]', '788679587839' )