========================2021-11-11 14:36:20======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN10 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00D861BF86B9C60D7AF sCDKey = 398348232074 sName = WIN10 ========================2021-11-11 14:36: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 = '398348232074' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-11 14:36:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeng' ========================2021-11-11 14:36:20======================== SELECT idx FROM macs WHERE mac_addr = '00D861BF86B9C60D7AF' AND app_code = '039' ========================2021-11-11 14:36:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345713' ========================2021-11-11 14:36:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345713' ========================2021-11-11 14:36:20======================== UPDATE mac_detail SET pc_name = 'WIN10', os_type = '110', user_id = 'jeng', user_name = '정은전열ENG[박용은]', screen_w = '1920', screen_h = '1080', cdkey = '398348232074' WHERE mac_idx = '345713' ========================2021-11-11 14:59:54======================== noteurl_start parm_app_code = 047 parm_pc_name = COM-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A51B1FA1CE7315A sCDKey = 718475474074 sName = COM-PC ========================2021-11-11 14:59:54======================== 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 = '718475474074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-11 14:59:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onejinro' ========================2021-11-11 14:59:54======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A51B1FA1CE7315A' AND app_code = '047' ========================2021-11-11 14:59:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302787' ========================2021-11-11 14:59:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302787' ========================2021-11-11 14:59:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '302787', 'B8975A51B1FA1CE7315A', '047', 'COM-PC', '�쐢�룄�슦 7', '0', '0', 'onejinro', '원푸드코퍼레이션[정태건]', '718475474074' ) ========================2021-11-11 15:00:01======================== noteurl_start parm_app_code = 047 parm_pc_name = COM-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A51B1FA1CE7315A sCDKey = 718475474074 sName = COM-PC ========================2021-11-11 15:00: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 = '718475474074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-11 15:01:22======================== noteurl_start parm_app_code = 047 parm_pc_name = COM-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A51B1FA1CE7315A sCDKey = 718475474074 sName = COM-PC ========================2021-11-11 15:01:22======================== 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 = '718475474074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-11 15:01:49======================== noteurl_start parm_app_code = 047 parm_pc_name = COM-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975A51B1FA1CE7315A sCDKey = 718475474074 sName = COM-PC ========================2021-11-11 15:01:49======================== 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 = '718475474074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-11 19:23:33======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04CB2420BE4C8F79C sCDKey = 514408383029 sName = POS-PC ========================2021-11-11 19:23: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 = '514408383029' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-11 19:23:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'afac0709' ========================2021-11-11 19:23:33======================== SELECT idx FROM macs WHERE mac_addr = '00E04CB2420BE4C8F79C' AND app_code = '046' ========================2021-11-11 19:23:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '354414' ========================2021-11-11 19:23:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '354414' ========================2021-11-11 19:23:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '354414', '00E04CB2420BE4C8F79C', '046', 'POS-PC', '110', '1024', '768', 'afac0709', '에이팩(afac)[김두현]', '514408383029' )