Business categorization for your virtual environment
Post Reply
sknano
Lurker
Posts: 2
Liked: never
Joined: Apr 30, 2013 10:21 am
Full Name: sknano
Contact:

doing a Grouping Expression

Post by 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
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: doing a Grouping Expression

Post by veremin » 1 person likes this post

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
Lurker
Posts: 2
Liked: never
Joined: Apr 30, 2013 10:21 am
Full Name: sknano
Contact:

Re: doing a Grouping Expression

Post by sknano »

Thanks a lot
it is perfect
marc0castr0
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by 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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: doing a Grouping Expression

Post by Vitaliy S. »

Marco, do you want to tag your VMs based on their folder location?
marc0castr0
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by 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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: doing a Grouping Expression

Post by 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
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by 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


===

Image
Image
Image
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: doing a Grouping Expression

Post by 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
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by 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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: doing a Grouping Expression

Post by 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
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by marc0castr0 »

Hmmm... odd. see screenshot below


Image
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: doing a Grouping Expression

Post by 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
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by marc0castr0 » 1 person likes this post

Done!

Here is the id: 00688863
marc0castr0
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by marc0castr0 »

Vitaliy, THANK YOU VERY MUCH!
marc0castr0
Influencer
Posts: 17
Liked: 1 time
Joined: Nov 25, 2014 9:48 pm
Full Name: Marco Castro
Contact:

Re: doing a Grouping Expression

Post by marc0castr0 »

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

Image
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: doing a Grouping Expression

Post by 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)
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest