Solved

Report on role membership

  • 17 February 2020
  • 1 reply
  • 143 views
R

I'd like to create a report in K2 that shows all the K2 roles along with the members of those roles. This is to allow audit teams to review that we have assigned the correct memberships.

Is there a SmartObject I can use within K2 five or another recommended way to do this?

Thanks

icon

Best answer by Esmari 17 February 2020, 07:36

Hi  @Richo ,



 



Have you taken a look at the UMRole SmartObject?



 



It has the following information:





 



A similiar query was also found here: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/SQL-Query-to-report-on-K2-Role-membership/td-p/63526



 



For more steps on how to create a SmartObject from UMRole you can look at this which states: 





  • Run Smart Object Tester.exe


  • Expand ServiceObject Explorer -> User Role Manager Service


  • Right-Click URM Service and select "Create Smart Objects"


  • Follow the wizard and at the end you will have a new Folder under "SmartObject Explorer" with the name of your newly created SmartObject




 



Hope this helps!

View original

1 reply

Esmari
Badge +4

Hi  @Richo ,


 


Have you taken a look at the UMRole SmartObject?


 


It has the following information:



 


A similiar query was also found here: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/SQL-Query-to-report-on-K2-Role-membership/td-p/63526


 


For more steps on how to create a SmartObject from UMRole you can look at this which states: 



  • Run Smart Object Tester.exe

  • Expand ServiceObject Explorer -> User Role Manager Service

  • Right-Click URM Service and select "Create Smart Objects"

  • Follow the wizard and at the end you will have a new Folder under "SmartObject Explorer" with the name of your newly created SmartObject


 


Hope this helps!

K2 will not accept any liability for any issues arising from actions taken in respect of information provided by any forum member.

Reply