Business categorization for your virtual environment
Post Reply
haroonh
Novice
Posts: 8
Liked: never
Joined: Mar 29, 2019 1:59 pm
Full Name: Haroon Hanif
Contact:

help needed in settingup a Grouping Expression

Post by 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
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: help needed in settingup a Grouping Expression

Post by 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
Novice
Posts: 8
Liked: never
Joined: Mar 29, 2019 1:59 pm
Full Name: Haroon Hanif
Contact:

Re: help needed in settingup a Grouping Expression

Post by 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
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: help needed in settingup a Grouping Expression

Post by 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
Novice
Posts: 8
Liked: never
Joined: Mar 29, 2019 1:59 pm
Full Name: Haroon Hanif
Contact:

Re: help needed in settingup a Grouping Expression

Post by 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
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: help needed in settingup a Grouping Expression

Post by Shestakov » 2 people like this post

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
Novice
Posts: 8
Liked: never
Joined: Mar 29, 2019 1:59 pm
Full Name: Haroon Hanif
Contact:

Re: help needed in settingup a Grouping Expression

Post by haroonh »

Thanks for your help
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: help needed in settingup a Grouping Expression

Post by Shestakov »

No problem. Does it work as expected?
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests