========================2020-03-26 15:14:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7HO8QM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99901E9CBE44694C sCDKey = 935851285112 sName = DESKTOP-L7HO8QM ========================2020-03-26 15:14:46======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-26 15:14:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2020-03-26 15:14:46======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99901E9CBE44694C' AND app_code = '039' ========================2020-03-26 15:14:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294609' ========================2020-03-26 15:14:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294609' ========================2020-03-26 15:14:46======================== UPDATE mac_detail SET pc_name = 'DESKTOP-L7HO8QM', os_type = '110', user_id = 'unifoodkorea', user_name = '유니푸드텍[변차환]', screen_w = '1920', screen_h = '1080', cdkey = '935851285112' WHERE mac_idx = '294609' ========================2020-03-26 16:07:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DMJFICL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8975A02748E1EC42998 sCDKey = 567805507374 sName = DESKTOP-DMJFICL ========================2020-03-26 16:07:02======================== 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 = '567805507374' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-26 16:07:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ltwotin' ========================2020-03-26 16:07:03======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A02748E1EC42998' AND app_code = '039' ========================2020-03-26 16:07:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313940' ========================2020-03-26 16:07:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313940' ========================2020-03-26 16:07:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313940', 'B8975A02748E1EC42998', '039', 'DESKTOP-DMJFICL', '110', '1920', '1080', 'ltwotin', '규림금속열처리[이석희]', '567805507374' ) ========================2020-03-26 16:44:12======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GKEDM91 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6B38098C17A2D2 sCDKey = 456598299780 sName = DESKTOP-GKEDM91 ========================2020-03-26 16:44:12======================== 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 = '456598299780' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-26 16:55:28======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GKEDM91 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6B38098C17A2D2 sCDKey = 871701488798 sName = DESKTOP-GKEDM91 ========================2020-03-26 16:55: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 = '871701488798' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-26 16:57:27======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GKEDM91 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6B38098C17A2D2 sCDKey = 871701488798 sName = DESKTOP-GKEDM91 ========================2020-03-26 16:57:27======================== 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 = '871701488798' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-26 16:58:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GKEDM91 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6B38098C17A2D2 sCDKey = 871701488798 sName = DESKTOP-GKEDM91 ========================2020-03-26 16:58: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 = '871701488798' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-26 16:58:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youngnim0902' ========================2020-03-26 16:58:40======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6B38098C17A2D2' AND app_code = '046' ========================2020-03-26 16:58:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313955' ========================2020-03-26 16:58:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313955' ========================2020-03-26 16:58:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313955', 'E8039A6B38098C17A2D2', '046', 'DESKTOP-GKEDM91', '110', '1920', '1080', 'youngnim0902', '영신공구[최병욱]', '871701488798' )