SELECT workstation.WORKSTATIONNAME "工作站",

workstation.MODEL "类型",

aaov.NAME "地点",

(hdi.CAPACITY)/1024/1024/1024 "所有磁盘总容量容量",

dri.DRIVENAME "磁盘名称",

Dri.CAPACITY/1024/1024/1024 "磁盘容量",

(dri.FREESPACE/1024)/1024/1024 "剩余容量",workstation.SERVICETAG "服务标签" FROM SystemInfo workstation

LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID

LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID

LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID

LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID

LEFT JOIN HardDiskInfo hdi ON workstation.WORKSTATIONID= hdi.WORKSTATIONID

LEFT JOIN DriveInfo dri ON workstation.WORKSTATIONID=dri.WORKSTATIONID 

order by 1