AUTOMATION / POWERSHELL
Latest projects
Here are some of our previous projects, just click on the area of interest on the right to see examples.
On-/Offboarding
1. Script for the creation of new AD Users
User creation, assignment of attributes, phone number, membership, email alias etc., all dynamic so user creation is quick and easy.
2. Removal of licenses and disabling of the user
Removes or changes licenses in various systems via integrations. Also disables the user in various systems based on the required flows for each system.
Data management
1. Automatic reporting based on membership changes
When there is a change in membership, a report is created for UIPath (the RPA robot) in the form of an Excel sheet with the desired data, as well as emails that are sent to those responsible for the system if desired.
2. Active Directory users reports
Reports are created from Active Directory user data with all desired attributes and other info, combined and formatted to get a complete list.
Used for e.g. cleanup of old users & licenses, as well as general user changes.
3. Mass editing of Active Directory users
Updating large parts of AD users in the environment, by e.g. adding an email alias or changing address.
Integrations
Jira/TOPdesk
Integration between Jira / TOPdesk, where TOPdesk acts as the master that controls the data.
In Jira, cases from TOPdesk can be viewed, and priorities can be set which are sent back to TOPdesk, to help manage the order of tasks.
In this way, it is easier to control who can see and prioritize what, and it is easier to manage/limit permissions.
This was continuously expanded as more feature requests came in.
Office/Azure
1. Creation of shared mailboxes and resources
Creation and synchronization of mailboxes and resources for Office.
2. Office licensing via Active Directory membership
Licenses are managed via membership in Active directory, and synchronizes to Office where the license is changed automatically based on the memberships.
3. Permission management via Active Directory membership
Permissions for resources, mailboxes etc. are controlled via membership in Active Directory , thereby providing an easier overview and easier addition/removal of permissions, especially on large scale.
This means that you can avoid restrictions on how many people have rights to e.g. a resource, as the right can be added through groups.
PROCESS FLOWS
Case:
In the case of the on-/offboarding of employees, there was a lack of structure and overview, over what was done in the creation/closure of the user, as well as a lack of notifications to those who had to carry out the process, leading to users either being onboarded to slow or begin left open after their resignation.
Method:
First, the current process was reviewed, from which we made a list of what was currently working well, as well as what they had experienced as shortcomings.
Various departments who were given tasks when people were on-/offboarded were also involved and asked what and what information they needed, for it to be a work flow that works for them.
After clarification of requirements and wishes, we made a list of them, in a prioritized order, as well as a plan for when it should be implemented and various departments notified + trained in the new solution.
Solution:
In order to build up the structure and standardize the on-/offboarding process of employees, a form was made that the person’s superior fills in when on-/offboarding employees.
This form contained mandatory fields, as well as optional fields regarding user creation/removal in various systems.
This way it is ensured that all the necessary information is always available and easy to find for those who carry out the tasks.
After the form was created and the data it should contain was chosen, a standard email-/template was created for the tasks that had to be carried out to create/remove the employee in systems.
This form was made so that it covered most people’s needs, but could still be easily adapted to those who wanted different or additional information.
Then a script was created that could perform all the standard changes to the Active Directory user, as well as dynamically add or change more depending on what was selected/entered when the script was run.
In the end, a mail flow was created, which notified managers that they should create these processes, if, for example, a resignation date was registered. As well as sending out automatic emails to various departments about tasks that had to be carried out.
In this way, there was more structure and standardization for how this process should be carried out, plus the documentation and notifications were improved.
TOPdesk
Here you can see some of our previous TOPdesk projects, just click on the area of interest below to see examples.
1. Setting up forms
Setting up new forms and associated technology behind them.
Eg. on-/offboarding forms, hardware forms, and license request forms.
2. Automation for existing forms
Review of existing forms, and the creation of automation linked to it, to avoid human errors, as well as expanding what the form can do and what it integrates with.
Contact!
You are always welcome to send an email or give us a call, then we will take a look at it with you and find a solution together, or send you in the right direction if we cannot solve the task.