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