Average Disk space used by all workstations?

titan90 · 04-14-2009, 01:35 PM

Maybe someone with more SQL skills can help me?

I need help generating a report that will show the average disk space used on workstations in our entire environment. It does not need to be on a per computer basis - but the average of all workstations as whole.

I have found the Inv_Aex_HW_Logical_Disk table and hope the Size in MB and Free in MB's can help. But my SQL abilities are not so good on averages.

Any helps, tips, pointers appreciated.

titan90 · 04-14-2009, 04:54 PM

The 'Computers by Total Disk Size' query allowed me to get workstation data only. I exported into Excel and did the average calculations there.

It's not pretty, but got me out of spending time on SQL syntax issues.

LordofthePatch · 04-14-2009, 05:17 PM

Here is something that should get you started...

Code:

-- Average Hard Disk Usage for All Workstations (incl. Windows/Mac/Linux)
SELECT (AVG(([Size (Bytes)] - [Free Space (Bytes)])) / 1073741824) AS [Avg Disk Space (GB)] 
FROM Inv_HW_Logical_Disk ld
INNER JOIN CollectionMembership cm
  ON cm.CollectionGuid in ('cbe9791c-7ed3-4b05-9129-c04d61cc8a23', '777ff65f-f228-4d14-876b-2d9c1de9e514')
INNER JOIN vComputerResource vc
  ON vc.Guid = cm.ResourceGuid
  AND vc.IsManaged = 1

titan90 · 04-14-2009, 05:26 PM

Much obliged.

I will use this to figure the SQL out.

Thank you.