logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

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


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?
chriscamp  
#2 Posted : Wednesday, February 14, 2018 4:01:02 AM(UTC)
chriscamp


Rank: Newbie

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

Was thanked: 4 time(s) in 4 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)='10.222.222.1', '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.

Thanks,
Chris
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.