Conversion to TB (terabytes) needs more decimal spaces
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.
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.