How can I export network data from the esxtop command?

[jmbrav0]

Good day,

I've tried to export all esxtop data into a CSV but Excel can't open the file property. I wonder if is possible just export network data to a CSV.

Thanks

[virtualg_uk]

Hello

How are you creating the CSV file? Please see: Exporting esxtop performance data as a CSV file and manipulating it from the command-line (1004953) ...

[jmbrav0]

Thanks grba‌

It could be useful. Anyway, I'am creating the CSV file like that KB says In spite of that, the final CSV file after cat command is illegible by Excel.

I'am using AIX Server to do cat command... I'm going to do it on a Linux Machine to dismiss things.

[dzak64]

I followed the KB Article, but I only get the first 9 rows of data...

Used the following to gather the data:

nohup esxtop -b -d 2 -n 450 > /vmfs/volumes/VSPHERE_LUN100/tmp.csv &

The following was to export stats for "Virtual Disk"

cat /tmp/tmp.csv | cut -d "," -f 1,`head -1 /tmp/tmp.csv | tr "," "\12" | egrep -n "Virtual Disk" | cut -d ":" -f 1 | tr "\12" "," | sed "s/,$//"` | head

The tmp.csv files contains all of the data... not sure why the export is providing 9 rows of data