doing a Grouping Expression

[sknano]

Hello world,

I'm french, so excuse my english.
I have this architecture on my esxi server.

I would like to create 3 folders in "Grouping Expression" like:

Code: Select all

Case
When (foldername) = "TEST" THEN "TEST"
When (foldername) = "PROD" THEN "PROD"
When (foldername) = "MODELES" THEN "MODELES"
When (foldername) = "BACKUP" THEN "BACKUP"
Else "Other"
End

What is the issue for me, please? Where can i found all options of "Grouping Expression" ?

Thanks a lot.

[veremin]

Unfortunately, nowadays there is no such VM property, like a folder name, in the Group Expression.

So, in order to achieve what you’re after you have to:

1. Create four different BW groups. (Test, Prod, Modeles, Backup)
2. Create four different rules. (Test, Prod, Modeles, Backup)
3. In Rule Wizard select corresponding folders to which these rules should be applied. (Rule "Test" should be applied to folder "Test", etc.)
4. Assign rules to corresponding BW groups. (Rule "Test" should be assigned to group "Test", etc.)

That’s all.

Additionally, the abovementioned parameter (foldername) will be added to the VM Group Expression in VeeamOne v7.

Hope this helps.
Thanks.

[sknano]

Thanks a lot
it is perfect

[marc0castr0]

How would I achieve the same results in veeamone v8?

Something like this?

Case
When (folder) = "TEST" THEN "TEST"
When (folder) = "PROD" THEN "PROD"
When (folder) = "MODELES" THEN "MODELES"
When (folder) = "BACKUP" THEN "BACKUP"
Else "Other"
End

[Vitaliy S.]

Marco, do you want to tag your VMs based on their folder location?

[marc0castr0]

Only by folder. However, nothing is set in stone. Therefore I can tag any which way that would help achieve the result i need.

[Vitaliy S.]

Try to use this expression:

Case
When ToUpperCase(folder) = "TEST" THEN "TEST"
When ToUpperCase(folder) = "PROD" THEN "PROD"
When ToUpperCase(folder) = "MODELES" THEN "MODELES"
When ToUpperCase(folder) = "BACKUP" THEN "BACKUP"
Else "Other"
End

[marc0castr0]

Vitaliy, thanks for your response.

The below expression gave me the results in the screenshot...
Additionally, i am also providing a screenshot of my vcenter folder structure

Case
When ToUpperCase(folder) = "AD" THEN "AD"
When ToUpperCase(folder) = "CUST AD" THEN "CUST AD"
Else "Other"
End


===

[Vitaliy S.]

Can you tell me what is returned as a value when you select just "Folder" in the grouping expression? Also are there any other subfolders in AD, CUST AD folder?

P.S. btw, can you try to run the same query, but in version 8?

[marc0castr0]

Hi, this is version 8 and there are no subfolders inside of "cust ad"

I changed the expressions to below and still no luck.


Case
When Folder = "TEAM_SERVER" THEN "TEAM_SERVER"
When Folder = "CUST AD" THEN "CUST AD"
Else "Other"
End

Let me ask, is there a easier way to get same results? Like Tagging the VM?

[Vitaliy S.]

This is not version 8, at least it is not the RTM code of v8. In the GA version we have a different icon for grouping expression wizard. Could this be a beta version by any chance? What is the build number of your installation?

[marc0castr0]

Hmmm... odd. see screenshot below

[Vitaliy S.]

Hmm... let's open the case and see why you have a different UI in Business View, maybe issues with categorization via folders is related to this one. In my lab, I have no problems with the expression above. Can you please let me know your case ID once you contact our technical team?

[marc0castr0]

Done!

Here is the id: 00688863

[marc0castr0]

Vitaliy, THANK YOU VERY MUCH!

[marc0castr0]

Sir, what about tagging the VM as opposed to folders?

[Vitaliy S.]

If you're already using vSphere tags to categorize your VMs and these tags are created for these VMs, then you can BV groups based on the tags as opposed to VM folders.

If you're NOT using vSphere tags and you're running on the latest vSphere version, then you can follow this tip to categorize your VMs based on VM tags.

See this topic for more info > ONEbelievable tricks: Veeam ONE and Automation Services (VM tags in Veeam ONE and Veeam B&R)