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: [email protected] Please consider the environment before printing this Email -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Lee, Gary D. Sent: Wednesday, March 10, 2010 5:02 PM To: [email protected] 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."
