A script enabled browser is required for this page to function properly.
Skip to main content
STA User Interface Guide, v1.0.2
E28380-03
Table of Contents Previous Next Index


Using STA to Answer Tape Environment Questions : Capacity and Resource Management Questions : ▼ Report Media Cartridges Approaching Capacity

▼

Report Media Cartridges Approaching Capacity

This procedure addresses the questions, “Which media cartridges are over 90 percent full? How do I generate a list that can be used to create a script to eject them from the library?”

STA reports cartridge capacity and available space as numerical values only, not as percentages. This procedure provides instructions for exporting the numerical values to a spreadsheet application, which can then be used to calculate percentages. The resulting list can be used by a cartridge eject script.

Referenced Tasks

•
“Apply a Template”
•
“Sort by a Column”
•
“Export Table Data to a Spreadsheet”
1.
In the Navigation Bar, select Media > Overview.

2.
In the Templates menu, apply the “STA-Media-Utilization” template.

This template includes the “Media MB Available” and “Media MB Capacity” attributes.

3.
In the “Media MB Capacity” column, click the Sort Descending arrow.

The cartridges with the highest capacity are brought to the top of the list. This sort also has the advantage of grouping cartridges by media type, since capacity tends to vary by media type.

4.
To create a list that can be used by a cartridge eject script, you must use an external spreadsheet application. Use the following steps to export the data displayed in the table to an HTML-based Excel-compatible file.
a.
Click the Export icon in the Table Toolbar.

b.
Save the file to a location on your local computer.
5.
Using a compatible spreadsheet program, add a “Percentage Full” column, containing calculated values derived from the attributes in the exported table. Sort the table by the column values and identify a list of cartridges over 90 percent full.
Table of Contents Previous Next Index Link to documentation
Copyright © 2012 Oracle and/or its affiliates. All rights reserved. Legal Notices