Integration OTRS + AD to create users

Moderator: crythias

Post Reply
tallesleonardo
OTRS newbie
Posts: 24
Joined: 23 May 2013, 03:25
OTRS Version?: versao 6.0.19
Company: Hepta
Location: Brasília, BRAZIL

Integration OTRS + AD to create users

Post by tallesleonardo » 24 Jul 2019, 00:01

Hello,

I wonder if anyone has done this kind of integration between OTRS and AD so that through data filled in OTRS users are created with the proper permissions in AD? Or through WebService with PowerShell to run scripts that can get objects from DynamicFields?

Today I am using OTRS in version 6.0.19 with MySQL database.
Talles Leonardo
OTRS 6.0.19 on Linux with MySQL database

root
Moderator
Posts: 1854
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Integration OTRS + AD to create users

Post by root » 24 Jul 2019, 17:06

Hi,

I recommend using Powershell and request the data to create new users from OTRS via the GenericInterface. Should be the approach with least amount of work.

- Roy
OTRS 5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Do you need professional services for the ((OTRS)) Community Edition? Check out https://www.znuny.com/

tallesleonardo
OTRS newbie
Posts: 24
Joined: 23 May 2013, 03:25
OTRS Version?: versao 6.0.19
Company: Hepta
Location: Brasília, BRAZIL

Re: Integration OTRS + AD to create users

Post by tallesleonardo » 24 Jul 2019, 19:15

Hi,


Actually I need to create these users in AD. I need to get DynamicFields values ​​and send them to AD for user creation.
Talles Leonardo
OTRS 6.0.19 on Linux with MySQL database

root
Moderator
Posts: 1854
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Integration OTRS + AD to create users

Post by root » 25 Jul 2019, 06:47

Hi,
  • Create a process ticket with needed data in dynamic fields
  • Import the GenericInterfacREST webservice (https://github.com/OTRS/otrs/blob/rel-6 ... orREST.yml)
  • Write a Powershell script to find all open tickets in the appropriate activity
  • Create the user with Powershell
  • Update the ticket with the proper attributes, a note, etc.
- Roy
OTRS 5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Do you need professional services for the ((OTRS)) Community Edition? Check out https://www.znuny.com/

crythias
Moderator
Posts: 10109
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Integration OTRS + AD to create users

Post by crythias » 25 Jul 2019, 21:17

Just a thought: if you have an external (Active Directory) back end, you don't need to "create" users (customers?) and you can map AD Attributes to CustomerUser fields. It works rather seemlessly, almost by default.

CustomerGroupsAlwaysGroups is another hint.

It's pretty slick with Apache SSO, too.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask

tallesleonardo
OTRS newbie
Posts: 24
Joined: 23 May 2013, 03:25
OTRS Version?: versao 6.0.19
Company: Hepta
Location: Brasília, BRAZIL

Re: Integration OTRS + AD to create users

Post by tallesleonardo » 25 Jul 2019, 21:47

So in this case I am trying to automate the process of creating users in AD through OTRS, so the Analyst doesn't have to go to AD to create them. Because this is a very recurring demand in the company where I work, and sometimes is causing bottlenecks. Therefore, I would like OTRS to take the user information entered in DynamicFields and automatically register users with their information, either through WebService, PowerShell, etc. Is this kind of interaction possible?
Talles Leonardo
OTRS 6.0.19 on Linux with MySQL database

operations
OTRS newbie
Posts: 1
Joined: 28 Mar 2019, 15:19
OTRS Version?: KIX17
Real Name: Oliver Krahe
Company: Syscovery solve@serve GmbH

Re: Integration OTRS + AD to create users

Post by operations » 26 Jul 2019, 13:16

Hello Everybody,

I would be interested in that too.
Also thinking about a selve service on the customer page or during ticket creation on the Agent frontend.

Also for Users who leave the Company, I would like to have the same for deleting/archiving Users.

Greatings
OK
Grüße
operations

best regards
operations

crythias
Moderator
Posts: 10109
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Integration OTRS + AD to create users

Post by crythias » 30 Jul 2019, 07:36

tallesleonardo wrote:
25 Jul 2019, 21:47
So in this case I am trying to automate the process of creating users in AD through OTRS, so the Analyst doesn't have to go to AD to create them. Because this is a very recurring demand in the company where I work, and sometimes is causing bottlenecks. Therefore, I would like OTRS to take the user information entered in DynamicFields and automatically register users with their information, either through WebService, PowerShell, etc. Is this kind of interaction possible?
You ... want OTRS to be the master user source for building Active Directory users?
There's no built-in provision for that, and leads to some security concerns, too.

It's near trivial to go the other way, though. And by populating AD, OTRS automatically gets the user information.

And if you must build it, you're halfway to data entry directly into AD anyway. The PowerShell interface that puts the data into AD can be fed to OTRS at the same time if you wish... https://docs.microsoft.com/en-us/powers ... w=win10-ps
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask

tallesleonardo
OTRS newbie
Posts: 24
Joined: 23 May 2013, 03:25
OTRS Version?: versao 6.0.19
Company: Hepta
Location: Brasília, BRAZIL

Re: Integration OTRS + AD to create users

Post by tallesleonardo » 30 Jul 2019, 16:14

crythias wrote:
30 Jul 2019, 07:36
And if you must build it, you're halfway to data entry directly into AD anyway. The PowerShell interface that puts the data into AD can be fed to OTRS at the same time if you wish... https://docs.microsoft.com/en-us/powers ... w=win10-ps
In fact, I have created a process that automates ticketing based on the number of users listed to be created in AD. My real need is to take the filled values ​​in the dynamic fields (Name, ID, Phone, etc.) and send this information automatically to AD upon user creation.
Talles Leonardo
OTRS 6.0.19 on Linux with MySQL database

root
Moderator
Posts: 1854
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Integration OTRS + AD to create users

Post by root » 30 Jul 2019, 18:27

Hi,

Never heard of "sending information to AD". Please specify how the data should be transferred from OTRS.

- Roy
OTRS 5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Do you need professional services for the ((OTRS)) Community Edition? Check out https://www.znuny.com/

crythias
Moderator
Posts: 10109
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Integration OTRS + AD to create users

Post by crythias » 31 Jul 2019, 15:43

tallesleonardo wrote:
30 Jul 2019, 16:14
crythias wrote:
30 Jul 2019, 07:36
And if you must build it, you're halfway to data entry directly into AD anyway. The PowerShell interface that puts the data into AD can be fed to OTRS at the same time if you wish... https://docs.microsoft.com/en-us/powers ... w=win10-ps
In fact, I have created a process that automates ticketing based on the number of users listed to be created in AD. My real need is to take the filled values ​​in the dynamic fields (Name, ID, Phone, etc.) and send this information automatically to AD upon user creation.
And I'm saying the same human interface that fills in OTRS to do this should be able to fill in AD, which OTRS can use.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask

Post Reply