How to add list of all roles to custom Dashboard?

[Miikka_M]

Hi, 

I'm making a dashboard for my client. They want to monitor all their active, inactive roles, what roles users has ect. in this dashboard. 

I'd like to make a report to this dashboard of all roles which can be found from sys_user_role_list.do. There is 619 of them.

However, when I try to make a dashboard report of that sys_user_role_list.do, I can only find data table sys_user_has_role, which does not show all the roles, only roles which has users (this is also useful, but I'd also like to make a single score widget containing all of the roles)

So my question is; how to make a single score widget to dashboard from all of the data what can be found from sys_user_role_list.do?

Thanks for answers, 

Miikka

[Miikka_M · Accepted solution]

Solved this. 

You need to add sys_user_role to system property: glide.ui.permitted_tables -value list.

After that this property can be found from Dashboard Tables list.

Hope this helps.