Automation : Role Assignment based upon the Department

[mehtaaaksha]

Hello Experts,

We have a requirement in Access Management where users should automatically receive access based on their department and onboarding wave dates. They should be added to a group "Location Access managment"

Example:

• Finance users onboarding on from 01.06

• Tech users onboarding from 08.06

• HR users onboarding  from 20.07

The requirement is:

1. Automatically identify and add users based on the department and onboarding date to the group.

2. Add new user which are onboarded later to the deapartment to the group as well 

3. Handle future onboarding waves dynamically through configuration instead of hardcoded logic.

We are considering:

• Flow Designer

• Scheduled Jobs

• Business Rules

Has anyone implemented a similar onboarding/access provisioning solution in ServiceNow ?

Looking for recommendations on:

• Best technical approach

• Scalability considerations

• Handling future onboarding batches efficiently

Any guidance or examples would be appreciated.

Thanks in advance.
@Ankur Bawiskar 

[Ankur Bawiskar]

@mehtaaaksha 

even if you use flow you will require some scripting so better go with daily scheduled job

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[mehtaaaksha]

@Ankur Bawiskar :

I am considering an approach using a decision table, where access will be provisioned based on the onboarding date. Additionally, if a new user is onboarded into the same department in the future, the required access will automatically be provisioned for them as well.

Note: Overall there are only six department.

[Tanushree Maiti]

Hi @mehtaaaksha 

Implementing department-wise employee onboarding in ServiceNow involves creating a centralized Order Guide to bundle catalog items, using Flow Designer to manage approvals and tasks, and using Variables/Variable Sets to capture department-specific requirements.

The Order Guide will include a department dropdown containing all available department options.

Based on the selected department and predefined rule-based logic, the corresponding catalog form will be displayed.

The form will allow users to provide generic request criteria through configurable variables.

Once the request is submitted, the workflow will be triggered automatically.

Sample Flow Steps:  ( customize it as per your requirement)

1. Trigger: Service Catalog (triggered when the Order Guide is submitted).
2. Get Catalog Variables: Retrieve the "Department" variable and others (e.g., hardware requirements).
3. Approvals:
   • Manager Approval (from variable set).
   • If department = "IT", add Security Team approval.
4. Task Creation (Department Wise):
   • IT Group Task: "Prepare Laptop and Credentials".
   • Facilities Task: "Prepare Desk".
   • HR Task: "Onboard New Staff".
5. Wait for Task Closure: Ensure tasks are completed, using the Wait condition for parallel tasks.
6. End Flow: Notify the hiring manager of completion