ADSM-L

Re: How to List library tape volumes by Pct Util?

2003-05-30 09:44:03
Subject: Re: How to List library tape volumes by Pct Util?
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 30 May 2003 09:43:39 -0400
>Can someone suggest a query to list all the volumes in the library sorted
>by "Pct Util"?

Well, that's sort of contradictory, as not all volumes in the library are
necessarily assigned to storage pools, in order to have a Pct Util.
But to list the volumes in storage pools, basically:
  Volumes, list by Pct Util             SELECT * FROM VOLUMES -
                                        ORDER BY PCT_UTILIZED

Embellish column headings or exclude columns as desired.

    Richard Sims, BU