While writing a historical disk space utilization report, we discovered the report is not showing a disk space size increase when using format = 'Bytes'. We knew we had increased this drive space in January. We discovered it was because it is rounding to 1 decimal position. It took several tries to extract the number of bytes stored in the VolumeUsage table. After removing several columns and changing the format to 'Numeric Data', I finally was able to get the full number to appear. The number was 1,925,216,210,944 B (1.75 TB) for December and 2,025,515,332,687 (1.842 TB) for January.
When viewing the graphical views for the same drive, the graph shows the disk size change. But when you hover over the bar, again it only shows 1.8 TB for both months.
Is the 'Bytes' format configurable so you can choose the number of decimal places? Perhaps allowing a different amount for KB, MB, GB, TB, etc.
Thank you for considering this enhancement.
p.s. I'm using Report Writer version 2012.2.1
-------------------------------------------------------------------------------------------------------------------------------------------
Below is the SQL used to extract the number of bytes by month for each node/volume combination:
SELECT
CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Volumes.VolumeID AS VolumeID,
Nodes.Caption AS NodeName,
Volumes.Caption AS Caption,
AVG(Volumes.VolumeSpaceUsed) AS AVERAGE_of_VolumeSpaceUsed,
AVG(VolumeUsage.DiskSize) AS AVERAGE_of_Disk_Size
FROM
(Nodes INNER JOIN Volumes ON (Nodes.NodeID = Volumes.NodeID)) INNER JOIN VolumeUsage ON (Volumes.VolumeID = VolumeUsage.VolumeID)
WHERE
( DateTime BETWEEN 41202 AND 41295 )
AND
(
(Volumes.VolumeType <> 'RAM') AND
(Volumes.VolumeType <> 'Virtual Memory')
)
GROUP BY
CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.NodeID, Volumes.VolumeID, Nodes.Caption, Volumes.Caption, Volumes.VolumeTypeIcon, Volumes.VolumeType
ORDER BY 5 asc, SummaryMonth ASC, 4 ASC
