Business categorization for your virtual environment
Post Reply
JWilliams
Influencer
Posts: 10
Liked: never
Joined: Sep 17, 2013 1:48 pm
Full Name: Jayme Williams
Contact:

Grouping Expressions again

Post by JWilliams » Sep 17, 2013 2:06 pm

I am trying to setup business view in our environmnet and ran accross this post http://forums.veeam.com/viewtopic.php?f=13&t=12780 which is exaclty what i want to accomplish. Unfortunantly the same expression is not working for me. This is what I am using:

Example VM: USNORMSDC09
Example VM: USCAMMSFS09

Case
When left(name,3) = "NOR" THEN "SSC AMER - "
When left(name,3) = "CAM" THEN "TCPC AMER - "
End

Case
When substring(name,7,2) = "DC" THEN "Domain Controller"
When substring(name,7,2) = "FS" THEN "File Server"
Else "Other"
End

I am only getting Uncategorized when testing. Im trying to sort by location which is the 4, 5 and 6th letter in names and then by function

v.eremin
Product Manager
Posts: 16342
Liked: 1344 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Grouping Expressions again

Post by v.eremin » Sep 17, 2013 2:17 pm

Hi, Jayme. As far as I can see, letters “D” (DC) and “F” (FS) are, in fact, 8th symbols not the seventh ones. So, the final version should look like this:

Code: Select all

When substring(name,8,2) = "DC" THEN "Domain Controller"
When substring(name,8,2) = "FS" THEN "File Server"
As to the first expression, from my perspective, it should be as the following:

Code: Select all

Case
When left(name,5) = "USNOR" THEN "SSC AMER - "
When left(name,5) = "USCAM" THEN "TCPC AMER - "
End
Thanks.

JWilliams
Influencer
Posts: 10
Liked: never
Joined: Sep 17, 2013 1:48 pm
Full Name: Jayme Williams
Contact:

Re: Grouping Expressions again

Post by JWilliams » Sep 17, 2013 2:45 pm

lol, may work better if i could count! SO now im using:

Case
When left(name,5) = "USNOR" THEN "SSC AMER - "
When left(name,5) = "USCAM" THEN "TCPC AMER - "
End

Case
When substring(name,8,2) = "DC" THEN "Domain Controller"
When substring(name,8,2) = "FS" THEN "File Server"
End

I am successfully getting the location but no function in the validation test

Vitaliy S.
Product Manager
Posts: 22527
Liked: 1475 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Grouping Expressions again

Post by Vitaliy S. » Sep 17, 2013 2:53 pm

Do you mean that you do not see the correct categorization in the expression result field?

JWilliams
Influencer
Posts: 10
Liked: never
Joined: Sep 17, 2013 1:48 pm
Full Name: Jayme Williams
Contact:

Re: Grouping Expressions again

Post by JWilliams » Sep 17, 2013 3:01 pm

correct, i see SSC AMER - but no function like File Server

v.eremin
Product Manager
Posts: 16342
Liked: 1344 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Grouping Expressions again

Post by v.eremin » Sep 17, 2013 3:52 pm

I might have been wrong in my assumption. May I ask you to try the original version of function and see whether everything works as expected:

Code: Select all

When substring(name,7,2) = "DC" THEN "Domain Controller"
When substring(name,7,2) = "FS" THEN "File Server"
Thanks.

JWilliams
Influencer
Posts: 10
Liked: never
Joined: Sep 17, 2013 1:48 pm
Full Name: Jayme Williams
Contact:

Re: Grouping Expressions again

Post by JWilliams » Sep 17, 2013 3:58 pm

i have changed to the following:
Case
When left(name,5) = "USNOR" THEN "SSC AMER - "
When left(name,5) = "USATL" THEN "SSC AMER - "
When left(name,5) = "USCAM" THEN "TCPC AMER - "
When left(name,5) = "CABUR" THEN "TCPC AMER - "
When left(name,5) = "USMOL" THEN "TCPF AMER - "
When left(name,5) = "USSEN" THEN "TCPF AMER - "
When left(name,5) = "USZEB" THEN "TCPF AMER - "
When left(name,5) = "CAHAW" THEN "TCPF AMER - "
When left(name,5) = "USDAY" THEN "GRASS AMER - "
When left(name,5) = "USAUS" THEN "GRASS AMER - "
When left(name,5) = "USCOM" THEN "GEO AMER - "
End

Case
When substring(name,7,2) = "AS" THEN "APP Server"
When substring(name,7,2) = "BK" THEN "Backup Server"
When substring(name,7,2) = "DC" THEN "Domain Controller"
When substring(name,7,2) = "EX" THEN "Exchange Server"
When substring(name,7,2) = "FS" THEN "File Server"
When substring(name,7,2) = "MG" THEN "Management Server"
When substring(name,7,2) = "PS" THEN "Print Server"
When substring(name,7,2) = "DB" THEN "SQL Server"
When substring(name,7,2) = "TS" THEN "Terminal Server"
When substring(name,7,2) = "WS" THEN "Web Server"
End

my expression results with USATLMSDC09 is SSC AMER -
The substring doesnt seem to be working but all the location in the first expression work fine

v.eremin
Product Manager
Posts: 16342
Liked: 1344 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Grouping Expressions again

Post by v.eremin » Sep 17, 2013 4:08 pm

In the way I see it, everything seems to be correct. You might also want to check upper/lower cases and see whether everything is written rightly. Otherwise, you might want to open a ticket with our support ticket and let them investigate it directly. Thanks.

JWilliams
Influencer
Posts: 10
Liked: never
Joined: Sep 17, 2013 1:48 pm
Full Name: Jayme Williams
Contact:

Re: Grouping Expressions again

Post by JWilliams » Sep 17, 2013 4:11 pm

will do, thank you for your help and quick responses

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest