Monthly Charge-Back Report

rpandey

ADSM.ORG Member
Joined
Feb 2, 2009
Messages
91
Reaction score
2
Points
0
Location
Australia
PREDATAR Control23

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?
 
PREDATAR Control23

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.
 
PREDATAR Control23

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
Code:
select node_name,sum(physical_MB) as Space_used_MB from dedupstats group by node_name
 
PREDATAR Control23

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
Code:
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.
 
PREDATAR Control23

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.
 
Top