Registered member login:
Register Now
Altirigos » Altiris Administrators » Reports » Average Disk space used by all workstations?

» Current Poll
Do you leave the Aclient enabled?
YES - 82.81%
106 Votes
NO - 17.19%
22 Votes
Total Votes: 128
You may not vote on this poll.
» Stats
Members: 9,488
Threads: 11,748
Posts: 55,279
Top Poster: Nick (4,981)
Welcome our newest member, johno
» Online Users: 44
3 members and 41 guests
Gaute, lomac, Onion
Most users online at once 294, 06-30-2007 at 12:24 PM.
» March 2010
S M T W T F S
28 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 123
Reply
Old 04-14-2009, 01:35 PM   #1 (permalink)
 
titan90's Avatar
 
Status: Altiris Admin
Join Date: 08-07-2006
Location: TX
Posts: 67


Average Disk space used by all workstations?

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 is offline   Reply With Quote
Old 04-14-2009, 04:54 PM   #2 (permalink)
 
titan90's Avatar
 
Status: Altiris Admin
Join Date: 08-07-2006
Location: TX
Posts: 67


Kinda sorta got it...

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.
titan90 is offline   Reply With Quote
Old 04-14-2009, 05:17 PM   #3 (permalink)
 
LordofthePatch's Avatar
 
Status: Site Administrator
Join Date: 02-16-2005
Location: The Shire
Posts: 3,078


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
__________________
The Mac motto: "Anything you can do I can do better; I can do anything better than you."
LordofthePatch is offline   Reply With Quote
Old 04-14-2009, 05:26 PM   #4 (permalink)
 
titan90's Avatar
 
Status: Altiris Admin
Join Date: 08-07-2006
Location: TX
Posts: 67


Thanks

Much obliged.

I will use this to figure the SQL out.

Thank you.
titan90 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Powered by vBadvanced CMPS v3.0 RC2

All times are GMT -4. The time now is 02:55 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
vB.Sponsors
Altirigos