过滤指定关键字并统计次数

指尖二进制 • 1 年前 • 918 次点击 • BASH

[root@localhost ~]# cat 202402261009.csv
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 04:10:48,212 CRITICAL -139960451569408- handled request [{'status': ['in-use'], 'request_zone': 'region1a', 'verbose': 2, 'zone': 'region1a', 'expires': '2024-02-25T20:11:00Z', 'limit': 100, 'offset': 7100, 'action': 'DescribeNics', 'sender': {'lang': 'en', 'user_id': 'usr-r1hSIuOw', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'usr-r1hSIuOw', 'role': 'global_admin', 'privilege': 6, 'channel': 'api'}}], exec_time is [47.903]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 04:10:30,330 CRITICAL -140562325825280- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '33586', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'offset': '7100', 'status.1': 'in-use', 'version': '1', 'limit': '100', 'signature': 'ZfD3QM0UkE5ySmpKoIjhZusS7k9wgHjhlb2omDBoRBU=', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T20:10:00Z', 'access_key_id': 'NSBRYSAASJICQDMUVKSF'}}], exec_time is [30.042]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 04:00:24,170 CRITICAL -140514317809408- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '48836', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'offset': '26400', 'status.1': 'in-use', 'version': '1', 'limit': '100', 'signature': 'hFAZeHIsK4i3l+Fj24uF1vLuDkPT2dVo4YDC7Iw77jw=', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T19:59:59Z', 'access_key_id': 'NSBRYSAASJICQDMUVKSF'}}], exec_time is [24.620]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 04:00:58,692 CRITICAL -139960997787392- handled request [{'status': ['in-use'], 'request_zone': 'region1a', 'verbose': 2, 'zone': 'region1a', 'expires': '2024-02-25T20:01:24Z', 'limit': 100, 'offset': 26500, 'action': 'DescribeNics', 'sender': {'lang': 'en', 'user_id': 'usr-r1hSIuOw', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'usr-r1hSIuOw', 'role': 'global_admin', 'privilege': 6, 'channel': 'api'}}], exec_time is [34.401]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 04:00:54,258 CRITICAL -140364941870848- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '50490', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'offset': '26500', 'status.1': 'in-use', 'version': '1', 'limit': '100', 'signature': 'X//1gS8aGylayLGHh6uzafGbEI34S7MlaAY1/DJgSBc=', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T20:00:24Z', 'access_key_id': 'NSBRYSAASJICQDMUVKSF'}}], exec_time is [30.044]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 03:55:45,699 CRITICAL -139958840956672- handled request [{'status': ['active'], 'request_zone': 'ecaprodbj1', 'verbose': 1, 'zone': 'region1a', 'expires': '2024-02-25T19:56:15Z', 'limit': 20, 'offset': 360, 'action': 'DescribeLoadBalancers', 'sender': {'lang': 'en', 'user_id': 'boss', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'boss', 'role': 'global_admin', 'privilege': 10, 'channel': 'api'}}], exec_time is [30.218]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 03:55:45,373 CRITICAL -140364933478144- handled request [{'headers': {'remote_addr': '10.0.108.4', 'remote_port': '57716', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '360', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '29a8f61ced89418d86ce152616b7a9da', 'signature': 'F1aTYf7VjLyhVaougBhY3QbYeJ9RF6bKuLmVQIfKn/w=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T19:55:15Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [30.059]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 03:45:31,668 CRITICAL -140513185351424- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '40096', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'offset': '22100', 'status.1': 'in-use', 'version': '1', 'limit': '100', 'signature': 'XO3Fa7QvetQSIwCqzYZ3G7QwGKJKIJCbgURKwxJcSU4=', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T19:45:01Z', 'access_key_id': 'NSBRYSAASJICQDMUVKSF'}}], exec_time is [30.048]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 03:45:45,585 CRITICAL -139958840956672- handled request [{'status': ['in-use'], 'request_zone': 'region1a', 'verbose': 2, 'zone': 'region1a', 'expires': '2024-02-25T19:46:01Z', 'limit': 100, 'offset': 22100, 'action': 'DescribeNics', 'sender': {'lang': 'en', 'user_id': 'usr-r1hSIuOw', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'usr-r1hSIuOw', 'role': 'global_admin', 'privilege': 6, 'channel': 'api'}}], exec_time is [43.778]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 03:30:31,030 CRITICAL -140507330094848- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '41652', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'offset': '6700', 'status.1': 'in-use', 'version': '1', 'limit': '100', 'signature': 'uaQTwSf2URphS6033K/lhYOsQ2zaijOPQw1n/n8FxBI=', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T19:30:00Z', 'access_key_id': 'NSBRYSAASJICQDMUVKSF'}}], exec_time is [30.048]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 03:30:25,185 CRITICAL -140514342987520- handled request [{'headers': {'remote_addr': '10.0.108.4', 'remote_port': '42028', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'reverse': '1', 'zone': 'ecaprodbj1', 'sort_key': 'create_time', 'signature_version': '1', 'api_lang': 'zh-cn', 'offset': '200', 'version': '1', 'limit': '100', 'req_id': 'f8191bc455974adc9da4823dd000f432', 'signature': 'cBWsmjlG7WN7vZUWskLESpgigv4qpJsMqjOTvjRgV1U=', 'action': 'DescribeBaremetals', 'time_stamp': '2024-02-25T19:30:02Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [23.015]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 03:30:46,847 CRITICAL -139958312478464- handled request [{'status': ['in-use'], 'request_zone': 'region1a', 'verbose': 2, 'zone': 'region1a', 'expires': '2024-02-25T19:31:00Z', 'limit': 100, 'offset': 6700, 'action': 'DescribeNics', 'sender': {'lang': 'en', 'user_id': 'usr-r1hSIuOw', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'usr-r1hSIuOw', 'role': 'global_admin', 'privilege': 6, 'channel': 'api'}}], exec_time is [45.816]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 03:25:47,846 CRITICAL -139958304085760- handled request [{'status': ['active'], 'request_zone': 'ecaprodbj1', 'verbose': 1, 'zone': 'region1a', 'expires': '2024-02-25T19:26:15Z', 'limit': 20, 'offset': 300, 'action': 'DescribeLoadBalancers', 'sender': {'lang': 'en', 'user_id': 'boss', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'boss', 'role': 'global_admin', 'privilege': 10, 'channel': 'api'}}], exec_time is [32.114]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 03:25:45,634 CRITICAL -140562896234240- handled request [{'headers': {'remote_addr': '10.0.108.4', 'remote_port': '38208', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '300', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '0dbcf7192ca3480fbca61fa56c92b640', 'signature': 'Ek/6h9nD/WTNwx49AJvp5RYvJqO/Nlr5fVfXLkPXeAU=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T19:25:15Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [30.043]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 03:11:17,576 CRITICAL -139959939876608- handled request [{'request_zone': 'region1a', 'verbose': 2, 'zone': 'region1a', 'expires': '2024-02-25T19:11:12Z', 'limit': 100, 'action': 'DescribeVxnets', 'sender': {'lang': 'en', 'user_id': 'usr-r1hSIuOw', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'usr-r1hSIuOw', 'role': 'global_admin', 'privilege': 6, 'channel': 'api'}}], exec_time is [64.544]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 03:10:42,982 CRITICAL -140506298316544- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '49858', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'access_key_id': 'NSBRYSAASJICQDMUVKSF', 'signature': 'sFCGC+MvA7HNINQ6YowsFDKPTPyFv9cX/587rgSePxg=', 'version': '1', 'limit': '100', 'offset': '0', 'action': 'DescribeVxnets', 'time_stamp': '2024-02-25T19:10:12Z'}}], exec_time is [30.043]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 02:25:33,910 CRITICAL -140507372058368- handled request [{'headers': {'remote_addr': '10.0.108.4', 'remote_port': '54976', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '340', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '8f2d5108531c4473b566a316081f3a21', 'signature': 'QSN+1VgOI+1Irea1VLlK/nu69j84eFrtpPiEDUF9gMc=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T18:25:03Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [30.049]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 02:25:37,370 CRITICAL -139961013618432- handled request [{'status': ['active'], 'request_zone': 'ecaprodbj1', 'verbose': 1, 'zone': 'region1a', 'expires': '2024-02-25T18:26:03Z', 'limit': 20, 'offset': 340, 'action': 'DescribeLoadBalancers', 'sender': {'lang': 'en', 'user_id': 'boss', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'boss', 'role': 'global_admin', 'privilege': 10, 'channel': 'api'}}], exec_time is [33.451]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:56:51,852 CRITICAL -140512656873216- handled request [{'headers': {'remote_addr': '10.0.128.3', 'remote_port': '58904', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '100', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '535454bd1c544b708949209d72e0d583', 'signature': 'ZuVZcipOHZAFsvzbwN/L1Y7g+2/PFgQoV2gVyKV8WNk=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T17:56:30Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [21.784]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:56:29,004 CRITICAL -140147391719168- handled request [{'headers': {'remote_addr': '10.0.128.3', 'remote_port': '55068', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '60', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '962a3c1ea79b45e2b69a20083413c77a', 'signature': '/MV5jUl9VZqoQ2OOnJlQCt/f9uMrOrpH2b2TZIGhoy4=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T17:56:08Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [20.507]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:35:29,634 CRITICAL -140515309508352- handled request [{'headers': {'remote_addr': '10.0.128.3', 'remote_port': '41070', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'zone': 'region1a', 'status.4': 'suspended', 'status.5': 'deleted', 'signature_version': '1', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF', 'status.1': 'in-use', 'status.2': 'pending', 'status.3': 'available', 'version': '1', 'limit': '20', 'volume_type': '0', 'req_id': '9d1035a49d8b436fac7cc1355d7849d6', 'offset': '20', 'action': 'DescribeVolumes', 'time_stamp': '2024-02-25T17:35:08Z', 'signature': 'aLRzXzYCG+fAE+MJCNRxBter99f6qt1gG9uM40ypDSQ='}}], exec_time is [21.563]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:35:27,827 CRITICAL -140562938197760- handled request [{'headers': {'remote_addr': '10.0.128.3', 'remote_port': '40384', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'zone': 'region1a', 'status.4': 'suspended', 'status.5': 'deleted', 'signature_version': '1', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF', 'status.1': 'in-use', 'status.2': 'pending', 'status.3': 'available', 'version': '1', 'limit': '20', 'volume_type': '5', 'req_id': 'f76d2fc4065147a9be4317a4171094f6', 'offset': '0', 'action': 'DescribeVolumes', 'time_stamp': '2024-02-25T17:35:07Z', 'signature': '3sicz5ZBx4JmDhzWQHVI/n55bgAafzdcAw0VNYEOOgg='}}], exec_time is [20.272]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:35:28,936 CRITICAL -140147358148352- handled request [{'headers': {'remote_addr': '10.0.128.3', 'remote_port': '40398', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'zone': 'region1a', 'status.4': 'suspended', 'status.5': 'deleted', 'signature_version': '1', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF', 'status.1': 'in-use', 'status.2': 'pending', 'status.3': 'available', 'version': '1', 'limit': '20', 'volume_type': '100', 'req_id': '5eb57d980e85485c99f7dcc9a79d0621', 'offset': '0', 'action': 'DescribeVolumes', 'time_stamp': '2024-02-25T17:35:07Z', 'signature': 'KOiFeOupjZZNcKzNtpfl9utCClrgY4Qz6IH41pFT2u8='}}], exec_time is [21.383]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:25:21,044 CRITICAL -140147349755648- handled request [{'headers': {'remote_addr': '10.0.128.3', 'remote_port': '57618', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '320', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '1cedcb6df62f4fb5805bd663cd0c72bf', 'signature': '3/7qHvqt4vR7+DaLkKeluMfmrnpKah2EdAlXUxswDKo=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T17:24:59Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [21.534]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:05:32,864 CRITICAL -139794130659072- handled request [{'headers': {'remote_addr': '10.0.0.3', 'remote_port': '60070', 'server_port': '7777', 'path': '/iaas', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.0.7'}, 'type': 'api', 'params': {'vxnets.1': 'vxnet-jqifxfd', 'signature_method': 'HmacSHA256', 'zone': 'region1a', 'signature_version': '1', 'access_key_id': 'AXGWJTWPQHJJMVQFTJCP', 'signature': 'ND25u6tJmSiQUeeClHc0k62y1JXWsS/6DtEPzMgj9zc=', 'limit': '252', 'offset': '0', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T17:05:11Z'}}], exec_time is [20.970]s (/usr/lib/python2.7/threading.py:801)
[region1b] [region1b-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:05:33,079 CRITICAL -140144648648448- handled request [{'headers': {'remote_addr': '10.0.108.4', 'remote_port': '41396', 'server_port': '7777', 'path': '/iaas', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.108.7'}, 'type': 'api', 'params': {'vxnets.1': 'vxnet-jqifxfd', 'signature_method': 'HmacSHA256', 'zone': 'region1a', 'signature_version': '1', 'access_key_id': 'AXGWJTWPQHJJMVQFTJCP', 'signature': 'OEKEL8jEDY0o4WCbqT3FvNtxPvmDvSuMutnRMLiKjA0=', 'limit': '252', 'offset': '0', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T17:05:12Z'}}], exec_time is [20.547]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web0] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 01:00:32,622 CRITICAL -140505258112768- handled request [{'headers': {'remote_addr': '10.1.0.15', 'remote_port': '54866', 'server_port': '8882', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '127.0.0.1'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '2', 'zone': 'region1a', 'signature_version': '1', 'offset': '400', 'status.1': 'in-use', 'version': '1', 'limit': '100', 'signature': 'YNTxv9GYkZWVNQMHLoxvfvjUUCXXQO4EMHSEqbJSy1U=', 'action': 'DescribeNics', 'time_stamp': '2024-02-25T17:00:02Z', 'access_key_id': 'NSBRYSAASJICQDMUVKSF'}}], exec_time is [30.145]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 01:00:38,908 CRITICAL -139959377827584- handled request [{'status': ['in-use'], 'request_zone': 'region1a', 'verbose': 2, 'zone': 'region1a', 'expires': '2024-02-25T17:01:02Z', 'limit': 100, 'offset': 400, 'action': 'DescribeNics', 'sender': {'lang': 'en', 'user_id': 'usr-r1hSIuOw', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'usr-r1hSIuOw', 'role': 'global_admin', 'privilege': 6, 'channel': 'api'}}], exec_time is [36.313]s (/usr/lib/python2.7/threading.py:801)
[region1c] [region1c-web1] has alerts |@@|<h3>=== ws_server.log.wf ===</h3>|@@|2024-02-26 00:55:31,028 CRITICAL -140514326202112- handled request [{'headers': {'remote_addr': '10.0.108.4', 'remote_port': '46684', 'server_port': '7777', 'path': '/iaas/', 'is_secure': True, 'method': 'GET', 'server_addr': '10.0.128.6'}, 'type': 'api', 'params': {'signature_method': 'HmacSHA256', 'verbose': '1', 'zone': 'ecaprodbj1', 'signature_version': '1', 'offset': '200', 'status.1': 'active', 'version': '1', 'limit': '20', 'req_id': '3b66364f89be489ab47f9d815c387e5d', 'signature': 'oh0LCyaO8cHZ/R3en+kQfQ9eeeJT7HbpLHGHLxdjifc=', 'action': 'DescribeLoadBalancers', 'time_stamp': '2024-02-25T16:55:00Z', 'access_key_id': 'VSJYOBRDZJEUZQXLWWNF'}}], exec_time is [30.054]s (/usr/lib/python2.7/threading.py:801)
[region1a] [region1a-web0] has alerts |@@|<h3>=== fg_server.log.wf ===</h3>|@@|2024-02-26 00:55:50,729 CRITICAL -139959939876608- handled request [{'status': ['active'], 'request_zone': 'ecaprodbj1', 'verbose': 1, 'zone': 'region1a', 'expires': '2024-02-25T16:56:00Z', 'limit': 20, 'offset': 200, 'action': 'DescribeLoadBalancers', 'sender': {'lang': 'en', 'user_id': 'boss', 'console_id': 'ecaprodbjcloud', 'root_user_id': 'boss', 'role': 'global_admin', 'privilege': 10, 'channel': 'api'}}], exec_time is [49.641]s (/usr/lib/python2.7/threading.py:801)

grep -o过滤关键字，stor排序，uniq统计次数

[root@localhost ~]# cat 202402261009.csv |grep -o 'Describe.*'|awk '{print $1}'|sed -e "s/'//g" -e "s/,/ /g" -e "s/]/ /g" -e "s/}/ /g"|sort -d|uniq -c
      1 DescribeBaremetals
     11 DescribeLoadBalancers
     13 DescribeNics
      3 DescribeVolumes
      2 DescribeVxnets