I see in the Table Tickets, all unsigned Tickets has owned_by 1.
But if i see the Table ejuser, the User ID 1 belongs to our one certain User.
How to make difference with both, if we allocate new Tickets to this User?
Not sure how your entry in ejuser looks, but unless something very strange has happened ejuser with id = 1 should be (System) and not any "real user".
Main scenario mentioned in this FAQ can explain this behaviour.
on the bottom of this FAQ can you also find an SQL query that can help you.
Thanks for your Information!
I don't now how ejUser ID = 1 for <Real User> by us happened,
but if i look our other SO Cloud Tenants, there are correctly ejUser ID = 1 for (System) in the Table.
and I cannot diable Service to that Real User, it says the User has open or postponed Tickets, the License cannot be removed.
I can change all Tickets Owner of that real user to other ejuser where ejuserID = 1 with SearchEngine, since it is still test system. But I cannot re-create a system User via SearchEngine from my side, it is in SO Cloud.
I will ask our Support in Germany to proceed that with SQL Scripts.