Much appreciated.
 
Thanks!
 
 
 
Brendan Forsyth
Senior Systems Administrator
Poudre Valley Health Care
3702 Automation Way
Fort Collins CO 80525
bff AT pvhs DOT org 
(970) 495-7731 office
(970) 689-2503 cell


>>> Yaron Zabary <yaron AT aristo.tau.ac DOT il> 9/23/2009 4:20 PM >>>
Brendan Forsyth wrote:
> I am moving from cloning after each group completion to just making clones at 
> the end of the month for off-site storage.  Could someone share a query that 
> would generate a list of SSIDs for cloning the most recent full backups?

   I use the following perl script every night from cron (I deleted some 
redundant lines below):

#!/usr/bin/perl

require "timelocal.pl";

# The format of cloneq array is per mminfo's -q flag. This allows more 
flexability.

($sec,$min,$hour,$mday,$monx,$year,$wday,$yday,$isdst) = localtime(time());

$todaystart = timelocal(1,1,1,$mday,$monx,$year);

$satend = $todaystart - $wday*86400;
$satstart = $satend - 86400;

$cloneq{1} = "client=xenon.tau.ac.il";
$cloneq{2} = "client=aristo.tau.ac.il";
$cloneq{6} = "client=fas3050.tau.ac.il,name=/vol/mail,level=full";
$cloneq{7} = "client=fas3050.tau.ac.il,name=/vol/mail,level=1";
$cloneq{8} = 
"client=ex3.tau-centaur.tau.ac.il,name=MSEXCH:,savetime>$satstart,savetime<$satend";
$cloneq{9} = 
"client=ex3.tau-centaur.tau.ac.il,name=MSEXCH:IS/Academia2,savetime>$satstart,savetime<$satend";
$cloneq{10} = 
"client=ex3.tau-centaur.tau.ac.il,name=MSEXCH:IS/Minhal1,savetime>$satstart,savetime<$satend";
$cloneq{11} = 
"client=ex3.tau-centaur.tau.ac.il,name=MSEXCH:IS/Minhal2,savetime>$satstart,savetime<$satend";

unlink "/tmp/nsrclonessid";
open(SSID,">/tmp/nsrclonessid");

foreach $i (sort keys %cloneq) {

#  Find all ssid

   $nssid = 0;
   $query = "mminfo -ot -xc, -q '".$cloneq{$i}.",!incomplete,!ssrecycle' 
-r ssid |";
   #open(MMINFO,"mminfo -ot -xc, -q $cloneq{$i},!incomplete -r ssid |");
   open(MMINFO,$query);
   while ($ssid = <MMINFO>)
   {
      chop($ssid);
      $clientssid{$ssid} = 1;
      $nssid++;
   }

   close(MMINFO);

# Find ssid which were already cloned to the DataBank pool.

   $nssid = 0;
   #open(MMINFO,"mminfo -ot -xc, -q 
$cloneq{$i},!incomplete,pool=DataBank -r ssid |");
   $query = "mminfo -ot -xc, -q 
'".$cloneq{$i}.",!incomplete,!ssrecycle,pool=DataBank' -r ssid |";
   open(MMINFO,$query);
   while ($ssid = <MMINFO>)
   {
      chop($ssid);
      $clientssidc{$ssid} = 1;
      $nssid++;
   }

   close(MMINFO);

# Now see which ssid is not cloned.

   $nssid = 0;
   foreach $ssid (sort keys %clientssid) {
     if ($clientssidc{$ssid} == undef)
     {
        print SSID "$ssid\n";
        $nssid++;
     }
   }
}

close(SSID);
print "nssid = $nssid\n";
print "nsrclone -b DataBank -S -f /tmp/nsrclonessid\n";
system "nsrclone -b DataBank -S -f /tmp/nsrclonessid";


>  
> Thanks in advance.
>  
>  
>  
>  
>  
> Brendan Forsyth
> Senior Systems Administrator
> Poudre Valley Health Care
> 3702 Automation Way
> Fort Collins CO 80525
> bff AT pvhs DOT org 
> (970) 495-7731 office
> (970) 689-2503 cell
> 
> CONFIDENTIALITY NOTICE:  The information contained in this e-mail is 
> privileged and confidential, and is intended only for the use of the 
> individual or entity named above.  If you are not the intended recipient, you 
> are notified that any disclosure, copying, distribution, electronic storage 
> or use of this communication is prohibited.  If you received this 
> communication in error, please notify us immediately by e-mail, attaching the 
> original message, and delete the original message from your computer and any 
> network to which your computer is connected.
> 
> To sign off this list, send email to listserv AT listserv.temple DOT edu and 
> type "signoff networker" in the body of the email. Please write to 
> networker-request AT listserv.temple DOT edu if you have any problems with 
> this list. You can access the archives at 
> http://listserv.temple.edu/archives/networker.html or
> via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER 


-- 

-- Yaron.

CONFIDENTIALITY NOTICE:  The information contained in this e-mail is privileged 
and confidential, and is intended only for the use of the individual or entity 
named above.  If you are not the intended recipient, you are notified that any 
disclosure, copying, distribution, electronic storage or use of this 
communication is prohibited.  If you received this communication in error, 
please notify us immediately by e-mail, attaching the original message, and 
delete the original message from your computer and any network to which your 
computer is connected.

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER