Or you can try this:


                          Name: SINCELAST_FS
                   Line Number: 35
                       Command: select 
filespaces.node_name,filespaces.filespace_name as "Filespace_Name         
",date(filespaces.backup_end)as "Last
                                 Backup",capacity as "Capacity",pct_util as "% 
Used" from -
Last Update by (administrator): $$CONFIG_MANAGER$$
         Last Update Date/Time: 03/09/10   13:34:04

                          Name: SINCELAST_FS
                   Line Number: 40
more...   (<ENTER> to continue, 'C' to cancel)

                       Command:  filespaces where (($1 < -
Last Update by (administrator): $$CONFIG_MANAGER$$
         Last Update Date/Time: 03/09/10   13:34:04

                          Name: SINCELAST_FS
                   Line Number: 45
                       Command:  days(current_timestamp) - days(backup_end)) or 
-
Last Update by (administrator): $$CONFIG_MANAGER$$
         Last Update Date/Time: 03/09/10   13:34:04

                          Name: SINCELAST_FS
                   Line Number: 50
                       Command:  backup_end is null) and filespaces.node_name 
in (select nodes.node_name from nodes where domain_name=upper('$2'))
Last Update by (administrator): $$CONFIG_MANAGER$$
         Last Update Date/Time: 03/09/10   13:34:04


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT vm.marist DOT edu] On Behalf Of 
Grigori Solonovitch
Sent: Wednesday, March 10, 2010 8:14 AM
To: ADSM-L AT vm.marist DOT edu
Subject: Re: [ADSM-L] Filespace query

Try script or query from script:

define script A2_Last_Client_Backups description="List of last file space 
backups for nodes"
update script A2_Last_Client_Backups \
"set sqldisplaymode wide"
update script A2_Last_Client_Backups \
"select node_name, filespace_name, filespace_id, filespace_type, \
cast(substring(cast(backup_start as char(26)) from 1 for 16) as char(16)) as 
Started, \
cast(substring(cast(backup_end as char(26)) from 1 for 16) as char(16)) as 
Ended \
from filespaces \
order by node_name, filespace_id"

Grigori G. Solonovitch

Senior Technical Architect

Information Technology  Bank of Kuwait and Middle East  http://www.bkme.com

Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: G.Solonovitch AT bkme 
DOT com

Please consider the environment before printing this Email


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Lee, Gary D.
Sent: Wednesday, March 10, 2010 5:02 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Filespace query

Tsm server 5.5.4, clients range from 5.0 through 6.3.

Trying to construct a query to show me all windows nodes, whether they have a 
filespace systemobject or systemstate, and when it was last backed up.
Q filespace


Comes close, and maybe I'll just need to rattle that data around.

If anyone can help with this query, I'd appreciate it.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310



Please consider the environment before printing this Email.

"This email message and any attachments transmitted with it may contain 
confidential and proprietary information, intended only for the named 
recipient(s). If you have received this message in error, or if you are not the 
named recipient(s), please delete this email after notifying the sender 
immediately. BKME cannot guarantee the integrity of this communication and 
accepts no liability for any damage caused by this email or its attachments due 
to viruses, any other defects, interception or unauthorized modification. The 
information, views, opinions and comments of this message are those of the 
individual and not necessarily endorsed by BKME."