========================2020-04-16 01:38:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BL6DV4U parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E4B97A79D05EAC144B37 sCDKey = 422114683375 sName = DESKTOP-BL6DV4U ========================2020-04-16 01:38: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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-16 11:45:55======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-B8JEQON parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99AD22658C3A8800 sCDKey = 381943393149 sName = DESKTOP-B8JEQON ========================2020-04-16 11:45:55======================== 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 = '381943393149' AND r.app_code = '045' AND r.app_block = 0 ========================2020-04-16 11:45:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'guyoung1030' ========================2020-04-16 11:45:55======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99AD22658C3A8800' AND app_code = '045' ========================2020-04-16 11:45:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315558' ========================2020-04-16 11:45:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315558' ========================2020-04-16 11:45:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315558', 'B42E99AD22658C3A8800', '045', 'DESKTOP-B8JEQON', '110', '1920', '1080', 'guyoung1030', '(주)봉농[정구영]', '381943393149' ) ========================2020-04-16 12:15:16======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 803253F4639D6DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2020-04-16 12:15: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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-16 12:15:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-04-16 12:15:16======================== SELECT idx FROM macs WHERE mac_addr = '803253F4639D6DBC9E9' AND app_code = '046' ========================2020-04-16 12:15:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312854' ========================2020-04-16 12:15:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312854' ========================2020-04-16 12:15:16======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '312854' ========================2020-04-16 13:26:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-483VOLS parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E4E7493370FB8A50187 sCDKey = 864474075712 sName = DESKTOP-483VOLS ========================2020-04-16 13:26: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 = '864474075712' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-16 13:26:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljp4640162' ========================2020-04-16 13:26:00======================== SELECT idx FROM macs WHERE mac_addr = 'E4E7493370FB8A50187' AND app_code = '039' ========================2020-04-16 13:26:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '309433' ========================2020-04-16 13:26:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '309433' ========================2020-04-16 13:26:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '309433', 'E4E7493370FB8A50187', '039', 'DESKTOP-483VOLS', '110', '1280', '1024', 'ljp4640162', '명동전기[이재필]', '864474075712' ) ========================2020-04-16 15:45:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BL6DV4U parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 48F17F00E079AC144B37 sCDKey = 422114683375 sName = DESKTOP-BL6DV4U ========================2020-04-16 15:45:28======================== 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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-16 15:45:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2020-04-16 15:45:28======================== SELECT idx FROM macs WHERE mac_addr = '48F17F00E079AC144B37' AND app_code = '039' ========================2020-04-16 15:45:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315579' ========================2020-04-16 15:45:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315579' ========================2020-04-16 15:45:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315579', '48F17F00E079AC144B37', '039', 'DESKTOP-BL6DV4U', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' ) ========================2020-04-16 16:08:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SPRDIUB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 704D7B2EEE2C4A23CD3B sCDKey = 116466244096 sName = DESKTOP-SPRDIUB ========================2020-04-16 16:08: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 = '116466244096' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-16 16:08:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kpbox1' ========================2020-04-16 16:08:14======================== SELECT idx FROM macs WHERE mac_addr = '704D7B2EEE2C4A23CD3B' AND app_code = '039' ========================2020-04-16 16:08:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315585' ========================2020-04-16 16:08:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315585' ========================2020-04-16 16:08: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 ( '315585', '704D7B2EEE2C4A23CD3B', '039', 'DESKTOP-SPRDIUB', '110', '1920', '1080', 'kpbox1', '근풍실업[김혜숙]', '116466244096' )