"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 07/13/2007 10:23:42 AM: > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > Lawrence Clark > > a q node would show those clients that have not accessed the system > in > > some time. > > Yes, but if only a subset of filespaces are stale, QUERY NODE won't > differentiate them. > > A select statement is the best bet, and isn't that hard to set up as a > macro. >
Our problem around here is deleted filesystems. We seem to churn filesystems a lot. Those old filesystems hang around in TSM forever as long as the node exists. I use the following cmd that runs every morning in our morning report to look for these. It reports filespaces that haven't been backed up in 7 days. dsmadmc -se=<> -id=<> -password=<> -outfile=xxx$$ -tab -noc -quiet <<EOD select - node_name, - filespace_name, - filespace_id, - unicode_filespace, - cast((current_timestamp-backup_end)days as decimal(5,0)) - from - filespaces - where - cast((current_timestamp-backup_end)days as decimal(5,0)) \> 7 - order by node_name, - filespace_id EOD ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.