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


    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.

Storage Pool Growth Report


ADSM.ORG Senior Member

I have one particular ISP Server which is only being monitored by the OC and no other fancy 3rd party system.

I need to know a way of generating a report / figures of how much a Container Storage pool has or is growing over the course of a period of time? Say last 12 months for example...

Not particularly looking for charts but possibly a SQL script for something that provides me with the stg pool capacity figures at a point in time for each month, as a figure (GB). From there I can identify how much we need to increase storage pool capacity by for the next 12 months etc..

Anyone got a script please which might produce the output that I'm looking for?



ADSM.ORG Moderator

You won't be able to get that from the database because it doesn't keep historical data of that nature that long. At least not at the present time.

You could run a script outside Spectrum Protect periodically (weekly, monthly) to query the server and output to a .csv file you could read with Excel:

dsmadmc -id=admin -pa=***** -comma "select date(current_date) as DATE,tsmgui_allcli_grid.* from tsmgui_allcli_grid" >> /path/stgpool-usage.csv

Might not be a bad idea to edit the .csv file once to put the column headings on top, you could get them by running the query by itself from the server.


ADSM.ORG Senior Member
Thanks marclant, I feared as much..

Luckily for me I had setup the OC licensing capacity reports to email me weekly, so just grabbed the back end figures from those for the last year (Monthly) to plot a growth graph within a csv file. Gives me a good indication of what I need to add for the next year or so capacity wise.


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: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Latest member