Grouping Expressions again

Business categorization for your virtual environment

Grouping Expressions again

Veeam Logoby JWilliams » Tue Sep 17, 2013 2:06 pm

I am trying to setup business view in our environmnet and ran accross this post 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
JWilliams
Influencer
 
Posts: 10
Liked: never
Joined: Tue Sep 17, 2013 1:48 pm
Full Name: Jayme Williams

Re: Grouping Expressions again

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13255
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Grouping Expressions again

Veeam Logoby JWilliams » Tue 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
JWilliams
Influencer
 
Posts: 10
Liked: never
Joined: Tue Sep 17, 2013 1:48 pm
Full Name: Jayme Williams

Re: Grouping Expressions again

Veeam Logoby Vitaliy S. » Tue Sep 17, 2013 2:53 pm

Do you mean that you do not see the correct categorization in the expression result field?
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Grouping Expressions again

Veeam Logoby JWilliams » Tue Sep 17, 2013 3:01 pm

correct, i see SSC AMER - but no function like File Server
JWilliams
Influencer
 
Posts: 10
Liked: never
Joined: Tue Sep 17, 2013 1:48 pm
Full Name: Jayme Williams

Re: Grouping Expressions again

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13255
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Grouping Expressions again

Veeam Logoby JWilliams » Tue 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
JWilliams
Influencer
 
Posts: 10
Liked: never
Joined: Tue Sep 17, 2013 1:48 pm
Full Name: Jayme Williams

Re: Grouping Expressions again

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13255
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Grouping Expressions again

Veeam Logoby JWilliams » Tue Sep 17, 2013 4:11 pm

will do, thank you for your help and quick responses
JWilliams
Influencer
 
Posts: 10
Liked: never
Joined: Tue Sep 17, 2013 1:48 pm
Full Name: Jayme Williams


Return to Business View



Who is online

Users browsing this forum: No registered users and 2 guests