UNSOLVED

CyndiS

updated

15 years ago

C

CyndiS

9 Posts

0

3955

June 14th, 2011 08:00

How to get listing of all files on a group of tapes

Hi,

I need to produce a "catalog" of sorts of all files on a group of tapes. I know I can easily get a listing of all savesets, but I need to get a listing of all files in those savesets.

Is there anyway to do this other than scanner? I am comfortable with command-line, but scanner just seems overkill (and takes a long time). The savesets are all still browsable, by the way...

Thanks, for any pointers.

Cyndi

  • CyndiS

    9 Posts

    1646

    0

    Posted June 14th, 2011 08:00

    Bill's suggestion is in the right direction and may be the only way, but what I really want it output that includes:

         filename

         tape number

         savetime

    "nsrinfo -v " will output the filename and savetime for each file in the index, but I would still have to figure out the tape number. Is there anyway to get the tape number in the output automatically?

    Thanks!

    Cyndi

  • masonb

    445 Posts

    1646

    1

    Posted June 14th, 2011 08:00

    Cyndi,

    As the backups are still browsable you can use nsrinfo to get the file details. If you use mminfo to get the nsavetime of the backup, you can then use this value with nsrinfo -t client name to list the file details for the saveset.

    Regards,

    Bill Mason

  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    1646

    0

    Posted June 15th, 2011 01:00

    Only with script, but information itself is pointlss to end user so I can't see the reasoning behind this.  Can you explain why would you need that info?

  • CyndiS

    9 Posts

    1646

    0

    Posted June 15th, 2011 08:00

    We have been asked to provide it for legal reasons. We need to be able to tell them which tape contains any given file.

    You mention a scripted way, what do you recommend? Be aware that, although I am a unix person from way back, I am forced to use Networker on a windows box...

    Thanks again,

    Cyndi

  • Holger_Inf

    1 Rookie

    •

    122 Posts

    1648

    0

    Posted June 15th, 2011 23:00

    You have a group of tapes and need the list of files on it?

    use mminfo -av -r nsavetime,client for every volume to produce your list of parameter for nsrinfo

    use nsrinfo -n All -t for every output from mminfo to produce your list of files

    if you need it often or need it for a lot of volumes you should script it, even on windows is this possible,

    but you can do these commands remote from any unix client too (must have networker client installed

    and rights to browse the CFI)

  • Holger_Inf

    1 Rookie

    •

    122 Posts

    1648

    1

    Posted June 16th, 2011 00:00

    You mentioned you need a formated output with volume,file and savetime.

    nsrinfo show savetime in the header line. but not a volume information

    You have to script it, mminfo and nsrinfo are not best tool to create formated output.

    nsrinfo does not know a volume information, this is linked to volume by saveset, and

    saveset is linked to index by clientname, savesetname, nsavetime and for every file

    the offset on media (info within cfi).

    You can produce excel sheets with the -xc; option, both commands understand this, output

    directed to a file with extension .csv. If you doubleclick this excel should open it formated,

    and possibly you can satisfy your requester with these files?

  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    1648

    0

    Posted June 16th, 2011 04:00

    Cyndi Smith wrote:

    We have been asked to provide it for legal reasons. We need to be able to tell them which tape contains any given file.

    You mention a scripted way, what do you recommend? Be aware that, although I am a unix person from way back, I am forced to use Networker on a windows box...

    Thanks again,

    Cyndi

    I'm aware of such legal requirement only for archived data, but not backup ones.  Sure, once that inspections comes, you can say:

    - yes, we can do that, our backup application keeps metadata on files with its own database.

    If they ask you to show them, go to restore window, change browse time, select file you want and select required volumes (or just do it from CLI).

    If you want to have list of files (which will be like millions at least) with each tape and tape position (which is possible by calculating offset I believe) will give you nothing in return - meaning you can hardly use it unless you wish to use it to know which tape to destroy.  I'm quite sure your legal reasons are misunderstood and approach taken is not correct.  I think the most important thing is that you can do it if asked, but you don't do it as that's what backup application as media manager does after all - and not operator/admin behind it.

  • CyndiS

    9 Posts

    1648

    0

    Posted June 16th, 2011 15:00

    Just because you do not understand the reason for a request does NOT mean that it is an invalid request. If you don't want to help, simply do not respond. Responding with an insulting (and unhelpful) answer is just plain rude.

    If you do not have anything constructive to add to the conversation, I would appreciate it if you would not insult me further by contributing such comments.

    Thank you,

    Cyndi

  • CyndiS

    9 Posts

    839

    0

    Posted June 16th, 2011 15:00

    This is very helpful! I think that, with a little playing around, I will be able to come up with something to get the info I need.

    Thank you very much!

    Cyndi

  • CyndiS

    9 Posts

    602

    0

    Posted June 16th, 2011 16:00

    I have actually been very exact in what I have said I need:

    For a set of tapes (note, I did not say for ALL tapes, just for a set), I need to produce a list of all files on those tapes with the tape number, the savetime and the file name (column order does not matter as I can rerrange at their whim if necessary). I just need those three items of information, more is OK because I can also delete it if it is not needed. I have said nothing about formatting, because I am perfectly capable of importing into excel or other software whatever the text file format.

    Why I need it is not important. There are very specific requirements to get exactly the above data. Just so you all will stop accusing me of not understanding that, in your opinion, the request does not make sense, I will tell you that I have explained that, baring any good suggestions from this group and other internet searches, it will be a laborious process, but that is of no concern to the requestors. We are being required to produce it no matter what effort it takes.

    All of the interpretations on this board of what the legal team really needs (and what they really meant) are assuming that they (and I) do not understand "how backup software works". I assure you, I have been a backup administrator for 20+ years and have been administering Networker itself for 10+. I understand how backup software in general, and Networker in particular, works, I just have never had exactly this requirement so reached out for help.

    FYI, much of the data is browsable, but some may have gone past its browsetime. Also, FYI, this should be a "one-time" request as these are tapes produced during a specific period of time and are all from a particular client.

    So, that said, any and all suggestions on how I can more easily do this are welcome, however, future comments implying that we do not really need this information will be ignored.

    Hopefully tomorrow I will have a chance to try to make mminfo/nsrinfo combo work in a script to get what I need. So far, that is the best suggestion I have had.

    Cyndi