logo

The ConnectWise Control forum has moved to ConnectWise University! This forum has been locked and is in read-only mode. Click here for instructions on how to access the new forum.

Welcome Guest! You can not login or register.

Notification

Icon
Error

Options
Go to last post Go to first unread
shawnkhall  
#1 Posted : Friday, October 2, 2015 8:03:28 AM(UTC)
shawnkhall


Rank: Advanced Member

Medals: Level 1: Random Act of Kindness! Received One Thanks!

Joined: 2/6/2014(UTC)
Posts: 316
Man
United States

Thanks: 6 times
Was thanked: 33 time(s) in 29 post(s)
You can repeat expressions to accomplish more than one group within an IIF subgroup:

Code:
IIF(GuestOperatingSystemName LIKE '%Windows%', 'Windows', IIF(GuestOperatingSystemName LIKE '%Mac%', 'Mac', IIF(GuestOperatingSystemName LIKE '%Linux%', 'Linux','Other')))


You can concatenate values with "+". You can insert fixed strings by single-quoting them. As so:
Code:
GuestMachineDomain + ': ' + CustomProperty2
thanks 2 users thanked shawnkhall for this useful post.
Kostya on 10/15/2015(UTC), tonkabay on 2/21/2016(UTC)

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.