select node_name as "Nodes with no filespaces:", -
date(reg_time) as "Registered:", -
date(lastacc_time) as "Last Access:" -
from nodes where node_name not in -
(select node_name from filespaces)
-----Original Message-----
From: Rajesh Oak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:53 PM
To: [EMAIL PROTECTED]
Subject: Server Script
Does anyone have a script that can report all the clients that have never
backed up. No Filespaces are present for that node.
I am running TSM 4.1 on WIn2000 Sp1.
Thanks in advance.
Rajesh Oak
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
