Excel Guides

Retrieving Drive Statistics in Excel

There are a few ways to retrieve drive statistics in Excel. One way is to use the DiskPart command line tool. This tool can be used to view the attributes of a disk, including the amount of free space, the total size of the disk, and the number of sectors. Another way to retrieve drive statistics is to use the WMIC command line tool. This tool can be used to view the attributes of a disk, including the amount of free space, the total size of the disk, and the number of sectors.

To use DiskPart, open a Command Prompt window and type diskpart. At the DISKPART> prompt, type list volume. This will list all of the volumes on the computer, including any connected drives. To select a specific drive, type select volume <volume number>, where is the number of the volume you want to view information about. To view information about the selected volume, type detail volume. This will display information about the selected volume, including the amount of free space, the total size of the disk, and the number of sectors.

To use WMIC, open a Command Prompt window and type wmic. At the WMIC> prompt, type logicaldisk get size,freespace,caption. This will list information about all logical disks on the computer, including any connected drives. The output will include the drive letter, the total size of the drive in bytes, the amount of free space on the drive in bytes, and the label or caption of the drive. If you want to view information about a specific drive, you can specify the drive letter after the get command. For example, to view information about drive C:, you would type logicaldisk get size,freespace,caption C:.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.