cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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?

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Hi, You can check in the

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

View solution in original post

1 Reply
Highlighted
Accepted Solution!

Hi, You can check in the

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

View solution in original post