I use this to count files by client per tape:
select volume_name,node_name,count(file_name)
as #files from contents where
volume_name=upper('$1') group by
volume_name,node_name
This lists client's files on a given tape:
select node_name,file_name as "File Name
" from co
htliner, LLC
(503) 745-6850 phone/vmail
-Original Message-
From: Gerald Wichmann [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 11:24 AM
To: [EMAIL PROTECTED]
Subject: TSM Query to determine what is on a single tape
Given a tape, is there a select query that will tell me what servers hav
Given a tape, is there a select query that will tell me what servers have
data on that particular tape? It'd be nice to know what file systems as well
but that level of granularity isn't necessary. I.e. I have tape XYZ, I run
query and find out CLIENTA, CLIENTB, and CLIENTC have data on it.
Geral
