Solved

Report on role membership

  • 17 February 2020
  • 1 reply
  • 136 views

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

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!

Reply