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.

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|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

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.

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

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.