Re: Nessus to Excel

["Francisco Pecorella" <fpecor () cantv net>]

Hi Matthew,

Try to run this command on a Linux box, where test.nbe is your Nessus Report, 
and it will generate a file nessus-out.csv which you can open with Excel.

$ grep test.nbe|cut -d"|" -f3,4,5,6|sort -k1|sed s/\|/,/g|perl -e 'while (<>) 
{ print $_ if (/(.*\,){3}/)}' > nessus-out.csv

You can delete the cut command in order to get the complete report.

Hope it helps.

--
Regards,
FP
----- Original Message ----- 
From: "Matthew Webster" <awakenings () mindspring com>
To: <pen-test () securityfocus com>
Sent: Friday, April 07, 2006 10:15 AM
Subject: Nessus to Excel


> I'm not a database guy and not good with XML.  Does anyone know a good way to 
> transfer Nessus documents to Excel output?  I need it to compare the output 
> from an outside company's scan (which is in Excel) in a quick fashion.  I do 
> have a linux box and a windows box at my disposal.  Any ideas?
>
>
>
> ------------------------------------------------------------------------------
> This List Sponsored by: Cenzic
>
> Concerned about Web Application Security?
> Why not go with the #1 solution - Cenzic, the only one to win the Analyst's
> Choice Award from eWeek. As attacks through web applications continue to rise,
> you need to proactively protect your applications from hackers. Cenzic has the
> most comprehensive solutions to meet your application security penetration
> testing and vulnerability management needs. You have an option to go with a
> managed service (Cenzic ClickToSecure) or an enterprise software
> (Cenzic Hailstorm). Download FREE whitepaper on how a managed service can
> help you: http://www.cenzic.com/news_events/wpappsec.php
> And, now for a limited time we can do a FREE audit for you to confirm your
> results from other product. Contact us at request () cenzic com for details.
> ------------------------------------------------------------------------------


------------------------------------------------------------------------------
This List Sponsored by: Cenzic

Concerned about Web Application Security? 
Why not go with the #1 solution - Cenzic, the only one to win the Analyst's 
Choice Award from eWeek. As attacks through web applications continue to rise, 
you need to proactively protect your applications from hackers. Cenzic has the 
most comprehensive solutions to meet your application security penetration 
testing and vulnerability management needs. You have an option to go with a 
managed service (Cenzic ClickToSecure) or an enterprise software 
(Cenzic Hailstorm). Download FREE whitepaper on how a managed service can 
help you: http://www.cenzic.com/news_events/wpappsec.php 
And, now for a limited time we can do a FREE audit for you to confirm your 
results from other product. Contact us at request () cenzic com for details.
------------------------------------------------------------------------------