What is User Type in the below query
Can anyone have any idea about what is "User Type" in the below query? Is it based on General User or Admin user?
default_home_workspace_id = '<input the workspace id>'
, default_home_dashboard_id= '<input the dashboard id>'
WHERE user_type_id='1' and
default_home_workspace_id is null and
default_home_dashboard_id is null
- 6.x help
- 6.x reference
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
- Solutions and Use Cases
- use case
- use cases
[user_type_id] is a column in the tblUserType table.It defines the type of the user like '1' for General User, '2' for Service Account, '3' for System Admin User, '4' for Datafeed accounts, etc.,.
You can find the dependencies from the tblUser table. That will give you an idea on the tables.
You can run the query against the tblUser table to find out what type the user is. You will find the [user_type_id] column with a value.
select * from tblUser
where user_username like '%John%'