Savegroup Backup report for Networker 8

Question

Hi, I am planning to redefine the backup report for our environment. Hence I need some inputs/guide from you to implement that - My Requirement is - I) It should capture all manual/schedule savegroup backup. Client initiate manual save is not required. II) Even if any savegroup is disabled or skipped for a particular day due to skip schedule should be reflected. III) For a particular savegroup all the clients backup details should be reflected. For example below can be a sample format - savegroup | client | save set | start time| End time| level | Sum size | Status | .... We can capture this from mminfo. but lets say one client backup is failing or aborting before start it will not reflect on mminfo. But I want to capture those also. Thanks & Regards, Shubhadip Datta

ble1 · Answer

You can use jobquery for specific group.  If you keep for or longer of 24h job records, you could probably extract all data from there.  But I suspect you will most likely (it is easier) combine both job and mdb data into single set by creating two arrays of data and then merging them in final report.

talkwithshubha · Answer

Thanks Hrvoje for your inputs.

You are almost correct that I need the report as left outer join in between savegroup job and save job out put on key job id and parent job id.

So lets say one group (xyz) is having 3 clients - a,b,c with 3 save set- /fs1,/fs2,/fs3

Now lets assume client a fully backed up, client b is partially backedup, and client c not backed up (lets assume not reachable)

Then reports looks like below -

group|client|saveset|status

xyz|a|\fs1|succeeded

xyz|a|\fs2|succeeded

xyz|a|\fs3|succeeded

xyz|b|\fs1|succeeded

xyz|b|\fs1|Failed

xyz|c| |failed

But the problem is both the jobquery output is in linear text format.

Is there any way so that I can create csv file from jobquery output?

Or can we use any sql api/ script to query jobdb separately ?

Thanks & Regards,

Shubhadip Datta

ble1 · Answer

As far as I remember jobquery is like nsradmin so you can't get to csv format.  I know that in 9.x most likely one should switch to REST API queries as that seems to be the future and this is now coming with NW9, but in NW8 you are still left with scripting around different outputs from different databases.

talkwithshubha · Answer

Thanks again for your feedback.

In some of your previous post you mentioned that you had used some Swiss knife script to translate such nsradmin output into csv format.

If you can share some details on this script will be really grateful then.

Thanks & Regards,

Shubhadip Datta

ble1 · Answer

Actually I made a script, but not for reports, but rather operations.  For reports I extract data for client and feed it into mysql DB.  However, with NW9 I think I will change that in future as NW9.2 is supposed to have same thing which I can easily extract then (I believe I saw it comes in XML format) and then push it anywhere I want.

NetWorker

Was this post helpful?