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:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 13:54 To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] >Verzonden : woensdag , december 31, 2003 12:33 PM >Aan : [EMAIL PROTECTED] >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
