Move local users to Microsoft Oauth2 SSO

nicolafarina

Hi there,

with the latest osTicket release and OAuth2 plugin installed, I've successfully set up the mail fetch feature againsts our Microsoft 365 mailbox.

Now, I'm interested in evaluating to move our osTicket agents accounts to their Microsoft 365 ones. Two questions:

it there a way to map old users to new ones for tickets linking history?
do I need to set up a new OAuth2 instance for SSO or can I reuse the mail fetch one?

Thanks.

KevinTheJedi

nicolafarina

Via the UI you’d have to change the owner of all their tickets to a new user. Via the database it’s quicker.

No, SSO and Authorization are completely separate and require different instances. Please follow our documentation.

Cheers.

nicolafarina

Many thanks!

Any hint about the database method? Need to track down the user ID column and update it? If yes, in different tables?

Thanks again.

KevinTheJedi

nicolafarina

Actually, thinking about this deeper there are a lot more tables to update via the database so the easiest way would be through the UI. If you want to do this via the database you can review our ERDs below to see how the tables relate:

https://docs.osticket.com/en/latest/Developer%20Documentation/Database%20ERDs.html

Cheers.