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

TSM - Select

girreis

ADSM.ORG Member
Joined
Feb 11, 2011
Messages
119
Reaction score
1
Points
0
Dear friends,

This script (SELECT) TSM Server 5.5 does fall?

SELECT COUNT (DISTINCT volume_name) the volumes, node_name, stgpool_name -
volumeusage from -
group by node_name, stgpool_name -
order by desc volumes

Thanks for listening,
Ramon
 

fuzzballer

ADSM.ORG Member
Joined
Jun 5, 2004
Messages
204
Reaction score
1
Points
0
Location
Kansas
Website
Visit site
Is this what you are trying to do?

select distinct volume_name, node_name, stgpool_name from volumeusage group by node_name, stgpool_name, volume_name order by volume_name desc
 

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

    Votes: 66 58.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 15 13.4%
  • Other (please comement)

    Votes: 9 8.0%

Forum statistics

Threads
31,834
Messages
134,890
Members
21,794
Latest member
CALEB
Top