Re: SQL statement

Hi Andy!
Thank you very much for this query, it shows enough information to satisfy
the requesting department.
Thanks!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines

-----Original Message-----
From: Andrew Raibeck [mailto:storman AT US.IBM DOT COM]
Sent: Wednesday, December 31, 2003 18:29
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL statement


Hi Eric,

There is no such table that gives you detailed information on which files
were restored. The SUMMARY table will give you basic statistics about
restores (SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE') but that's about
it.

Regards,

Andy

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

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




"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/31/2003 05:33
Please respond to "ADSM: Dist Stor Manager"

        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        SQL statement


Hi *SM-ers!
I'm looking for an SQL statement which returns all restores (nodes and
filenames) done by my clients.
I'm not much of an SQL wizard, so maybe someone is willing to help me or
give me a hint?
Thank you very much in advance!!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee only. If
you are not the addressee, you are notified that no part of the e-mail or
any attachment may be disclosed, copied or distributed, and that any other
action related to this e-mail or attachment is strictly prohibited, and
may be unlawful. If you have received this e-mail by error, please notify
the sender immediately by return e-mail, and delete this message.
Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any delay in
receipt.
**********************************************************************