I generate a report once a month that shows me all the filesystems that have not been backed up in more than 30 days. I can look through the list and pick out the hosts that I know should be backing up.
Here is the select statement I use (likely borrowed from this forum). select node_name, Filespace_name, (current_timestamp-backup_end)days as "days_since_backup" from filespaces where cast((current_timestamp-backup_start) days as decimal) >=30 order by "days_since_backup" Ben -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Cloward Sent: Friday, November 10, 2006 11:36 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Days Since Last Access Yeah, I am in the same boat, I have too many nodes that do not backup, anbd no way to know unless I look in the failure report that gets e mailed out. Best thing to do is check the filesystem and see the last time It was accessed and backed up, the hitting the server info means meta data was sent and the system said yeah Im here, its the filesystem that tells you what is really going on. Jeremy Friday, November 10, 2006 1:32 PM To: ADSM-L@VM.MARIST.EDU cc: From: "Kauffman, Tom" <[EMAIL PROTECTED]> Subject: Re: [ADSM-L] Days Since Last Access We had a system that was connecting to the server 4 times a day, so last access was always less than 1. I crashed and burned, got rebuilt -- and the most recent backup was 15 months old. And I *still* can't get the NT admins to check the logs on any regular basis. Tom Kauffman NIBCO, Inc -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Friday, November 10, 2006 12:17 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Days Since Last Access "Days since last access" just tells you the last time there was communication between the client and the server. It doesn't tell you anything about whether the client was backed up, or not. The communication could have been a single restore; or it could be the client scheduler just checking for a backup time. Or you could have a client backup that started, but did not complete successfully. To verify whether the client has been successfully backed up, look at q filespace nodename f=d Look for the "last backup end" date for each client filesystem to see when it last backed up. Wanda Prather "I/O, I/O, It's all about I/O" -(me) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Friday, November 10, 2006 11:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Days Since Last Access hello, When I do a q node to find out what nodes are being backed up, I see that "<1" means it is being backed up properly. But at times I see "1" , "2", "3" ......" some big number " without "<" attached to it , my question is what is the definitive number to say it is still being backed up without digging through the details I have been told that "1" .. up to "3" is still ok. Thank you for clarifying. Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Access Password Set ------------------------- -------- -------------- ---------- --------- ------- DAT03TEST WinNT STANDARD <1 235 No EOSNOTE1 WinNT STANDARD 1 240 No ESSMOC04 WinNT STANDARD 653 855 No Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 ext 28164 ************************************************************************ ************************** The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ************************************************************************ ************************** CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.
