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?
Best answer by Esmari
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!