Export disk list to CSV

[Anorpha]

Hi.

Is there anyway to export this list to CSV?

 

[BeardyDude]

I also would love to know a way to do this..... or if there's some way of bringing it up that yields a decent copy and paste that google sheets / excel will slot into cells!

 

[elvisimprsntr]

In SCALE, you can easily get a list using lsblk command via CLI. Then write a perl/python script to convert to a CSV

See man page for more options

Code:

man lsblk

Tab/Space delimited output

Code:

root@NAS-3[~]# lsblk -S -x NAME
NAME HCTL       TYPE VENDOR   MODEL               REV SERIAL           TRAN
sda  0:0:0:0    disk ATA      ST2000DM006-2DM164 CC26 XXXXXXXX         sata
sdb  1:0:0:0    disk ATA      ST2000DM006-2DM164 CC26 XXXXXXXX         sata
sdc  2:0:0:0    disk ATA      ST2000VN004-2E4164 SC60 XXXXXXXX         sata
sdd  6:0:0:0    disk ATA      ST2000DM006-2DM164 CC26 XXXXXXXX         sata
sde  10:0:0:0   disk Micron   Crucial_X8_SSD     0    XXXXXXXX         usb
sdf  11:0:0:0   disk          USB_DISK_MODULE    PMAP XXXXXXXX         usb

JSON output

Code:

root@NAS-3[~]# lsblk -S -x NAME -J
{
   "blockdevices": [
      {"name":"sda", "hctl":"0:0:0:0", "type":"disk", "vendor":"ATA     ", "model":"ST2000DM006-2DM164", "rev":"CC26", "serial":"XXXXXXXX", "tran":"sata"},
      {"name":"sdb", "hctl":"1:0:0:0", "type":"disk", "vendor":"ATA     ", "model":"ST2000DM006-2DM164", "rev":"CC26", "serial":"XXXXXXXX", "tran":"sata"},
      {"name":"sdc", "hctl":"2:0:0:0", "type":"disk", "vendor":"ATA     ", "model":"ST2000VN004-2E4164", "rev":"SC60", "serial":"XXXXXXXX", "tran":"sata"},
      {"name":"sdd", "hctl":"6:0:0:0", "type":"disk", "vendor":"ATA     ", "model":"ST2000DM006-2DM164", "rev":"CC26", "serial":"XXXXXXXX", "tran":"sata"},
      {"name":"sde", "hctl":"10:0:0:0", "type":"disk", "vendor":"Micron  ", "model":"Crucial_X8_SSD", "rev":"0   ", "serial":"XXXXXXXX", "tran":"usb"},
      {"name":"sdf", "hctl":"11:0:0:0", "type":"disk", "vendor":"        ", "model":"USB_DISK_MODULE", "rev":"PMAP", "serial":"XXXXXXXX", "tran":"usb"}
   ]
}

Key/Value pairs

Code:

root@NAS-3[~]# lsblk -S -x NAME -P
NAME="sda" HCTL="0:0:0:0" TYPE="disk" VENDOR="ATA     " MODEL="ST2000DM006-2DM164" REV="CC26" SERIAL="XXXXXXXX" TRAN="sata"
NAME="sdb" HCTL="1:0:0:0" TYPE="disk" VENDOR="ATA     " MODEL="ST2000DM006-2DM164" REV="CC26" SERIAL="XXXXXXXX" TRAN="sata"
NAME="sdc" HCTL="2:0:0:0" TYPE="disk" VENDOR="ATA     " MODEL="ST2000VN004-2E4164" REV="SC60" SERIAL="XXXXXXXX" TRAN="sata"
NAME="sdd" HCTL="6:0:0:0" TYPE="disk" VENDOR="ATA     " MODEL="ST2000DM006-2DM164" REV="CC26" SERIAL="XXXXXXXX" TRAN="sata"
NAME="sde" HCTL="10:0:0:0" TYPE="disk" VENDOR="Micron  " MODEL="Crucial_X8_SSD" REV="0   " SERIAL="XXXXXXXX" TRAN="usb"
NAME="sdf" HCTL="11:0:0:0" TYPE="disk" VENDOR="        " MODEL="USB_DISK_MODULE" REV="PMAP" SERIAL="XXXXXXXX" TRAN="usb"

Direct output to a file, just add the following after the command

Code:

> `hostname`.tab