Return Silk Central Test Manager users and their assigned roles

0 Likes

There is no pre-written report that will return a list of Silk Central Test Manager users and the roles they are assigned to. This information is retrieved from the following tables:

SCC_Roles, SCC_UserGroupRoles and SCC_Roles.


Please note that access to the table "SCC_Users" via Silk Central has been restricted in SCTM 12 and later versions. You will receive the error message "Invalid query: Usage of table 'SCC_Users' prohibited" if you try to access the table in a report.

However you will be able to access these details straight from the database.


The following SQL query can be used to return users and their assigned roles:


SELECT SCC_Users.Login, SCC_Users.FirstName, SCC_Users.LastName, SCC_Roles.RoleName
FROM SCC_Roles LEFT OUTER JOIN
SCC_UserGroupRoles ON SCC_Roles.RoleID_pk = SCC_UserGroupRoles.RoleID_pk_fk
RIGHT OUTER JOIN SCC_Users ON SCC_UserGroupRoles.UserID_pk_fk = SCC_Users.UserID_pk

In versions prior to Silk Central Test Manager 12.0, it is possible to access the 'SCC_Users' table in a report.


Old KB# 35436

Comment List
Anonymous
Related Discussions
Recommended