Last backup using NetBackup Grouping Expression

[t481]

Hi,
I'm trying to amend the last backup date to show VMs backed up using NetBackup which we use in addition to Veeam B&R. I tried amending the Grouping Expression as follows:

CASE
WHEN LastBackupDate > DateAdd(Today, -1, "d") THEN "VMs with daily backup"
WHEN LastBackupDate > DateAdd(Today, -7, "d") THEN "VMs with weekly backup"
WHEN ToDate(CustomAttribute("NB_LAST_BACKUP")) > DateAdd(Today, -1, "d") THEN "VMS with NetBackup"
ELSE "VMs with no backups"
END

The idea is that it would convert to date the value in the NB_LAST_BACKUP then report accordingly. It doesn't seem to work. What am I doing wrong and how can I fix this?

[Vitaliy S.]

Hi,

Can you please confirm that you have custom attributes containing NetBackup data collected in Veeam ONE? When you type in this expression, do you see any error message?

Thanks!

[t481]

I don't know. How can I check this? I assumed the Veeam ONE collects everything! If not, how can I tell it to do so?

[Vitaliy S.]

Can you please try to type in just this expression - CustomAttribute("NB_LAST_BACKUP")? Do you see any groups created based on the returned values?

[t481]

I've done that and now I'm only seeing "VMs with Weekly backup"

CASE
WHEN LastBackupDate > DateAdd(Today, -1, "d") THEN "VMs with daily backup"
WHEN LastBackupDate > DateAdd(Today, -7, "d") THEN "VMs with weekly backup"
WHEN CustomAttribute("NB_LAST_BACKUP") THEN "VMS with NetBackup"
ELSE "VMs with no backups"
END

[Vitaliy S.]

Actually, this is not what I meant. Can you please just type this - CustomAttribute("NB_LAST_BACKUP")? Does it return any values?

[t481]

CASE
WHEN CustomAttribute("NB_LAST_BACKUP") THEN "VMS with NetBackup"
END

Does not work. I get an error "invalid grouping expression"

Any chance we can get support to expedite this? I appreciate I've left it for a while as I had more pressing issues.

[Vitaliy S.]

Yes, sure our support team can assist you with this. Please open a case and tell me your case ID, so I could route your request to the corresponding team.

[t481]

Thanks @Vitality

I've raised Case #02194629 for this. Thank you.