William,
Have you ever looked into ITSRM. Here is a brief description of its
capibilities, one of which is the ability of file level analysis.
Managing Storage Resources Across the Enterprise
Tivoli SRM is designed to manage the heterogeneous storage environments found
in most organisations. There are many tools that can monitor a single storage
device or operating system. There are even more tools that monitor multiple
devices or operating systems from multiple user interfaces. Only Tivoli SRM
monitors and manages storage resources enterprise-wide from a single user
interface.
Designed for the open enterprise, Tivoli SRM provides a breadth and depth of
features not found in other storage resource management (SRM) solutions.
* Implementation Flexibility
* Cross-Platform Analysis from a Single Interface
* Capacity Planning
* File level analysis
* Automation
* Customised Reports
* Database Analysis
* Availability Reporting
* Chargeback
The Tivoli SRM strategy is focused on providing:
* Software that is easy to use and scales to the largest, most complex
environments
* Software that is hardware, operating system, and DBMS “agnostic,”
supporting all leading technologies
* Solutions that are cost effective to deploy
* Service and support that exceeds our customers expectations
-----Original Message-----
From: William Goliak [mailto:wgoliak AT MIDWAY.UCHICAGO DOT EDU]
Sent: Thu 10/30/2003 2:53 PM
To: ADSM-L AT VM.MARIST DOT EDU
Cc:
Subject: SQL select question
Does anyone have a way to determine the total amount of files and data
used by a specific file type across the server? In particular, mp3's
but
there are other questionable data types.
I realize that this will be an extremely time consuming select but you
gotta do what you gotta do.
-Bill Goliak
Tsm Server Admin
Office: 773 702 9425
Pager: 773 652 0744
"The two key words for tonight are Caution and Flammable," Elvis, Bubba
Ho-tep
|
