========================2020-06-21 13:40:28======================== 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 = 9C5C8EC165F6B892F586 sCDKey = 108094650671 sName = USER-PC ========================2020-06-21 13:40: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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-21 13:40:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2020-06-21 13:40:29======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8EC165F6B892F586' AND app_code = '046' ========================2020-06-21 13:40:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238082' ========================2020-06-21 13:40:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238082' ========================2020-06-21 13:40:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238082', '9C5C8EC165F6B892F586', '046', 'USER-PC', '90', '1024', '768', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2020-06-21 14:04:00======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 7085C2338557B892F586 sCDKey = 108094650671 sName = USER-PC ========================2020-06-21 14:04:00======================== 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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-21 14:04:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2020-06-21 14:04:00======================== SELECT idx FROM macs WHERE mac_addr = '7085C2338557B892F586' AND app_code = '046' ========================2020-06-21 14:04:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320102' ========================2020-06-21 14:04:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320102' ========================2020-06-21 14:04:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320102', '7085C2338557B892F586', '046', 'USER-PC', '90', '1280', '1024', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2020-06-21 15:59:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-3S0TB8O parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D4C422316EA843A84C sCDKey = 108094650671 sName = DESKTOP-3S0TB8O ========================2020-06-21 15:59:58======================== 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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-21 15:59:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2020-06-21 15:59:58======================== SELECT idx FROM macs WHERE mac_addr = '04D4C422316EA843A84C' AND app_code = '046' ========================2020-06-21 15:59:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320108' ========================2020-06-21 15:59:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320108' ========================2020-06-21 15:59:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320108', '04D4C422316EA843A84C', '046', 'DESKTOP-3S0TB8O', '110', '1920', '1080', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2020-06-21 20:33:53======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JIUF03A parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 0C9D9282AFC824C2F496 sCDKey = 108094650671 sName = DESKTOP-JIUF03A ========================2020-06-21 20:33:53======================== 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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-21 20:33:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2020-06-21 20:33:53======================== SELECT idx FROM macs WHERE mac_addr = '0C9D9282AFC824C2F496' AND app_code = '046' ========================2020-06-21 20:33:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320126' ========================2020-06-21 20:33:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320126' ========================2020-06-21 20:33:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320126', '0C9D9282AFC824C2F496', '046', 'DESKTOP-JIUF03A', '110', '1440', '900', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2020-06-21 20:35:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-TGE1NDF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C5C8E8542382CE36E2B sCDKey = 108094650671 sName = DESKTOP-TGE1NDF ========================2020-06-21 20:35: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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-21 20:35:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2020-06-21 20:35:03======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E8542382CE36E2B' AND app_code = '046' ========================2020-06-21 20:35:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320125' ========================2020-06-21 20:35:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320125' ========================2020-06-21 20:35: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 ( '320125', '9C5C8E8542382CE36E2B', '046', 'DESKTOP-TGE1NDF', '110', '1920', '1080', 'a09sang', '(주)거상[장동익]', '108094650671' )