========================2021-02-24 09:09:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-G27653D parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 04D9F5CF9E26802111E7 sCDKey = 015250734460 sName = DESKTOP-G27653D ========================2021-02-24 09:09: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 = '015250734460' AND r.app_code = '046' AND r.app_block = 0 ========================2021-02-24 09:09:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'marn2000' ========================2021-02-24 09:09:40======================== SELECT idx FROM macs WHERE mac_addr = '04D9F5CF9E26802111E7' AND app_code = '046' ========================2021-02-24 09:09:40======================== 값이 없을 경우 ========================2021-02-24 09:10:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-G27653D parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 04D9F5CF9E26802111E7 sCDKey = 015250734460 sName = DESKTOP-G27653D ========================2021-02-24 09:10: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 = '015250734460' AND r.app_code = '046' AND r.app_block = 0 ========================2021-02-24 09:10:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'marn2000' ========================2021-02-24 09:10:55======================== SELECT idx FROM macs WHERE mac_addr = '04D9F5CF9E26802111E7' AND app_code = '046' ========================2021-02-24 09:10:55======================== 값이 없을 경우 ========================2021-02-24 09:24:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-G27653D parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 04D9F5CF9E26802111E7 sCDKey = 015250734460 sName = DESKTOP-G27653D ========================2021-02-24 09:24: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 = '015250734460' AND r.app_code = '046' AND r.app_block = 0 ========================2021-02-24 09:24:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'marn2000' ========================2021-02-24 09:24:22======================== SELECT idx FROM macs WHERE mac_addr = '04D9F5CF9E26802111E7' AND app_code = '046' ========================2021-02-24 09:24:22======================== 값이 없을 경우 ========================2021-02-24 09:27:49======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-G27653D parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 04D9F5CF9E26802111E7 sCDKey = 015250734460 sName = DESKTOP-G27653D ========================2021-02-24 09:27: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 = '015250734460' AND r.app_code = '046' AND r.app_block = 0 ========================2021-02-24 09:27:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'marn2000' ========================2021-02-24 09:27:50======================== SELECT idx FROM macs WHERE mac_addr = '04D9F5CF9E26802111E7' AND app_code = '046' ========================2021-02-24 09:27:50======================== 값이 없을 경우 ========================2021-02-24 13:30:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9BF5I3D parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 40167E6A51A7C2967488 sCDKey = 136293622773 sName = DESKTOP-9BF5I3D ========================2021-02-24 13:30:17======================== 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 = '136293622773' AND r.app_code = '039' AND r.app_block = 0 ========================2021-02-24 13:33:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9BF5I3D parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 40167E6A51A7C2967488 sCDKey = 136293622773 sName = DESKTOP-9BF5I3D ========================2021-02-24 13:33: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 = '136293622773' AND r.app_code = '039' AND r.app_block = 0 ========================2021-02-24 13:34:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9BF5I3D parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 40167E6A51A7C2967488 sCDKey = 136293622773 sName = DESKTOP-9BF5I3D ========================2021-02-24 13:34: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 = '136293622773' AND r.app_code = '039' AND r.app_block = 0 ========================2021-02-24 13:34:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnangel' ========================2021-02-24 13:34:01======================== SELECT idx FROM macs WHERE mac_addr = '40167E6A51A7C2967488' AND app_code = '039' ========================2021-02-24 13:34:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337686' ========================2021-02-24 13:34:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '337686' ========================2021-02-24 13:34: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 ( '337686', '40167E6A51A7C2967488', '039', 'DESKTOP-9BF5I3D', '110', '1920', '1080', 'dnangel', '광일박스[고광일]', '136293622773' ) ========================2021-02-24 14:20:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DH5LCJU parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = F46D04066D564C6BA080 sCDKey = 467616826757 sName = DESKTOP-DH5LCJU ========================2021-02-24 14:20:03======================== 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 = '467616826757' AND r.app_code = '039' AND r.app_block = 0 ========================2021-02-24 14:20:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjvj2558' ========================2021-02-24 14:20:04======================== SELECT idx FROM macs WHERE mac_addr = 'F46D04066D564C6BA080' AND app_code = '039' ========================2021-02-24 14:20:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337088' ========================2021-02-24 14:20:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '337088' ========================2021-02-24 14:20:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '337088', 'F46D04066D564C6BA080', '039', 'DESKTOP-DH5LCJU', '110', '1024', '768', 'jjvj2558', '오산현대아크릴[정영자]', '467616826757' )