SearchFAQMemberlist Log in
Reply to topic Page 1 of 1
Help! Select statement syntax for legal reasons
Author Message
Post Help! Select statement syntax for legal reasons 
Hi Everyone,

I have a situation where someone wants to know what tapes particular people's backup data is on for our TDP for Mail backups for the time period from 7/08 - 1/09. The TSM client names are LNBRTZM3*5YR and the mail filesystem location is: mailx and the .nsf file names we are looking for are the training*.nsf and we need to know what tapes the data is on.


LNBRTZM335YR, mail1\training.nsf

LNBRTZM355YR, mail2\training2.nsf

Does anyone know what the syntax of this select statement would be to find this information? Any help is greatly appreciated as I was told I need this information by EOD and I'm not quite sure how to gather this from the TSM server side. My TSM server is on AIX and is at 5.5.5.0.

Any help is greatly appreciated!

Thanks in advance!

Joni


________________________________

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.

Post Help! Select statement syntax for legal reasons 
-----Joni Moyer wrote: -----

I have a situation where someone wants to know what tapes particular
people's backup data is on for our TDP for Mail backups for the time
period from 7/08 - 1/09. The TSM client names are LNBRTZM3*5YR and
the mail filesystem location is: mailx and the .nsf file names we are
looking for are the training*.nsf and we need to know what tapes the
data is on.


LNBRTZM335YR, mail1\training.nsf

LNBRTZM355YR, mail2\training2.nsf

Does anyone know what the syntax of this select statement would be to
find this information? Any help is greatly appreciated as I was told
I need this information by EOD and I'm not quite sure how to gather
this from the TSM server side. My TSM server is on AIX and is at
5.5.5.0.

TSM files on tape are more or less routinely moved to other volumes
by reclamation processing. As far as I can tell, there are three
possible ways of dealing with this possibility: suppress reclamation
of the volumes involved, send updates to the lawyers when and if
files are move to other volumes, or respond in bad faith by implying
that today's information will remain valid indefinitely.

Thomas Denier=

Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Magic SEO URL for phpBB