How to automatically set the VIP flag as true based on a users title.

[Demetrius Purn1]

Hello, 

I have enabled the VIP flag on the user record in ServiceNow and I am in need of some assistance with marking the flag as True for some users. I would prefer not to have to go through and manually check this flag if I can avoid it. How can I go about marking the VIP flag as True for a user based on their title on the user record? For instance, if a users Title is Territory Manager, I want their VIP flag to be set as True. I have included a small screenshot from our user record in ServiceNow. 

[Community Alums]

How are your users imported/created?

If this is done via an LDAP or Azure type of integration, you could do this in the transform map with a field script.

If you add users manually, or via some other process, you could write a business rule on the sys_user table to run on insert OR update, and if the title is one which should be flagged as a VIP, then update that checkbox value.

[Demetrius Purn1]

They are imported via Azure. 

[Community Alums]

If I recall correctly, with an Azure integration, the users are 'pushed' from Azure to Servicenow. The configuration is a bit of a 'black box', so there isn't much to do in the way of configuration- i.e no transform map. I could be wrong, though

So, I would likely approach this using a business rule, as I mentioned in my previous response. 

@Steven Parker Also provided a solution for the current users in the system

[Steven Parker · Accepted solution]

If you are looking to update the checkbox for VIP to be 'true' for users already in the instance, I would do it this way:

- Go to the System Security -> Users and add "VIP" field to the list view

- Filter the list by "Title contains Territory Manager"

- Check ALL users in the filtered list (scroll to bottom of list and check the final checkbox on bottom left to check ALL checkboxes)

- Right click a column header and choose "Update Selected"

- Change VIP to "True" on the next screen and then Update - This will update the VIP field for each checked user at once.

- Review the list view and make sure VIP is "true" for all these users

This will update all selected records on the users table to VIP = True (or checked).  You can update multiple records at once on any table using this method.  Some fields may not allow updating via this method, but most boolean or yes/no type fields will.