Workstation Drive Details
In some previous posts, a query was provided to show a lot of workstation infomormation, including drives. That query is:
SELECT BINARY wssys.WORKSTATIONNAME 'WorkStation',wsdri.DRIVENAME "Drive Name",BINARY wsdri.DRIVETYPE "Drive Type",ROUND((wsdri.CAPACITY/1024)/1024) "Capacity (MB)",ROUND((wsdri.FREESPACE/1024)/1024) "Freespace (MB)",BINARY wsdri.FILESYSTEM "Drive Filesystem" FROM SystemInfo wssys LEFT JOIN DriveInfo wsdri ON wssys.WORKSTATIONID=wsdri.WORKSTATIONID order by 1
What changes need to be made to this query to include there Physical Drive details of Drive Name and Description?
Thanks
SELECT BINARY wssys.WORKSTATIONNAME 'WorkStation',wsdri.DRIVENAME "Drive Name",BINARY wsdri.DRIVETYPE "Drive Type",ROUND((wsdri.CAPACITY/1024)/1024) "Capacity (MB)",ROUND((wsdri.FREESPACE/1024)/1024) "Freespace (MB)",BINARY wsdri.FILESYSTEM "Drive Filesystem" FROM SystemInfo wssys LEFT JOIN DriveInfo wsdri ON wssys.WORKSTATIONID=wsdri.WORKSTATIONID order by 1
What changes need to be made to this query to include there Physical Drive details of Drive Name and Description?
Thanks