私は Ubuntu を初めて使い、数週間使用しています。最近、特定のデータをファイルに表示しなければならないという問題が発生しました。以下は、ターミナルに表示される出力です。
Potential vulnerability found (CVE-2009-4028)
CVSS Score is 6.8
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2009-4030)
CVSS Score is 4.4
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2009-5026)
CVSS Score is 6.8
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0075)
CVSS Score is 1.7
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0087)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0101)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0102)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0112)
CVSS Score is 3.5
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0113)
CVSS Score is 5.5
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0114)
CVSS Score is 3.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0115)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0116)
CVSS Score is 4.9
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0118)
CVSS Score is 4.9
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0119)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0120)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0484)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0485)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0490)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0492)
CVSS Score is 2.1
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0540)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0553)
CVSS Score is 7.5
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0574)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2012-0583)
CVSS Score is 4.0
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2013-1492)
CVSS Score is 7.5
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2013-1506)
CVSS Score is 2.8
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
Potential vulnerability found (CVE-2013-1521)
CVSS Score is 6.5
Full vulnerability match (incl. edition/language)
File "/usr/sbin/mysqld" (CPE = cpe:/a:mysql:mysql:5.1:::) on host glynis-desktop (key glynis-desktop)
見つかった潜在的な脆弱性フィールドとそれに対応するスコアのみを表示するつもりです。エントリは約 9995 件あるようですが、すべて表示したいと思います。
私は今のところこのコマンドを使用しています
awk '/CVSS Score is/ < /Potential vulnerability found/' output.txt
しかし、これは脆弱性の名前またはスコアのみを表示するようです。すべての脆弱性と対応するスコアが表示されるように、これをファイル (テキスト、Excel) に表示するにはどうすればよいですか。
ご協力いただければ幸いです。ありがとうございます。
答え1
使用できますgrep:
grep -E "Potential vulnerability found|CVSS Score is" input_file
出力をテキスト ファイルに保存する場合は、次のようにします。
grep -E "Potential vulnerability found|CVSS Score is" input_file > output_file