• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Monthly Charge-Back Report

rpandey

ADSM.ORG Member
Joined
Feb 2, 2009
Messages
73
Reaction score
1
Points
0
Location
Australia
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

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,639
Reaction score
591
Points
0
Location
Canada
Website
www-947.ibm.com
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

ADSM.ORG Member
Joined
Mar 28, 2014
Messages
30
Reaction score
2
Points
0
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
 

Trident

TSM/Storge dude
ADSM.ORG Moderator
Joined
Apr 2, 2007
Messages
535
Reaction score
61
Points
0
Location
Oslo, Norway
Website
www.basefarm.no
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.
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,639
Reaction score
591
Points
0
Location
Canada
Website
www-947.ibm.com
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.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 19 19.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 61 61.0%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.0%
  • Other (please comement)

    Votes: 8 8.0%

Forum statistics

Threads
31,774
Messages
135,487
Members
21,762
Latest member
Rambug
Top