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:[EMAIL PROTECTED]
Sent: Thu 10/30/2003 2:53 PM
To: [EMAIL PROTECTED]
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
