Hi ! Here's a couple of shell scripts that you could possibly use to achieve your goal, without much stress ...
1)sizing.sh dsmadmc -id=admin -pass=password -datao=yes -tab select \'export node \', node_name, \'filespace=\',filespace_name, \'preview=yes filedata=allactive\' from filespaces where filespace_type not like \'API%\' > /tmp/toto # tr -s '\t' ' ' <toto >toto1 sed "s/= /=/" toto1 > toto # cd /tmp CMD="dsmadmc -id=admin -password=password" cat toto | while read input do $CMD $input done 2)sizing2.sh dsmadmc -id=admin -pass=password -datao=yes -tab q act begind=01/14/2005 begint=12:18 s=\"export node running\" >active_data Note1 : you could possibly modify the select statement in 1st script to make it match your needs (in my example TDP data is excluded ...) Note2 : take care, you're going to start MANY export processes parallely, if having lots of filespaces/nodes : here again you can modify the select statement to reduce the scope of it (per domain, mode name, whatever ...) You should first launch sizing.sh, and note the day and time where you started it. When all of the export processes will be completed, modify the "begind" and "begint" variables in "sizing2.sh" script so that they reflect your start date and time for the first script, and let it run ... The output file "active_data" will give you all what you need ! Probably not the most elegant solution, but it works ! Cheers Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of scottcorp Sent: Friday, 07 September, 2007 00:29 To: [email protected] Subject: Re: Full Backup Size Report Thanks again to all - the "export node nodename filedata=backupactive preview-yes" works, but I would love to get this into a SQL statement or something so I dont have to look at the console or actlog to retrieve the output. I have been trying for a few hours to get this going but have never really written a SQL code before, so needless to say I am not doing very well. +---------------------------------------------------------------------- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +----------------------------------------------------------------------
