Query for HDD Capacity with Workstation name

Query for HDD Capacity with Workstation name

we are looking for help with the PostgreSQL codes that can pull up following reports.

 WS name, Drive name, Drive type (local disks only), File System, Capacity GB, Free Space MB, where . Please find below report type.

Sr.No Manchine name HDD Total Capacity in GB