UNSOLVED

sasilik

updated

14 years ago

S

sasilik

33 Posts

0

15403

November 1st, 2012 02:00

Networker mminfo query and GUI save sets query

If I ask from Networker GUI, what save set are in some pool, then I get back answer with save set names and totalsize. One save set name even if this save set spans over two volumes. Can I get same result with mminfo or must I do myself some sort/grep/whatever magic with mminfo output to get wanted result? Because mminfo displays two rows with same save set name if save set spans over two volumes.

From GUI

server.domain saveset1 1619846705 1351657806 full browsable,cloned on 31.10.2012 6:30:06 LTO Ultrium-4 100016L4 (1000.0, h),100003L4 (57.0, t) week clone 960 GB 223 28.10.12 10:00:19 30.11.12 23:59:59

mminfo

server.domain saveset1 1619846705 1351657806 31.10.2012 6:30:06 100003L4 455 GB 983504789168

server.domain saveset1 1619846705 1351657806 31.10.2012 6:30:06 100016L4 504 GB 983504789168

  • masonb

    445 Posts

    3648

    0

    Posted November 1st, 2012 02:00

    Sasilik,

    Could you supply the mminfo command you are using so I can see what flags/query you have please?

    Regards,

    Bill Mason

  • sasilik

    33 Posts

    3648

    0

    Posted November 1st, 2012 03:00

    I used query:

    mminfo -o n -q "pool=week clone,savetime>10/27/12,savetime<10/30/12" -r clonetime(20),ssid,cloneid,client,name,level,state,volume,sumsize,totalsize

    I looked for options/flags to use from Command Reference guide and mminfo entry but didn't puzzle out any which I could use.

  • masonb

    445 Posts

    3648

    0

    Posted November 1st, 2012 03:00

    If you are not interested in which volume the saveset is on then I think if you omit volume from the mminfo command you will only get one entry (but I cannot test this to confirm).

    Also sumsize is not required as this gives a total for a saveset on a specific volume which I don’t think you need. Using totalsize should give the 960GB figure from the GUI - hopefully!

    Regards,

    Bill Mason

  • coganb

    736 Posts

    3648

    0

    Posted November 1st, 2012 04:00

    Hi,

    I tested this for a saveset spanning 4 volumes and from what I can see Bill is correct.

    mminfo -q "ssid=[ssid]" -r volume,sumflags,totalsize - gives 4 lines

    mminfo -q "ssid=[ssid]" -r ssid,name,cloneid,totalsize - gives 1 line

    Is this not what you're seeing?  Not what you want?

    -Bobby

  • sasilik

    33 Posts

    3648

    0

    Posted November 1st, 2012 04:00

    Things after -r won't change query result, only how many information is displayed. If I leave only -r ssid,cloneid then I get

    1619846705 1351657806

    1619846705 1351657806

    or

    server.domain saveset1 1619846705 1351657806

    server.domain saveset1 1619846705 1351657806

    if I add client and name.

    I guess the simplest way  to get desired result is to carefully choose minimum set of records I want to see with -r and then sort out duplicate lines. Which means there is no way to do it with only mminfo but I must apply sort/grep/whatever magic to the mminfo output.

  • sasilik

    33 Posts

    3648

    0

    Posted November 1st, 2012 06:00

    Okay, I take it back that things after -r won't change the result. But I don't know ssid at first. I want all save set's cloned at specific timeframe and from specific clone pool. As mminfo combines save set info only with query ssid=[ssid] then its no use for me I guess. Right now I can sort out unique lines from mminfo query:

       mminfo -o n -q "pool=week clone,savetime>10/27/12,savetime<10/30/12" -r ssid,cloneid,name,totalsize | uniqln -

    And it seems to be what needed.

    Also as these are cloned save sets and the "ssid=[ssid]" isn't enough(I got two save sets with same ssid but different coneid). I must use "ssid=[ssid],cloneid=[cloneid]". And at first I must get ssid and cloneid with my first mminfo query. And it kind of gets messier...

    As I saw how Networker GUI combined save sets  I presumed that maybe it uses also mminfo and I can get some onliner without any additional utility but seems that it is not so.

  • coganb

    736 Posts

    3648

    0

    Posted November 2nd, 2012 01:00

    Hi,

    You are correct - once you add the pool into the query either on the -q or the -r, then there will be one line per volume.  Using 'uniq' looks like the best way for you.

    -Bobby