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.EDU] On Behalf Of Killam, Perpetua
Sent: Thursday, August 14, 2008 9:48 AM
To: ADSM-L < at > VM.MARIST.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.EDU] On Behalf Of
Andrew Raibeck
Sent: 2008, August, 13 12:14 AM
To: ADSM-L < at > VM.MARIST.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 < at > IBMUS Internet e-mail:
storman < at > us.ibm.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.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.com via Backup Central.
|Forward SPAM to abuse < at > backupcentral.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.
