Disk Pool historical report

[nbritton]

I am trying to create a report that will show me the diskpool used amount historicly.  Is this something someone else has figured out?

[RiaanBadenhorst · Accepted solution]

Hi,

You can check in the domain_DiskPoolHistory table. This table stores the attributes for disk pool historical data.

Something like this (report for 120 days)

select domain_DiskPoolHistory.name as "Pool Name",
(domain_DiskPoolHistory.rawsize)/1073741824 as "Used GB",
UTCBigIntToNomTime(domain_DiskPoolHistory.snapshottime) as "Time"
FROM domain_DiskPoolHistory
WHERE DATEDIFF(day,UTCBigIntToNomTime(domain_DiskPoolHistory.snapshottime), GETDATE()) <= 120