How to Export list of users associated to a group in CMC

general discussion
1

Hello Experts,

I need to export the list of all Users associated to the group to excel along with the status (Active vs Disabled) through CMC.

Any help is appreciated.

Thanks,
Kalyani.

2

Try creating a Webi document using the BusinessObjects BI on BI universe which allows you to create Webi documents using the CMS as a data source.

I do not believe you can get this information via the CMC.

1 Like
3

The only way to get this from the CMC other than using the BI on BI universe or a third-party tool is to use one of the SDKs. In Java, you can get the SI_ID of each user that is a member of the specified group by getting the group as an IInfoObject, casting it as an IUserGroup and then calling .getUsers(). From there you would get the IInfoObject for each user using the SI_ID from the call to .getUsers. I usually export this info to a .csv file (easier to write to from Java than an Excel file) which can be opened in Excel.

Or, you could use a relationship query in your code so that you don’t have to query twice. This query would look like:

Select SI_ID, SI_NAME from CI_SYSTEMOBJECTS where CHILDREN(“SI_NAME=‘UserGroup-User’”, “SI_NAME=‘<user group you’re looking for’”)

This will give you the list of all of the users who are members of the specified group.

-Dell

4

BIClever has FREE utilities for SAP BusinessObjects, including a CMS Query Builder and a Security Explorer. Perhaps one of those will give you the output you are seeking?