Endpoint: BJobs latest_result -1 meaning?

[BBRG]

Hello

In order to monitor Veeam Endpoint, we query Veeam's database.
The query is

Code: Select all

SELECT bj.id, bj.name, bj.latest_result FROM BJobs bj

and the results are

Code: Select all

xxxx,Backup Job,-1

We initially thought that latest_result possible values were 0 (OK), 1 (Incomplete) and 2 (Crashed) but we did not expect the -1 value.

So, what's the meaning of this value?

[Dima P.]

Hello BBRG,

I am sorry, but I can’t comment internal components, their structure and logic.

[BBRG]

Hello Dmitry

Thank you for answering that quickly

Is there any way for us to get to this information?
We already mailed the Veeam support and they leaded here.

Thanks in advance

[Dima P.]

May I ask why you want to query the DB instead of using windows events or email reports? Thanks.

[BBRG]

Sure, we develop a software named RG Supervision which role is to probe servers and workstations to be able to alerts our users (mostly IT managers) when a problem occurs.
One of these probes is dedicated to monitor Veeam backups and we are having some trouble with this state, and since we want to provide the most suitable monitoring for Endpoint, we wanted your expertise on the subject.
To monitor Veeam jobs (and not history), we need to query the MSSQL DB, more precisely the Bjobs table. And the "-1" state that we sometimes fetch is confusing for us.

[Dima P.]

Thanks. SQL DB is our internal source so things may change from version to version (and you won’t be notified), so I'd say its a bad place to rely on from development perspective.

Still interested why windows events won’t work for you? We designed existing events specifically for integration with third-party monitoring tools: https://helpcenter.veeam.com/docs/agent ... tml?ver=20

[BBRG]

Thank you for the reference
As our software may be installed way after Veeam, we want to know the current state of the Veeam jobs.
But since there might be a lot of Veeam events before finding all the job events that have been running, it would take a lot of compute time to fetch all of these.
This is why we are looking for a "what is the current state of all Veeam jobs" function, and the SQL DB was suitable for our case.
Is there another, less clumsy and more supported, way to get this information?