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.



Go to last post Go to first unread
#1 Posted : Tuesday, February 13, 2018 10:09:36 PM(UTC)

Rank: Newbie

Joined: 11/29/2015(UTC)
Posts: 2
United States

We will be on boarding about 400 clients that are spread out over 55 locations. We would like to create tags for each location name ahead of time to make the process easier. If I can have them built ahead of time the names will appear int he tag pulled own on install and eliminate tags created from typos. I cannot seem to find a way to do this. Is this doable?

#2 Posted : Wednesday, February 14, 2018 4:01:02 AM(UTC)

Rank: Newbie

Joined: 1/28/2016(UTC)
Posts: 37

Was thanked: 5 time(s) in 5 post(s)
We use an subgroup expression using the IP address to determine location.

iif(SUBSTRING(GuestNetworkAddress, 1, 5)='10.1.', 'Site A', iif(SUBSTRING(GuestNetworkAddress, 1, 8)='10.111.1', 'Site B', iif(SUBSTRING(GuestNetworkAddress, 1, 7)='192.168', 'Site C', iif(SUBSTRING(GuestNetworkAddress, 1, 6)='10.222', 'Site D', iif(SUBSTRING(GuestNetworkAddress, 1, 6)='10.2.1', 'Site E', iif(SUBSTRING(GuestNetworkAddress, 1, 6)='10.3.1', 'Site F', iif(SUBSTRING(GuestNetworkAddress, 1, 12)='', 'Site G', iif(SUBSTRING(GuestNetworkAddress, 1, 8)='10.10.10', 'Site H', iif(SUBSTRING(GuestNetworkAddress, 1, 8)='10.20.30', 'Site J', 'Remote/Other')))))))))

With 55 locations, the nested IIF would get long, but it is nice that it's dynamic. If new clients come online in one of the sites, it is automatically sorted accordingly.

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.