try slight variations of these...
Dwight
select node_name,filespace_name,cast((backup_end) as varchar(10)) as "Date"
from adsm.filespaces where (cast((current_timestamp-backup_end)day as
decimal(18,0))>2 )
select node_name,cast((lastacc_time) as varchar(10)) from adsm.nodes where
(cast((current_timestamp-lastacc_time)day as decimal(18,0))>2 )
-----Original Message-----
From: Rajesh Oak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:44 AM
To: [EMAIL PROTECTED]
Subject: Server Script
I need a script that will give me report of all the nodes that were not
backed up for a specific time. It should be similar to the one that gives a
report on all clients that have not accessed the Server for a specific time.
If anyone can post it or send it to me I would really appreciate it.
Thanks in advance.
Rajesh Oak
P.S. I am running TSM Server 4.1 on Windows 2000 SP1.
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
