Hi Kurt!
That's what I thought too (in fact I issued a select * from restores) but it
returns a "No match found using this criteria" while I performed a restore
myself this morning...
Thanks!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines

-----Original Message-----
From: Kurt Beyers [mailto:kurt.beyers AT PANDORA DOT BE]
Sent: Wednesday, December 31, 2003 13:54
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL statement


Eric,

'select node_name, filespace_name, filespec from restores'

should give the wanted information.

best regards,

Kurt

>----- Oorspronkelijk bericht -----
>Van
: Loon, E.J. van - SPLXM [mailto:Eric-van.Loon AT KLM DOT COM]
>Verzonden
: woensdag
, december
 31, 2003 12:33 PM
>Aan
: ADSM-L AT VM.MARIST DOT EDU
>Onderwerp
: 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.
>**********************************************************************
>
>
>

--------------------------------------
Telenet Webmail opent je wereld