Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Physical Drive Report / Pie chart

Created: 19 Aug 2009 • Updated: 21 May 2010 | 4 comments
yabru's picture

Hi,

I'm trying to create pie chart/dashboard for % free drive space for just one of our File Servers.

I know KB 34368 explains how to create a pie chart...however i need to modify this report first.

View -  Inventory Solutions - Reports - Windows - Physical Drive - Disk Free Space Less that 'N' Percent

Basically this report brings back results for each physical drive on my server, which is fine, except i want a pie chard for each drive.

Question is....how do i specifiy a Drive letter? Say D:?
The report below shows g. [Device ID]  [Drive]

I'm assuming i need to change the 'Device ID' part?

SELECT DISTINCT 
    i.[Name],     
    g.[Device ID] [Drive],    
    g.[Free Space in MBytes] * 100 / [Size in MBytes] [Free Space %], 
    g.[Free Space in MBytes] [Free Space(MB)], 
    g.[Size in MBytes] [Total Size(MB)],   
    g.[_ResourceGuid] [ResourceGuid]   
FROM dbo.vComputer i    
    JOIN dbo.Inv_AeX_HW_Logical_Disk g    
        ON g.[_ResourceGuid] = i.Guid   
    JOIN dbo.Inv_AeX_AC_Identification d   
        ON d.[_ResourceGuid] = i.Guid  
    JOIN dbo.CollectionMembership cm   
        ON cm.ResourceGuid = d.[_ResourceGuid]  
WHERE g.[Size in MBytes] IS NOT NULL    
AND g.[Free Space in MBytes] IS NOT NULL   
AND g.[Size in MBytes] <> 0   
AND g.[Description] = %Type%    
AND g.[Free Space in MBytes] * 100 / [Size in MBytes] >= %Free Space Percent%    
AND d.[System Type] LIKE 'Win%'    
AND i.[Name] LIKE '%ComputerName%'   
AND d.Domain LIKE '%Domain%'   
ORDER By [Free Space %]

Comments 4 CommentsJump to latest comment

yabru's picture

Does someone know how i include the Real Time summary report on a web portal???

imagebrowser image

jharings's picture

in the report you posted, that it is limited to a single drive. Is the RTS summary a report or a dashboard?

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

yabru's picture

Hi,

Basically when you right-click on a server, and go to resource manager and the Real Time System, and summary it gives you the pie charts above relating to the physical drives free space and used space.

I'd like to create a dashboard which has this view constantly available or displayed. and was wondering if there is simply a way to link a dashboard to the summary pie charts of the drive space.

Steve