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:
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"
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?