Find all user ids of each Designer user

Issue

How can I find the user id of each user in Designer?

Solution

You can find the user id of each user in Designer using the following SQL query on the Repository database.

SELECT T1.C1201 as userid, T1.C1205 as loginname, T1.C1204 as fullusername, 
T1.C1260 as isadmin, T1.C1299 as isDeleted
FROM T1200 as T1

To determine the database name, the itprep.ini can be referred to. The location is:

..\KCM\Work\<version>\instance_nn\designer\config\itprep.ini

Directly modifying the Repository database is not supported.

Level of Complexity 

Moderate

Applies to