Skip to main content

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

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