How about a select into the summary table:

Select entity, sum(bytes)/1024/1024/1024 as 'GB Migrated' from summary where 
activity='MIGRATION' and start_time>'2008-08-13 22:00' and end_time<'2008-08-14 
06:00' group by entity


Orville Lantto

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Killam, Perpetua
Sent: Thursday, August 14, 2008 9:48 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DSMC return codes broken in 5.4?

 Hi Andrew,

Is there a query to check how much data was migrated from disk to tape
every night?

We copy from disk to remote tape and something of the data from disk
spills into local tape.

I am looking for a query to tell me how of the data is spilled into
local tape? I can search the actlog but I'm looking to write a report
that would outline an estimate for over a month 

Thanks
Please let me know

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andrew Raibeck
Sent: 2008, August, 13 12:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DSMC return codes broken in 5.4?

First, run the query outside of a script to confirm the behavior, like
this:

   dsmc q b c:\file.txt
   echo %errorlevel%

If the errorlevel is 8, that would confirm that the script is not at
issue.

Next check your dsmerror.log for any warning messages that coincide with
the time you ran the query. If I were a betting man, my money would say
you are hitting the infamous ANS1009W DRM registry problem.

Best regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail:
storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan
ager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/12/2008
03:11:06 PM:

> I have a script that was tested in 5.3, but has been moved to a 5.4 
> client on windows. Where 'dsmc q backup c:\file.txt' would return 0 if

> there was a backup and 8 if there was not, it just returns 8.
> Anyone seen this weirdness?
>
> +---------------------------------------------------------------------
> +-
> |This was sent by njnorrgard AT mac DOT com via Backup Central.
> |Forward SPAM to abuse AT backupcentral DOT com.
> +---------------------------------------------------------------------
> +-
_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not 
waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains 
by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or 
otherwise) immediately.  

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce 
pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il 
contient par une personne autre que le (les) destinataire(s) désigné(s) est 
interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser 
immédiatement, par retour de courrier électronique ou par un autre moyen.





This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail.