Automated method of AD attribute mapping

Reign9000

Hey guys, I am pretty new to OSTicket. We are moving from SolarWinds Web Helpdesk, we have had a couple of problems figuring out integration with our existing services (AD, AZURE AD Oath, Exchange online IMAP Oath, and smtp legacy auth) but were able to overcome those with some work. We are down to configuration and setup. we have a few remaining pieces we are working on sorting out how to get done. We have built an OSTicket install for our IT, Application support, and Facilities teams. We are integrating with AD/AZURE AD using the LDAP Authentication and Lookup as well as Oauth2 plugins. We have 14 sites and 450 users. What we are looking for is a way to either automatically import/update or programmatically automate an import/update AD user attribute (employee ID, phone number, Title, Department, Location, and Supervisor) to OSTicket User custom field. We have added the below custom form fields to the contact information form.

KevinTheJedi

Reign9000

Unfortunately we do not have attribute mapping nor AD syncing available. The LDAP Plugin expects the standard, default attributes for the Username, Email Address, and Phone Number only.

With this being said, you can import Users at any time via a CSV file or copy/paste of a CSV file's contents. Go to Agent Panel > Users > User Directory, click Import, and choose the option that best suits your needs. If a User doesn't exist it will create them automatically. If they do exist it will match on their email address and update the needed Custom Fields if they've changed or weren't set yet. On the CSV Import (Upload) tab it'll show you the Column format it expects (ie. the order of the columns).

Note:
If a User is created on Import they will be created as a Guest. You can either manually register them (and set their Authentication Source to LDAP) or send them an Account Registration Email so they can register themselves. With this being said, if they login via LDAP it will auto-Register them from Guest to Active (Registered). Also, if the User doesn't exist and they login via LDAP the system will auto-Register them. Reason being is they are considered pre-authorized Users.

Keep in mind Agents don't have Custom Fileds available at this time and they cannot be auto-Registered. Reason being is you have to define Department Access/Roles, Account Permissions, etc.

Cheers.

Reign9000

KevinTheJedi, thank you for the reply. Understood, I found the upload tab on the import users section under agent panel>users>user directory.

We can create an export of the needed AD attributes from powershell and make it available to the osticket host daily. In chatting with my team members one of them brought up that we could attempt to build a cron job that procs the import daily. we are wondering if anyone has ever tried this and if so would someone be kind enough to share their script (removing identifying information obviously).