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 %]