UNSOLVED

grickels

updated

20 years ago

G

grickels

26 Posts

0

855

July 31st, 2006 07:00

Exporting volume information to file

Is there a way to export the volumes with tape names, indexes on the tapes, and date of those backups? I'm trying to create a seperate spreadsheet with this info so that I can go through and reuse some of those tapes. This would be easier than clicking through each volume and writing down the individual volumes with this info.

Thanks!
  • grickels

    26 Posts

    439

    0

    Posted July 31st, 2006 08:00

    I think I found a command that will give me close enough to what I want:

    mminfo -N

    I was really wanting a command that would list every tape and then the save sets on that tape, but I haven't been able to put together a good command yet. If anyone has any suggestions please let me know.
  • blochner1

    19 Posts

    439

    0

    Posted July 31st, 2006 10:00

    here's one I run regulary:

    mminfo -a -ot -r "volume(10),pool(12),ssid,savetime,ssretent,client,name" -q "savetime savesets.txt
  • davise

    30 Posts

    439

    0

    Posted July 31st, 2006 11:00

    isn't there a switch on MMINFO that even exports with the delimitter of your choice?
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    439

    0

    Posted July 31st, 2006 14:00

    Yes, use -x for that and specify either XML output or the obe with custom separator.
  • jherlihy

    21 Posts

    439

    0

    Posted July 31st, 2006 16:00

    Yep - to make your output comma delimited you can use -xc,

    If you wanted to create output every day for all volumes which you could then import into excel, I'd probably use something like:

    mminfo -a -ot -xc, -r volume,client,group,"savetime(20)",ssretent,"totalsize(4)",level,name > nsrvol-20060801.csv

    You could then just open it straight up in excel.

    HTH,
    John