Results 1 to 1 of 1
Thread: Show size of Inactive Files
09-14-2012, 03:52 PM #1
- Join Date
- Aug 2012
- Thanked 0 Times in 0 Posts
Show size of Inactive Files
I'm new to this board. I hope I'm posting in the right place.
I wrote a simple script which shows you the total # of inactive files for a node.
>select count(*) as Total from backups where node_name='$1'
But, what I'd like to do, is have another column which shows total size.. Is there a way to do this?
I also found this script online, which shows you a complete list..
> Select filespace_name as Filespace, hl_name as Directory,
ll_name as Filename, state as State from backups where
It would be great to also have a column for size.. Any ideas?
By Mirdas_M in forum TSM Documentation,Tips and TricksReplies: 1Last Post: 07-09-2008, 07:47 AM
By km92 in forum Backup / Archive DiscussionReplies: 1Last Post: 05-23-2007, 01:42 PM
By xefil in forum Backup / Archive DiscussionReplies: 5Last Post: 11-27-2006, 03:30 PM
By gravesm in forum ScriptingReplies: 2Last Post: 06-30-2006, 11:49 AM
By kimon in forum TSM ServerReplies: 1Last Post: 11-06-2002, 03:20 PM