Do you mean, "Missed/failed Monday & Tuesday, succeeded on Wednesday,
Missed/Failed on Thursday and Friday?" If that's the case, I don't know of
any way to get that other than querying the actlog. You might try,
q actlog begind=-15 endd=today begint=00:00 endt=23:59 msg=4954 s=nodename
to find out which days it completed backups, then you can inferr that the
other days it missed or failed, depending on what the events say. If it's a
TDP client, you might try
q actlog begind=-15 endd=today begint=00:00 endt=23:59 msg=4990 s=complete
and grep it to look for your nodename.
I hope this answers your question.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
(503) 745-5091 fax
-----Original Message-----
From: Richard Sims [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 10:54 AM
To: [EMAIL PROTECTED]
Subject: Re: Query to know how many days backup or archive is not made .
>I need a query that shows how many days that a node doesn't backup or
archive.
>It is very different, to ask how many days that a node is not connecting
the Server of ADSM .
Juan - You can do Query FIlespace F=D, or the equivalent Select on the
Filespaces table, and determine when the last backup was done.
Another approach is to delve into the Archives and Backups tables,
though that's more voluminous.
Richard Sims, BU
