Networker : Schedule Daily Backup status report

You can use NMC, you can use nsrsgrpcomp, or you can use some custom script - up to you.

Thank you Crvelin,

Could you please share any script to generate a daily report for the last 24 hrs backup status.

What do you really want?

- A save set report can be easily created by running the appropriate mminfo command:

     mminfo -q "savetime=>-1days" -r "client,name,savetime ......." -oc 

- An activity report would result in extracting the appropriate information from the jobs db/savegroup log files.

   Such requires additional effort which is not easy at all. Let me recommend that you check BackupEagle for this purpose:

   Schmitz RZ Consult

   We have made very good experiences with this product.

Hi Bingo

Thankyou for the suggestion.

But is there any free tool from EMC Networker to schedule the daily alerts for the backup status and recovery.

Hi Crvelin,

Just we need the below info on daily basis for last 24 hours.Please help

Client name

Group name 

Schedule  

Starttime       

Endtime        

BackupStatus 

kotamsetty wrote: Thank you Crvelin, Could you please share any script to generate a daily report for the last 24 hrs backup status.

Nope, you will need to do that as you (or your client) has such need.  But you need to ask yourself what exactly do you need?  You say clients, but is it success of backup only or additional data?  If additional data, what exactly?  Most of the data you can get from mminfo, but media database might not include data for failed backups which went to disk or failed at savefs level for example.  This basic monitoring can also be handled by NMC.  You need to define exactly what you need and from there it is easy.  If you want data from job db, you can run nsrsgrpcomp -c

This is not something which is easy to achieve. The reason is simple: You need to query different databases for that purpose:

This is info from the resource db:

  Client name    

  Group name 

  Schedule

However, the info about  

  Client name    

  Group name 

  Starttime       

  Endtime        

  BackupStatus 

is/can only be obtained from the jobs db.

Sorry but I am pretty sure that nobody will provide you a script for free.

However, the general roadmap would be:

  - prepare a list of all clients (would be dynamic)

  - use nsradmin to prepare the first part (for each client) - only if you really need the schedule

  - use jobquery to get the second part 

    (since you work with NW 8.2.1 you might succeed running an appropriate SQL command.

  - prepare/sort the output

Approach 1: Write your own script -

Create a small Batch/Perl script to capture the output of below command -

mminfo -q"sscreate>=24 hours ago" -r"client,name,group,sscreate(23),sscomp(23),ssretent,ssflags,level,totalsize"

This will give you the out put of last 24 hours backup details with all the details that normally a backup report should have-

Note: SSFlags is for save set status , completed/incompleted, browsable, recyclable etc

Review this output and edit as per your choice (for example : Removing the save set for Index and bootstrap backup, exclude archive backup or some special group client. ) and after that you can format also this output as per your choice (ex: .csv file, html format ) and can keep that in a centralize location or send an email as attachment. Just put the overview statistic also in your report - Total no of saveset, % of success rate, Total size, Client wise backup size, backup timing window etc

Just schedule this script from your windows task scheduler for daily report.

Approach 2: Use of DPA -

Using the EMC DPA tool you can use generate your customize backup report for the Networker backup. It not only include the daily backup report but also so many other backup related report which is useful for backup administration. DPA is not only used for Networker monitoring but also some other features also. Its very user friendly tool and also having all kind of easy reporting features.
More info -

• i)  https://www.google.be/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0ahUKEwj8g63QicDJAhXDng4KHXMqARIQFggeMAA&url=http%3A%…
• ii) Data Protection Advisor - Data Protection Management - EMC

@ kotamsetty

Honestly, I do not know any free tool except "NetWorker Reporter" EMC Legato NetWorker and IBM Storwize Reporting Utilities.

We have tried to use DPA some years ago, especially to monitor the true size of Avamar backups. But we found it is pretty complicated to deal with, especially if you want to produce a report which is not provided with the product. Besides that, we did not test it any further.

Also - do not forget that in your list

  Client name

  Group name 

  Schedule  

  Starttime       

  Endtime        

  BackupStatus 

you miss an important detail - this list of not started groups because they are still running. The risk is high to have some, especially for backup groups with a (very) small interval.

@shubhadip_datta

Thanks Bingo ,

could you please help me on this below part -

(since you work with NW 8.2.1 you might succeed running an appropriate SQL command : How can we run sql query on jobdb

Regards,

Shubhadip Datta