Veeam Availability for Nutanix AHV 1.0. Email notifications

[veremin]

Challenge:

Currently, Veeam Availability for Nutanix AHV 1.0 does not support Job Email Notifications. To resolve this until the feature is implemented, a script has been developed to provide Daily Email Reporting Functionality.

Solution:

Refer to this KB article.

[Lapa]

Script is a good crutch, but it works strange.

There is an SQLite quiery in it (line 117):

Code: Select all

policy_stopped_events = (van_db_cursor.execute('''select task.Name, task.ProgressAsJson from DtoEvent as event inner join DtoTask as task on json_extract(event.ParametersAsJson, '$[0].Value') = task.Uid where event.DateUtc >= date('now', '-1 days','start of day', 'utc') and event.DateUtc <= date('now', 'start of day', 'utc') and (event.LogEventType in (?, ?) ) order by event.DateUtc desc;''', (EventType.BackupStopped.value, EventType.BackupError.value) )).fetchall()

I have modified it to add jobs for today, adding a date option DateUtc <= date('now','+1 days', 'start of day', 'utc')

So my quiery looks as:

Code: Select all

policy_stopped_events = (van_db_cursor.execute('''select task.Name, task.ProgressAsJson from DtoEvent as event inner join DtoTask as task on json_extract(event.ParametersAsJson, '$[0].Value') = task.Uid where event.DateUtc >= date('now', '-1 days','start of day', 'utc') and event.DateUtc <= date('now', '+1 days', 'start of day', 'utc') and (event.LogEventType in (?, ?) ) order by event.DateUtc desc;''', (EventType.BackupStopped.value, EventType.BackupError.value) )).fetchall()

Today is 11.09.2019 13:00

The script report send me following output:

Code: Select all

Job	                                        Start time	                Result
NTNX_Apps2 - No Tape	        9/11/19 1:00:00 AM	Success
NTNX Terminals1 - No Tape	9/10/19 8:00:48 PM	Success
NTNX_Terminals2 - No Tape	9/9/19 9:00:00 PM	Success
NTNX_Apps2 - No Tape	        9/10/19 1:00:01 AM	Success
NTNX Terminals1 - No Tape	9/9/19 8:00:49 PM	Success
NTNX_Apps2 - No Tape	        9/9/19 1:00:00 AM	Success
NTNX_Exchanges4	                9/8/19 11:00:00 PM	Success
NTNX_Filers6	                        9/8/19 11:00:00 PM	Success
NTNX_Terminals2 - No Tape	9/8/19 9:00:00 PM	Success

Why it includes record for Job task "NTNX_Terminals2 - No Tape" started at 9/8/19 9:00PM and ended up 9/9/19 2:45AM?
and Job Task "NTNX_Filers6" (see log below)

Code: Select all

9/8/19 11:00:00 PM	Job starting
9/9/19 4:15:00 AM	Backup finished

But NOT includes record for FAILED Job task "NTNX Terminals1 - No Tape" which i started manually at 9/11/19 11:39AM and then cancel to get a Failed job for test. Log below:

Code: Select all

9/11/19 11:39:04 AM	Job starting
9/11/19 11:44:40 AM	i907svts88 : Backup was unsuccessful. Preparing VM for backup failed, 1.
9/11/19 11:44:41 AM	Job canceled

What can be wrong?

[Coldfirex]

Lapa - Did you ever figure this out?

Veremin - Any updates to this script?

[veremin]

Veremin - Any updates to this script?

The script has not been updated since we posted it. But can you tell me what exact updates you're looking for? Thanks!

[jialvarez]

Hi,

I was searching for the script to describe a details of the machines inside the job that finished ok in the report, because I only get the name of the job saying that goes OK, but no detail about which machines are inside the job. Is this possible?

thanks!

[veremin]

I'm not the author of the script, but to me it seems that it collects the errors and warnings generated within backup policy and then displays this information for failed VMs or VMs processed with warnings. So, this part can be potentially re-written to collect the same information for successfully processed VMs as well. Then, it's just a matter of adding these details to resulting report. Thanks!

[veremin]

The Veeam Availability for Nutanix 2.0 has been released. It has native notification capabilities, so, I'm unsticking this thread. Thanks!