I need a report that would list portal users and the portal roles that are assigned to the users. Additionally I would need a list of portal groups and roles that are assigned to groups. How can I query these reports on portal?
You can try this:
go to System Administration -> Content Administration -> KM Content
(root) -> ume -> roles
There you'll get a list of all roles as folders. If you enter a folders, you'll get all the groups and users directly added to the role. From there, you can enter the groups and the users added to them.
You can also access these folders via WebDAV and explorer the roles/groups/users from you Windows Explorer. The groups are also folders, only the users are text files. In the end, you'll get something like this:
http://<server>:<port>/irj/go/km/docs/ume/groups/GRUP.PRIVATE_DATASOURCE.<group name>.grp/GRUP.R3_ROLE_DS.<group name>/USER.R3_DATASOURCE.<user name>.usr
hope this will help you,