Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Delta Change Reports?

I'm looking for a report that details the delta in used space on a weekly basis for VM's on specific datastores. Nothing I've seen OOB has worked, even modified. My SQL skills are not up to par & haven't gotten queries anywhere close to what is being asked (damn Storage Team ).

Does anyone know how to accomplish this?

Thanks in advance!

Find more posts tagged with

Accepted answers

All comments

cboberwin

Someone has to run reports like this...

cboberwin

So here is what I have so far. I think I accomplished the Delta part but now I need to target VM's from specific datastores. How can I accomplish this? Thanks in advance!

SELECT TbDay1.NodeName

,TbDay1.NodeID

,TbDay1.DiskName

,TbDay1.DiskID

,TbDay1.Disk_Size

,TbDay1.Day1

,TbDay1.Day1_DiskUsed

,TbDay1.Day1_PercentDiskUsed

,TbDay7.Day7

,TbDay7.Day7_DiskUsed

,TbDay7.Day7_PercentDiskUsed

,Round(TbDay1.Day1_PercentDiskUsed - TbDay7.Day7_PercentDiskUsed, 2) AS WeeklyIncrease

FROM (

(

SELECT Nodes.NodeID AS NodeID

,Nodes.Caption AS NodeName

,Volumes.VolumeID AS DiskID

,Volumes.Caption AS DiskName

,CONVERT(DATE, VolumeUsage.DATETIME) AS Day1

,ROUND(AVG(VolumeUsage.DiskSize) / 1024 * 1024, 1) AS Disk_Size

,ROUND(AVG(VolumeUsage.AvgDiskUsed) / 1024 / 1024 / 1024, 1) AS Day1_DiskUsed

,ROUND(AVG(VolumeUsage.PercentDiskUsed), 1) AS Day1_PercentDiskUsed

FROM Nodes INNER JOIN Volumes ON Nodes.NodeID = Volumes.NodeID

--JWA added this portion below

INNER JOIN [VIM_VirtualMachineNodes] v ON nodes.NodeID = v.NodeID

INNER JOIN VolumeUsage ON Volumes.VolumeID = VolumeUsage.VolumeID

WHERE Volumes.VolumeType = 'Fixed Disk'

AND DATETIME BETWEEN DATEADD(dd, - 1, DATEDIFF(dd, 0, GETDATE())) AND DATEADD(hh, - 22, DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())))

GROUP BY CONVERT(DATE, VolumeUsage.DATETIME)

,Nodes.NodeID

,Volumes.VolumeID

,Nodes.Caption

,Volumes.Caption

) TbDay1

INNER JOIN

(

SELECT Nodes.NodeID AS NodeID

,Nodes.Caption AS NodeName

,Volumes.VolumeID AS DiskID

,Volumes.Caption AS DiskName

,CONVERT(DATE, VolumeUsage.DATETIME) AS Day7

,ROUND(AVG(VolumeUsage.DiskSize) / 1024 / 1024 / 1024, 1) AS Disk_Size

,ROUND(AVG(VolumeUsage.AvgDiskUsed) / 1024 / 1024 / 1024, 1) AS Day7_DiskUsed

,ROUND(AVG(VolumeUsage.PercentDiskUsed), 1) AS Day7_PercentDiskUsed

FROM Nodes

INNER JOIN Volumes ON Nodes.NodeID = Volumes.NodeID

INNER JOIN VolumeUsage ON (Volumes.VolumeID = VolumeUsage.VolumeID)

--JWA added this portion below

INNER JOIN [VIM_VirtualMachineNodes] v ON nodes.NodeID = v.NodeID

WHERE (Volumes.VolumeType = 'Fixed Disk')

AND DATETIME BETWEEN DATEADD(dd, - 7, DATEDIFF(dd, 0, GETDATE())) AND DATEADD(hh, - 22, DATEADD(dd, - 6, DATEDIFF(dd, 0, GETDATE())))

GROUP BY CONVERT(DATE, VolumeUsage.DATETIME)

,Nodes.NodeID

,Volumes.VolumeID

,Nodes.Caption

,Volumes.Caption

) TbDay7 ON TbDay7.NodeID = TbDay1.NodeID AND TbDay7.DiskID = TbDay1.DiskID

)

--WHERE TbDay1.Day1_PercentDiskUsed > 95.0

--OR Round(TbDay1.Day1_PercentDiskUsed - TbDay7.Day7_PercentDiskUsed, 2) > 20.0

ORDER BY TbDay1.NodeName, TbDay1.DiskName