========================2018-12-06 09:19:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 050055057943 sName = DESKTOP-IHIELAL ========================2018-12-06 09:19:30======================== 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 = '050055057943' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-06 09:20:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-06 09:20:04======================== 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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-06 09:20:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shinds02' ========================2018-12-06 09:20:04======================== SELECT idx FROM macs WHERE mac_addr = '88366CF09F90F85E5384' AND app_code = '039' ========================2018-12-06 09:20:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269938' ========================2018-12-06 09:20:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269938' ========================2018-12-06 09: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 ( '269938', '88366CF09F90F85E5384', '039', 'DESKTOP-IHIELAL', '110', '1680', '1050', 'shinds02', '케이디양행[신동석]', '055057943414' ) ========================2018-12-06 09:20:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-06 09:20: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-06 09:20:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-06 09:20: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-06 11:22:43======================== noteurl_start parm_app_code = 046 parm_pc_name = SC-201708121532 parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A8D1201C48B1860 sCDKey = 942191088735 sName = SC-201708121532 ========================2018-12-06 11:22: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 = '942191088735' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-06 11:46:33======================== noteurl_start parm_app_code = 050 parm_pc_name = LYS-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 319376169963 sName = LYS-PC ========================2018-12-06 11:46: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 = '319376169963' AND r.app_code = '050' AND r.app_block = 0 ========================2018-12-06 11:46:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-06 11:46:33======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '050' ========================2018-12-06 11:46:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270078' ========================2018-12-06 11:46:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270078' ========================2018-12-06 11:46: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 ( '270078', '0030676B307C92E57388', '050', 'LYS-PC', '109', '1920', '1080', 'lys0121', '[이윤솔]', '319376169963' ) ========================2018-12-06 16:09:01======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CPCC4US parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C913FBD437AE5E77BB sCDKey = 069675455873 sName = DESKTOP-CPCC4US ========================2018-12-06 16:09: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 = '069675455873' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-06 16:09:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mailo7' ========================2018-12-06 16:09:01======================== SELECT idx FROM macs WHERE mac_addr = '14C913FBD437AE5E77BB' AND app_code = '046' ========================2018-12-06 16:09:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270121' ========================2018-12-06 16:09:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270121' ========================2018-12-06 16:09: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 ( '270121', '14C913FBD437AE5E77BB', '046', 'DESKTOP-CPCC4US', '110', '1920', '1080', 'mailo7', '송영훈[송영훈]', '069675455873' )