Legato Networker

[Robert-Jan Goossens]

Hi All,

Situation
I've got 60 clients connected to two servers all running Networker 7.1. One win2000 server and one Unix server. Both systems are connected to multiple robots.

Management would like an automated monthly report of failed file sets per client.

Question
Would it be possible to use mminfo or a different networker command to extract this kind of information from the legato database? Or does somebody know of a different method to accomplish this kind of information in an automated process?

Best regards,
Robert-Jan

[guna_1]

Hi Robert,

You can retrive the failed saveset name from the message file "daemon.log" ( in unix , you find normally under /nsr/logs ). So you daily check this log for failed saveset and collect this info another file and report to management monthly , this can be accomplish by a simple shell script.

With regards,
Guna

[Robert-Jan Goossens]

Hi Guna,

Thanks for the information. I need a bit more detailed information. Grepping from the daemon.log file resulted in an overkill of results ( like test backups ). I'm only intrested in one specific pool.

Here is what I have so far.

# mminfo -avont -c client01 -q "pool=Unix Normaal" -q "savetime>=08/01/04 00:00:01,savetime<=08/31/04 23:59:59" | awk '{ print $2" "$3" "$8}'

client date lvl
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 tb
clien01 08/20/04 hb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 ca
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 tb
clien01 08/20/04 hb
clien01 08/21/04 cb
clien01 08/23/04 hb
clien01 08/23/04 tb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 hb
clien01 08/23/04 tb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb
clien01 08/19/04 cb
clien01 08/20/04 cb
clien01 08/20/04 cb
clien01 08/21/04 cb
clien01 08/23/04 cb
clien01 08/24/04 cb
clien01 08/24/04 cb
clien01 08/25/04 cb
clien01 08/25/04 cb
clien01 08/26/04 cb
clien01 08/26/04 cb
clien01 08/27/04 cb
clien01 08/27/04 cb
clien01 08/28/04 cb
clien01 08/30/04 cb

These are all save sets from last month. The marked with "*a" are arborted.

# mminfo -avont -c client01 -q "pool=Unix Normaal" -q "savetime>=08/01/04 00:00:01,savetime<=08/31/04 23:59:59" | awk '{ print $2" "$3" "$8}' | grep "[a-z]a"

client date lvl
clien01 08/19/04 ca

results in one save set aborted last month for this client.

Can somebody help me to count the percentages ?

Regards,
Robert-Jan

[H.Merijn Brand (procura]

# mminfo -avont -c client01 -q "pool=Unix Normaal" -q "savetime>=08/01/04 00:00:01,savetime<=08/31/04 23:59:59" | perl -aF -e'@f=@F[0,2,7];$f{$f[0]}++;$f[2]=~/a$/ and$e{$f[0]}++;END{for(sort keys%f){printf"%-10s%9d%6d %6.2f\n",$_,$f{$_},100*($f{$_}/($f{$_}-($e{$_}||0)))}}'

Kan niet testen, heb geen invoer.
Probeer maar

Enjoy, Have FUN! H.Merijn

[H.Merijn Brand (procura · Accepted solution]

I took your list as input and changed it to:

# perl -aF -ne'@f=@F;$f{$f[0]}++;$f[2]=~/a$/ and$e{$f[0]}++;END{for(sort keys%f){printf"%-10s%9d%6d %6.2f\n",$_,$f{$_},($e{$_}||0),100*(($f{$_}-($e{$_}||0))/$f{$_})}}' < xx.uit
clien01 575 1 99.83

returning that to your call should make:

# mminfo -avont -c client01 -q "pool=Unix Normaal" -q "savetime>=08/01/04 00:00:01,savetime<=08/31/04 23:59:59" | perl -aF -ne'@f=@F[0,2,7];$f{$f[0]}++;$f[2]=~/a$/ and$e{$f[0]}++;END{for(sort keys%f){printf"%-10s%9d%6d %6.2f\n",$_,$f{$_},($e{$_}||0),100*(($f{$_}-($e{$_}||0))/$f{$_})}}'

produce similar output
For now I have ignored the character before the a (or whatever it is)

Enjoy, Have FUN! H.Merijn

[Elmar P. Kolkman]

In our case we do it by using the notifications. I cannot post the scripts themselves, but you and Merijn are quite capable to work those out. ;-)
Just put some script (perl, awk, etc) in the savegroup completion notification, and you get your notification the moment the savegroup completes.

[Elmar P. Kolkman]

As requested, an example. Create an awk script with the following content:

/--- Successful Save Sets ---/ { unsucc=0 }
unsucc==1 { print }
/--- Unsuccessful Save Sets ---/ { unsucc=1 }

Then create an extra savegroup notification:
Customize->Notifications
View->Details
Add
Select only savegroup. And in the action, tell:
awk -f And of course define a name, etc.

That should do the trick. Take a look at the current savegroup notification (mailx, by default) to get the idea.