========================2021-05-14 12:01:16======================== noteurl_start parm_app_code = 048 parm_pc_name = 3번PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DC6D4E0E960714 sCDKey = 434133617514 sName = 3번PC ========================2021-05-14 12:01: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-14 12:01:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2021-05-14 12:01:16======================== SELECT idx FROM macs WHERE mac_addr = '988389DC6D4E0E960714' AND app_code = '048' ========================2021-05-14 12:01:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281844' ========================2021-05-14 12:01:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281844' ========================2021-05-14 12:01:16======================== UPDATE mac_detail SET pc_name = '3번PC', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '281844' ========================2021-05-14 13:53:33======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4DUGL72 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 80325345407580D5A172 sCDKey = 406364078068 sName = DESKTOP-4DUGL72 ========================2021-05-14 13:53:33======================== 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 = '406364078068' AND r.app_code = '047' AND r.app_block = 0 ========================2021-05-14 13:53:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'beriche' ========================2021-05-14 13:53:33======================== SELECT idx FROM macs WHERE mac_addr = '80325345407580D5A172' AND app_code = '047' ========================2021-05-14 13:53:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343366' ========================2021-05-14 13:53:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343366' ========================2021-05-14 13:53:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '343366', '80325345407580D5A172', '047', 'DESKTOP-4DUGL72', '�쐢�룄�슦 10', '0', '0', 'beriche', '제이엠인터네셔널[배광혜]', '406364078068' ) ========================2021-05-14 14:03:51======================== noteurl_start parm_app_code = 048 parm_pc_name = 1F2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E900225034AB5220 sCDKey = 434133617514 sName = 1F2 ========================2021-05-14 14:03: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-14 14:03:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2021-05-14 14:03:51======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E900225034AB5220' AND app_code = '048' ========================2021-05-14 14:03:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304024' ========================2021-05-14 14:03:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304024' ========================2021-05-14 14:03:51======================== UPDATE mac_detail SET pc_name = '1F2', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '304024' ========================2021-05-14 14:04:11======================== noteurl_start parm_app_code = 048 parm_pc_name = 1F2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E900225034AB5220 sCDKey = 434133617514 sName = 1F2 ========================2021-05-14 14:04:11======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-05-14 14:04:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2021-05-14 14:04:11======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E900225034AB5220' AND app_code = '048' ========================2021-05-14 14:04:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304024' ========================2021-05-14 14:04:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304024' ========================2021-05-14 14:04:11======================== UPDATE mac_detail SET pc_name = '1F2', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '304024' ========================2021-05-14 14:19:06======================== noteurl_start parm_app_code = 046 parm_pc_name = ANNA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E4C291AEB sCDKey = 755061866111 sName = ANNA ========================2021-05-14 14:19:06======================== 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 = '755061866111' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-14 14:19:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyein1127' ========================2021-05-14 14:19:06======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E4C291AEB' AND app_code = '046' ========================2021-05-14 14:19:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343374' ========================2021-05-14 14:19:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343374' ========================2021-05-14 14:19:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '343374', 'F44D30B9AF0E4C291AEB', '046', 'ANNA', '110', '1920', '1080', 'hyein1127', '[황혜인]', '755061866111' )