Monthly Charge-Back Report

[rpandey]

Hi
I need to generate Monthly charge-back report but Opscenter allow to generate only either daily or weekly. Is there script available for the monthly?

 

[marclant]

Scripts, no. But you can check on Thobias if there's a SQL that does what you want.
https://github.com/thobiast/tsm_sql

I'm not sure if you charge back on activity or occupancy. If on activity, you could modify this one to do 30 days instead of 7:
https://github.com/thobiast/tsm_sql...eve-operations-per-node-in-the-last-7-days-gb

Or if you want by occupancy:
https://github.com/thobiast/tsm_sql#data-stored-per-client-gb

You can use those queries in the report builder, or run them manually. If manually, you could create a Spectrum Protect script that you run manually on a monthly basis to generate the output, that way you don't need to remember or type the full SQL command.

 

[dcabro]

Unfortunately those script return nothing, tried to use them a few months ago.

If you want by occupancy, you could use the info from dedupstats - you need to generate them (generate dedupstats) per storage pool or node, and then you could pull the info per node with:

# AMOUNT OF DATA PER NODE

select node_name,sum(physical_MB) as Space_used_MB from dedupstats group by node_name

 

[Trident]

Unfortunately those script return nothing, tried to use them a few months ago.

If you want by occupancy, you could use the info from dedupstats - you need to generate them (generate dedupstats) per storage pool or node, and then you could pull the info per node with:

# AMOUNT OF DATA PER NODE

select node_name,sum(physical_MB) as Space_used_MB from dedupstats group by node_name

Remember that these stats may be generated every day, so add a delete dedupstats somewhere. Otherwise you will bill way too much.

 

[marclant]

Unfortunately those script return nothing, tried to use them a few months ago.

Those are not scripts, those are SQL queries. There must have been a syntax or logic problem in your WHERE clause because the SUMMARY and OCCUPANCY tables are never empty.

 

[rpandey]

Thank you all for your feedback. I have applied RFE for the improvement. I have provided the link, please vote so that IBM include this Monthly option on new release. Thanks

http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=147931