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 »

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

Re: Grouping Expressions again

Post by veremin »

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 »

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

Re: Grouping Expressions again

Post by Vitaliy S. »

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 »

correct, i see SSC AMER - but no function like File Server
veremin
Product Manager
Posts: 20271
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Grouping Expressions again

Post by veremin »

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 »

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

Re: Grouping Expressions again

Post by veremin »

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 »

will do, thank you for your help and quick responses
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests