help needed in settingup a Grouping Expression

[haroonh]

Hi,

I am new to VeeamONe and trying to set up a Grouping expression and need an urgent help in that.

e.g we have VMs names
BritVeeam01
USAVeeamo1

Would it be possible to use wild card when creating expression to search a VM as, I am not sure whether '*' could be used as a wild card operator but using it as an example below
Name = "*Veeam01"

Also would it be possible to use nested CASE statement to create nested groups in the ELSE Group bucket as below

CASE
WHEN LastBackupDate > DateAdd(Today, -1, "d") THEN "VMs with daily backup"
WHEN LastBackupDate > DateAdd(Today, -7, "d") THEN "VMs with weekly backup"
WHEN LastBackupDate > DateAdd(Today, -1, "y") THEN "VMs with yearly backup"
ELSE
CASE
WHEN Name = BritVeeam01 THEN "backup Servers"
ELSE "VMs with no backups"
END

Your help is greatly appreciated

Kind Regards,

[Shestakov]

Hi Haroon and welcome to the community!
Is your goal to break VMs into 5 groups: "VMs with daily backup", "VMs with weekly backup", "VMs with yearly backup", "backup Servers", "VMs with no backups"?
Should VMs from "backup Servers" group be part of "VMs with daily/weekly/yearly backup" groups?
I would create the groups with "Multiple conditions" option. You will need to use Backup RPO parameter rather than Last Backup Date.

[haroonh]

HI Shestakov,

Thanks for replying, really appreciate that.

My goal is to have a group which has the following conditions.
VMs with no backups
--- they are powered on
--- Name doesn't contain string "vpxy"
--- Name doesn't Contain string "_DR"
--- not backed up

I see, I can do that with multiple conditions Could you please explain what does it mean by Backup RPO as rest is ok but how would I define that VM wasn't backed up before.
Kind Regards,

[Shestakov]

Since you have several conditions for each group, it's easier to create the groups with wizard rather than with the grouping expression.
Difference between Backup RPO and Last Backup Date that first indicates how many hours past after the last successful backup and Last Backup Date indicates the day when the last successful backup took place.

[haroonh]

HI Shestakov,

Thanks for that,
Sorry I am very new to Veeam one and I am sorry if I misunderstood you, I am just trying to make one group which shows only the VMs which do not have a backup taken and have following conditions for that one group.
--- they are powered on
--- Name doesn't contain string "vpxy"
--- Name doesn't Contain string "_DR"
--- not backed up

Kind Regards,

[Shestakov]

Got it.
You can still follow multiple conditions option and create 1 group with the following grouping conditions:

Code: Select all

Power state equals Powered On
AND
Name doesn't contain "vpxy"
AND
Name doesn't contain "_DR"
AND
Backup RPO (Hours) < 99999

[haroonh]

Thanks for your help

[Shestakov]

No problem. Does it work as expected?