Hourly Disk Pool Report?

[elanmbx]

I thought that this would be easy... but alas, it appears not as easy as I was hoping.

I'm trying to generate an hourly disk pool report for a re-sizing analysis.  I would like to know hourly how my advanced disk pools are affected by our "regular" backup window.

Has anyone done this?  The regular disk capacity report doesn't get this granular (just goes to daily).

Thanks in advance.

[RiaanBadenhorst · Accepted solution]

Try this. Put it in a custom query and send the report hourly via scheduler.

select usedCapacity 

from domain_diskpool

where name like '%YOUR ADVDISK POOL NAME%'

[elanmbx]

That looks like it will work!  Any chance I can fairly easily format the report such that all my disk pools are repoted as such:

disk_pool_name  used_capacity

Then I can live with a single query and not one for each pool.

I, apparently, am no SQL guy. :)

Thanks a lot!

[elanmbx]

Aaaaaaaannd... there is no way to schedule a report more granular than daily in OpsCenter??  I must be missing something...

So much for easy, eh?

[RiaanBadenhorst]

You can make 12 schedules :)

select domain_diskpool.usedCapacity as "Used Capacity",

domain_diskpool.name as "DiskPool Name"

from domain_diskpool

where name like '%YOUR ADVDISK POOL NAME%'

[elanmbx]

Excellent - I appreciate the SQL help!

Any ideas how to make OpsCenter run a schedule hourly?  Maybe I can run something from the OpsCenter server itself?

[RiaanBadenhorst]

Just login to opscenter, go to my reports. CReate your report. Then go schedules, and create 24 schedules, and select your report to be sent to you via email.

[elanmbx]

Ahhh... I thought you were kidding with the "12 schedules" comment. :)

It seems odd that there is no "hourly" option in the time-based scheduling for reports...