Where is 'Username' for a person saved in the database?

lock
push_pin
done
Answered
4

Hi all.

Maybe I'm just blind, but I have no idea where to find 'username' for a given person in SuperOffice, once they have logged into CC.

Does anyone know where to look? :)

12 Mar 2025 | 03:28 PM

All Replies (4)

Hi Kasper

You are probably looking for the assiciate.name

associate Table (2)

12 Mar 2025 | 04:17 PM

Hi Georg.

I dont think they are saved there, since this is only (as I know) users of SuperOffice.

Im talking about regular people login into CC - they get a username. In the new service it is found under Task -> Manage Customer Center User.

 

12 Mar 2025 | 04:25 PM

I overlooked your reference to CC 

You find that name in crm7.USER_CANDIDATE.secret_key where person_id = your_person_id
https://docs.superoffice.com/en/database/tables/user-candidate.html

 

12 Mar 2025 | 05:09 PM
Thank you Georg. I would never has guessed this location. Weird to call username 'secret_key'.
12 Mar 2025 | 05:46 PM

Add reply