========================2020-08-21 11:07:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-23HUGFB parm_os_type = 110 parm_screen_w = 1400 parm_screen_h = 1050 parm_user_mac = 001377C9D85CF055D7 sCDKey = 130155113225 sName = DESKTOP-23HUGFB ========================2020-08-21 11:07:16======================== 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 = '130155113225' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-21 11:07:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lsb9804' ========================2020-08-21 11:07:16======================== SELECT idx FROM macs WHERE mac_addr = '001377C9D85CF055D7' AND app_code = '039' ========================2020-08-21 11:07:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324464' ========================2020-08-21 11:07:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324464' ========================2020-08-21 11:07:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '324464', '001377C9D85CF055D7', '039', 'DESKTOP-23HUGFB', '110', '1400', '1050', 'lsb9804', '이원테크[이은순]', '130155113225' ) ========================2020-08-21 11:22:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-K88LQM4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E3B3924E636348 sCDKey = 009830290223 sName = DESKTOP-K88LQM4 ========================2020-08-21 11:22: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 = '009830290223' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-21 11:22:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyy0424' ========================2020-08-21 11:22:49======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99E3B3924E636348' AND app_code = '039' ========================2020-08-21 11:22:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324457' ========================2020-08-21 11:22:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324457' ========================2020-08-21 11:22: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 ( '324457', 'B42E99E3B3924E636348', '039', 'DESKTOP-K88LQM4', '110', '1920', '1080', 'kyy0424', '미래특수고무[정경애]', '009830290223' ) ========================2020-08-21 11:22:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-K88LQM4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E3B3924E636348 sCDKey = 009830290223 sName = DESKTOP-K88LQM4 ========================2020-08-21 11:22:51======================== 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 = '009830290223' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-21 13:55:18======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-ET2U1C6 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 34415D017BB06E67003F sCDKey = 413363772239 sName = DESKTOP-ET2U1C6 ========================2020-08-21 13:55: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 = '413363772239' AND r.app_code = '045' AND r.app_block = 0 ========================2020-08-21 13:55:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gwangrim' ========================2020-08-21 13:55:18======================== SELECT idx FROM macs WHERE mac_addr = '34415D017BB06E67003F' AND app_code = '045' ========================2020-08-21 13:55:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '324482' ========================2020-08-21 13:55:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '324482' ========================2020-08-21 13:55: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 ( '324482', '34415D017BB06E67003F', '045', 'DESKTOP-ET2U1C6', '110', '1536', '864', 'gwangrim', '광림장갑[김규휴]', '413363772239' ) ========================2020-08-21 17:42:38======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-A402 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99DAFF3F16AE9BEF sCDKey = 625904807748 sName = COM-A402 ========================2020-08-21 17:42:38======================== 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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-21 17:42:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gkswls1212' ========================2020-08-21 17:42:38======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99DAFF3F16AE9BEF' AND app_code = '039' ========================2020-08-21 17:42:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323814' ========================2020-08-21 17:42:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323814' ========================2020-08-21 17:42:38======================== UPDATE mac_detail SET pc_name = 'COM-A402', os_type = '110', user_id = 'gkswls1212', user_name = '(주)에스제이로지스틱스[이재민]', screen_w = '1920', screen_h = '1080', cdkey = '625904807748' WHERE mac_idx = '323814' ========================2020-08-21 17:42:45======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-A402 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99DAFF3F16AE9BEF sCDKey = 625904807748 sName = COM-A402 ========================2020-08-21 17:42:45======================== 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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0