Exibir dados específicos em um arquivo

Exibir dados específicos em um arquivo

Sou novo no Ubuntu e já o uso há algumas semanas. Recentemente, encontrei um problema em que tive que exibir dados específicos em um arquivo. Aqui está a saída exibida no terminal.

  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)

Pretendo exibir apenas o campo Vulnerabilidade potencial encontrada e a pontuação correspondente. Parece haver cerca de 9.995 entradas e gostaria de exibir todas elas.

Eu tenho usado este comando a partir de agora

awk '/CVSS Score is/ < /Potential vulnerability found/' output.txt 

mas parece exibir apenas o nome da vulnerabilidade ou a pontuação. Como faço para exibir isso em arquivo (texto, excel) de forma que toda a vulnerabilidade e a pontuação correspondente sejam exibidas.

Qualquer ajuda seria apreciada, obrigado.

Responder1

Você pode usargrep:

grep -E "Potential vulnerability found|CVSS Score is" input_file

Se você quiser salvar a saída em um arquivo de texto, use:

grep -E "Potential vulnerability found|CVSS Score is" input_file > output_file

informação relacionada