========================2018-01-12 09:37: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 = E0D55E36D988F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-01-12 09:37: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-01-12 09:37:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shinds02' ========================2018-01-12 09:37:47======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E36D988F85E5384' AND app_code = '039' ========================2018-01-12 09:37:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239074' ========================2018-01-12 09:37:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239074' ========================2018-01-12 09:37: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 ( '239074', 'E0D55E36D988F85E5384', '039', 'DESKTOP-IHIELAL', '110', '1680', '1050', 'shinds02', '케이디양행[신동석]', '055057943414' ) ========================2018-01-12 09:57:59======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-DBSJ7RA4LCA parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 1024 parm_user_mac = 001E903C83D3EC6F1AC7 sCDKey = 409302069782 sName = WIN-DBSJ7RA4LCA ========================2018-01-12 09:57:59======================== 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 = '409302069782' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-12 09:57:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs529' ========================2018-01-12 09:57:59======================== SELECT idx FROM macs WHERE mac_addr = '001E903C83D3EC6F1AC7' AND app_code = '046' ========================2018-01-12 09:57:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239095' ========================2018-01-12 09:57:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239095' ========================2018-01-12 09:57:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239095', '001E903C83D3EC6F1AC7', '046', 'WIN-DBSJ7RA4LCA', '90', '1600', '1024', 'bs529', '산들식품[부산지사]', '409302069782' ) ========================2018-01-12 10:39:42======================== noteurl_start parm_app_code = 039 parm_pc_name = POWER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CFDA15845816D84F6A sCDKey = 839995124602 sName = POWER-PC ========================2018-01-12 10:39:42======================== 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 = '839995124602' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-12 10:39:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gkehdauddl' ========================2018-01-12 10:39:42======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15845816D84F6A' AND app_code = '039' ========================2018-01-12 10:39:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239100' ========================2018-01-12 10:39:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239100' ========================2018-01-12 10:39:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239100', '2CFDA15845816D84F6A', '039', 'POWER-PC', '90', '1920', '1080', 'gkehdauddl', '삼성ENG[장윤순]', '839995124602' ) ========================2018-01-12 11:41:22======================== noteurl_start parm_app_code = 039 parm_pc_name = KDH-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80DC083F54DC04CA sCDKey = 336363617204 sName = KDH-PC ========================2018-01-12 11:41: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 = '336363617204' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-12 11:41:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hsj112200' ========================2018-01-12 11:41:22======================== SELECT idx FROM macs WHERE mac_addr = '94DE80DC083F54DC04CA' AND app_code = '039' ========================2018-01-12 11:41:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239109' ========================2018-01-12 11:41:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239109' ========================2018-01-12 11:41:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239109', '94DE80DC083F54DC04CA', '039', 'KDH-PC', '90', '1920', '1080', 'hsj112200', '(주)새닢[하수정]', '336363617204' ) ========================2018-01-12 13:47:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3ENMOFT parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981B7F5B8374F2D sCDKey = 021082300495 sName = DESKTOP-3ENMOFT ========================2018-01-12 13:47:25======================== 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 = '021082300495' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-12 13:47:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yujin6735' ========================2018-01-12 13:47:25======================== SELECT idx FROM macs WHERE mac_addr = '98838981B7F5B8374F2D' AND app_code = '039' ========================2018-01-12 13:47:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239134' ========================2018-01-12 13:47:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239134' ========================2018-01-12 13:47:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239134', '98838981B7F5B8374F2D', '039', 'DESKTOP-3ENMOFT', '110', '1920', '1080', 'yujin6735', '유진금속[유재창]', '021082300495' ) ========================2018-01-12 14:25:07======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732A6826A41C65F sCDKey = 409302069782 sName = USER-PC ========================2018-01-12 14:25:07======================== 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 = '409302069782' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-12 14:25:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs529' ========================2018-01-12 14:25:07======================== SELECT idx FROM macs WHERE mac_addr = '50AF732A6826A41C65F' AND app_code = '046' ========================2018-01-12 14:25:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239140' ========================2018-01-12 14:25:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239140' ========================2018-01-12 14:25:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239140', '50AF732A6826A41C65F', '046', 'USER-PC', '90', '1024', '768', 'bs529', '산들식품[부산지사]', '409302069782' ) ========================2018-01-12 14:35:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6SBJSHL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E530679B4B76257 sCDKey = 533364286570 sName = DESKTOP-6SBJSHL ========================2018-01-12 14:35:11======================== 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 = '533364286570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-12 14:35:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'uksung1966' ========================2018-01-12 14:35:11======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E530679B4B76257' AND app_code = '039' ========================2018-01-12 14:35:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239142' ========================2018-01-12 14:35:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239142' ========================2018-01-12 14:35:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239142', 'E0D55E530679B4B76257', '039', 'DESKTOP-6SBJSHL', '110', '1920', '1080', 'uksung1966', '욱성화학공업사[이성춘]', '533364286570' )