Disk Pool historical report
I am trying to create a report that will show me the diskpool used amount historicly. Is this something someone else has figured out?
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
