========================2021-09-15 10:08:44======================== noteurl_start parm_app_code = 046 parm_pc_name = KCG-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304C7862A6138453 sCDKey = 348936551094 sName = KCG-PC ========================2021-09-15 10:08: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 = '348936551094' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-15 10:08:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2021-09-15 10:08:44======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '046' ========================2021-09-15 10:08:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '209902' ========================2021-09-15 10:08:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '209902' ========================2021-09-15 10:08:44======================== UPDATE mac_detail SET pc_name = 'KCG-PC', os_type = '110', user_id = 'gyu1001', user_name = '권창규[권창규]', screen_w = '1920', screen_h = '1080', cdkey = '348936551094' WHERE mac_idx = '209902' ========================2021-09-15 11:18:17======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB3E06A5DC0D8 sCDKey = 965870825243 sName = 한동진 ========================2021-09-15 11:18: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 = '965870825243' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-15 11:18:38======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599FB3E06A5DC0D8 sCDKey = 965870825243 sName = 한동진 ========================2021-09-15 11:18: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 = '965870825243' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-15 11:18:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bestseller12' ========================2021-09-15 11:18:38======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06A5DC0D8' AND app_code = '046' ========================2021-09-15 11:18:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '228268' ========================2021-09-15 11:18:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '228268' ========================2021-09-15 11:18:38======================== UPDATE mac_detail SET pc_name = '한동진', os_type = '110', user_id = 'bestseller12', user_name = 'AZ입맛[한동진]', screen_w = '1920', screen_h = '1080', cdkey = '965870825243' WHERE mac_idx = '228268' ========================2021-09-15 16:42:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BTMNCKH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 40167E6673EFFE65940B sCDKey = 092641531677 sName = DESKTOP-BTMNCKH ========================2021-09-15 16:42:56======================== 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 = '092641531677' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-15 16:42:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ehdrnr0' ========================2021-09-15 16:42:56======================== SELECT idx FROM macs WHERE mac_addr = '40167E6673EFFE65940B' AND app_code = '046' ========================2021-09-15 16:42:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '351113' ========================2021-09-15 16:42:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '351113' ========================2021-09-15 16:42:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '351113', '40167E6673EFFE65940B', '046', 'DESKTOP-BTMNCKH', '110', '1920', '1080', 'ehdrnr0', '미래전기조명[안정미]', '092641531677' ) ========================2021-09-15 16:43:01======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BTMNCKH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 40167E6673EFFE65940B sCDKey = 092641531677 sName = DESKTOP-BTMNCKH ========================2021-09-15 16:43:01======================== 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 = '092641531677' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-15 17:52:57======================== noteurl_start parm_app_code = 039 parm_pc_name = 안재윤 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304EC66FD466C7DB sCDKey = 610616659833 sName = 안재윤 ========================2021-09-15 17:52:57======================== 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 = '610616659833' AND r.app_code = '039' AND r.app_block = 0 ========================2021-09-15 17:52:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yun0306' ========================2021-09-15 17:52:57======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304EC66FD466C7DB' AND app_code = '039' ========================2021-09-15 17:52:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '350875' ========================2021-09-15 17:52:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '350875' ========================2021-09-15 17:52:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '350875', 'F44D304EC66FD466C7DB', '039', '안재윤', '110', '1920', '1080', 'yun0306', '[안재윤]', '610616659833' )