========================2022-09-23 14:51:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 14:51:55======================== 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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 14:51:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ilsinchem' ========================2022-09-23 14:51:55======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFA08C0B459D905' AND app_code = '046' ========================2022-09-23 14:51:55======================== 값이 없을 경우 ========================2022-09-23 14:52:20======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 14:52:20======================== 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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 14:52:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ilsinchem' ========================2022-09-23 14:52:20======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFA08C0B459D905' AND app_code = '046' ========================2022-09-23 14:52:20======================== 값이 없을 경우 ========================2022-09-23 14:55:08======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 14:55: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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 14:55:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ilsinchem' ========================2022-09-23 14:55:08======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFA08C0B459D905' AND app_code = '046' ========================2022-09-23 14:55:08======================== 값이 없을 경우 ========================2022-09-23 14:55:44======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 14:55:44======================== 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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 14:55:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ilsinchem' ========================2022-09-23 14:55:44======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFA08C0B459D905' AND app_code = '046' ========================2022-09-23 14:55:44======================== 값이 없을 경우 ========================2022-09-23 15:12:08======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 15:12: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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 15:12:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ilsinchem' ========================2022-09-23 15:12:08======================== SELECT idx FROM macs WHERE mac_addr = '705DCCFA08C0B459D905' AND app_code = '046' ========================2022-09-23 15:12:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '374017' ========================2022-09-23 15:12:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '374017' ========================2022-09-23 15:12:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '374017', '705DCCFA08C0B459D905', '046', 'DESKTOP-GBVMTM9', '110', '1600', '900', 'ilsinchem', '(주)일신엠알오[허남도]', '643239655302' ) ========================2022-09-23 15:12:23======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 15:12:23======================== 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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 15:12:23======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GBVMTM9 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 705DCCFA08C0B459D905 sCDKey = 643239655302 sName = DESKTOP-GBVMTM9 ========================2022-09-23 15:12:23======================== 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 = '643239655302' AND r.app_code = '046' AND r.app_block = 0 ========================2022-09-23 15:30:23======================== noteurl_start parm_app_code = 039 parm_pc_name = 이지선 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 8CB0E995F0D35C7F55 sCDKey = 544812833775 sName = 이지선 ========================2022-09-23 15:30:23======================== 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 = '544812833775' AND r.app_code = '039' AND r.app_block = 0 ========================2022-09-23 15:30:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dshinn' ========================2022-09-23 15:30:23======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E995F0D35C7F55' AND app_code = '039' ========================2022-09-23 15:30:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '374008' ========================2022-09-23 15:30:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '374008' ========================2022-09-23 15:30:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '374008', '8CB0E995F0D35C7F55', '039', '이지선', '110', '1920', '1200', 'dshinn', '(주)대신적산엔지니어링[이지선]', '544812833775' )