Detailed information of "job_statistics" request

[oleg.feoktistov]

Hi,

You could use /querySvc endpoint to construct precise queries for such cases.

<WarningsJobRuns>:

Code: Select all

/api/query?type=BackupJobSession&filter=result==warning&format=Entities&sortAsc=name&pageSize=15&page=1

<FailedJobRuns>:

Code: Select all

/api/query?type=BackupJobSession&filter=result==failed&format=Entities&sortAsc=name&pageSize=15&page=1

Best regards,
Oleg

[oleg.feoktistov]

Hi,

Are you using Enterprise Manager with Enterprise Plus license?
Enterprise Plus license is required for REST to work correctly.
Also, make sure the account you access REST with have enough privileges.
The list of roles can be found here.

Thanks,
Oleg

[neerajkhosla]

Hi Oleg

I have another question here. I can see the following information contained in the response of job_statistics api.

Code: Select all

    <BackupJobStatusReportLink>Workspace/ViewReport.aspx?definition=7962844d-db6c-4d29-8b6e-4e0f7db0785f&amp;ShowParams=1</BackupJobStatusReportLink>

ViewReport.aspx seems to be a web page and it can be accessed through the browser. But how to construct the complete URL of this link, so that it can be accessed ? Or there is some other way to access it.

Thanks in advance.
Neeraj

[oleg.feoktistov]

Hi,

It looks like this is a service parameter, which cannot be consumed with REST API. Otherwise, it would make more sense to just put a whole link there. Can I offer you to have a look at excel report on job statuses mentioned here in Note section? It's not a precise analogue, but may have something interesting to offer.

Thanks,
Oleg

[neerajkhosla]

Hi Oleg

Thanks for the reply. Actually, my intention was to access the following report somehow using code, and without any manual intervention. I want to prepare different reports based on this data. Please check the link below.

https://prnt.sc/_OC9l3VwcA7l

[oleg.feoktistov]

We don't have any specific API call to download this report, but you can try Mimic report from our github community repo. It is coded in Powershell and generates the same data you are looking for. Thanks!