========================2020-10-29 09:28:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MB8RSQH parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 002454983413B4A8CB88 sCDKey = 871526571340 sName = DESKTOP-MB8RSQH ========================2020-10-29 09:28: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 = '871526571340' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-29 09:28:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ks518551' ========================2020-10-29 09:28:09======================== SELECT idx FROM macs WHERE mac_addr = '002454983413B4A8CB88' AND app_code = '039' ========================2020-10-29 09:28:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328934' ========================2020-10-29 09:28:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '328934' ========================2020-10-29 09:28: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 ( '328934', '002454983413B4A8CB88', '039', 'DESKTOP-MB8RSQH', '110', '1280', '1024', 'ks518551', '정은주유소[박기상]', '871526571340' ) ========================2020-10-29 12:02:38======================== noteurl_start parm_app_code = 039 parm_pc_name = I-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 4C0F6E670CD2A8026891 sCDKey = 893776793135 sName = I-PC ========================2020-10-29 12:02: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 = '893776793135' AND r.app_code = '039' AND r.app_block = 0 ========================2020-10-29 12:02:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cui190918' ========================2020-10-29 12:02:38======================== SELECT idx FROM macs WHERE mac_addr = '4C0F6E670CD2A8026891' AND app_code = '039' ========================2020-10-29 12:02:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328826' ========================2020-10-29 12:02:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '328826' ========================2020-10-29 12:02:38======================== UPDATE mac_detail SET pc_name = 'I-PC', os_type = '90', user_id = 'cui190918', user_name = '청명[최상만]', screen_w = '1366', screen_h = '768', cdkey = '893776793135' WHERE mac_idx = '328826' ========================2020-10-29 15:29:37======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-86D9ONO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 902B3490AEE96EEAB3B3 sCDKey = 805530970950 sName = DESKTOP-86D9ONO ========================2020-10-29 15:29:37======================== 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 = '805530970950' AND r.app_code = '048' AND r.app_block = 0 ========================2020-10-29 15:30:30======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-86D9ONO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 902B3490AEE96EEAB3B3 sCDKey = 805530970950 sName = DESKTOP-86D9ONO ========================2020-10-29 15:30:30======================== 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 = '805530970950' AND r.app_code = '048' AND r.app_block = 0 ========================2020-10-29 15:30:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'izcom' ========================2020-10-29 15:30:31======================== SELECT idx FROM macs WHERE mac_addr = '902B3490AEE96EEAB3B3' AND app_code = '048' ========================2020-10-29 15:30:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273247' ========================2020-10-29 15:30:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273247' ========================2020-10-29 15:30:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273247', '902B3490AEE96EEAB3B3', '048', 'DESKTOP-86D9ONO', '�쐢�룄�슦 10', '0', '0', 'izcom', '미진소프트앤컴[곽우성]', '805530970950' ) ========================2020-10-29 15:42:04======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-M4BLU9H parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E8039A6C6BC1045AA506 sCDKey = 805530970950 sName = DESKTOP-M4BLU9H ========================2020-10-29 15:42:04======================== 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 = '805530970950' AND r.app_code = '048' AND r.app_block = 0 ========================2020-10-29 15:42:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'izcom' ========================2020-10-29 15:42:04======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6C6BC1045AA506' AND app_code = '048' ========================2020-10-29 15:42:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328933' ========================2020-10-29 15:42:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '328933' ========================2020-10-29 15:42:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '328933', 'E8039A6C6BC1045AA506', '048', 'DESKTOP-M4BLU9H', '�쐢�룄�슦 10', '0', '0', 'izcom', '미진소프트앤컴[곽우성]', '805530970950' )