========================2021-08-18 10:07:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DS1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99D5AB4E903BAF56 sCDKey = 854339586637 sName = DS1 ========================2021-08-18 10:07:08======================== 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 = '854339586637' AND r.app_code = '039' AND r.app_block = 0 ========================2021-08-18 10:07:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds8445' ========================2021-08-18 10:07:08======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99D5AB4E903BAF56' AND app_code = '039' ========================2021-08-18 10:07:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341438' ========================2021-08-18 10:07:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341438' ========================2021-08-18 10:07:08======================== UPDATE mac_detail SET pc_name = 'DS1', os_type = '110', user_id = 'ds8445', user_name = '(주)대신분체산업[조영구]', screen_w = '1920', screen_h = '1080', cdkey = '854339586637' WHERE mac_idx = '341438' ========================2021-08-18 13:25:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-139RIM3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04DDA5D3E5E7CAD9C sCDKey = 492519440565 sName = DESKTOP-139RIM3 ========================2021-08-18 13:25:09======================== 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 = '492519440565' AND r.app_code = '039' AND r.app_block = 0 ========================2021-08-18 13:25:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skh9927' ========================2021-08-18 13:25:09======================== SELECT idx FROM macs WHERE mac_addr = '18C04DDA5D3E5E7CAD9C' AND app_code = '039' ========================2021-08-18 13:25:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '349419' ========================2021-08-18 13:25:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '349419' ========================2021-08-18 13:25:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '349419', '18C04DDA5D3E5E7CAD9C', '039', 'DESKTOP-139RIM3', '110', '1920', '1080', 'skh9927', '(유)오식도물류[신경호]', '492519440565' ) ========================2021-08-18 14:39:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PS0UAD3 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 1024 parm_user_mac = D85ED31C20CD9A72ACEF sCDKey = 420380571543 sName = DESKTOP-PS0UAD3 ========================2021-08-18 14:39: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 = '420380571543' AND r.app_code = '039' AND r.app_block = 0 ========================2021-08-18 14:39:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eoehd2658' ========================2021-08-18 14:39:17======================== SELECT idx FROM macs WHERE mac_addr = 'D85ED31C20CD9A72ACEF' AND app_code = '039' ========================2021-08-18 14:39:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '349425' ========================2021-08-18 14:39:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '349425' ========================2021-08-18 14:39:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '349425', 'D85ED31C20CD9A72ACEF', '039', 'DESKTOP-PS0UAD3', '110', '1600', '1024', 'eoehd2658', '대동강한복[박진철]', '420380571543' ) ========================2021-08-18 15:33:18======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-49INSVC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B34D612D3A85D9A82 sCDKey = 642999978100 sName = DESKTOP-49INSVC ========================2021-08-18 15:33:18======================== 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 = '642999978100' AND r.app_code = '046' AND r.app_block = 0 ========================2021-08-18 15:33:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rg7737' ========================2021-08-18 15:33:18======================== SELECT idx FROM macs WHERE mac_addr = '902B34D612D3A85D9A82' AND app_code = '046' ========================2021-08-18 15:33:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347398' ========================2021-08-18 15:33:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347398' ========================2021-08-18 15:33:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '347398', '902B34D612D3A85D9A82', '046', 'DESKTOP-49INSVC', '110', '1920', '1080', 'rg7737', '알지협동조합[김제정]', '642999978100' ) ========================2021-08-18 22:44:49======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-20210724JTZ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDAC7115623D9DCC sCDKey = 788677716775 sName = COM-20210724JTZ ========================2021-08-18 22:44: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 = '788677716775' AND r.app_code = '039' AND r.app_block = 0 ========================2021-08-18 22:44:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'soccerarmani' ========================2021-08-18 22:44:49======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDAC7115623D9DCC' AND app_code = '039' ========================2021-08-18 22:44:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348446' ========================2021-08-18 22:44:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348446' ========================2021-08-18 22:44:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '348446', 'B8AEEDAC7115623D9DCC', '039', 'COM-20210724JTZ', '110', '1920', '1080', 'soccerarmani', '성원전자[윤성현]', '788677716775' )