BI list of all users

[Olj]

Hi,

I'm new in BI(BOE). How can I take list of all users?Example in XLS(login, full name)

BI 4.0 sp4

Thanks...

[Former Member · Accepted solution]

Hi Daulet,

You can execute the below query in query builder(AdminTools application)

select si_name,si_id,si_lastlogontime from ci_systemobjects where si_kind='user'

You can copy the content from query builder output and paste the results to excel.Another method would be to use BusinessObjects SDKs.

Refer to the blog series below to understand query builder basics

http://scn.sap.com/docs/DOC-42952

Thanks,
Prithvi

[Olj · Accepted solution]

Thanks Prithviraj,

but this view is not uncomfortable.

How can I list by columns, like     LOGIN     FULL_NAME

                                                     AMARK    ANTONY MARK

                                                     lANN        LIS ANN

like suim reports in Netweaver

[Former Member · Accepted solution]

Hi Daulet,

If you are not comfortable with the query builder view, you would need to use businessobjects java sdks and develop a code to list the users info in a tabular form.

You would need to look at the below forum if you have queries related to java sdks.

http://scn.sap.com/community/bi-platform/java-sdk

Refer to SAP Note: 1876537 - How to retrieve the users information and export the results to excel 2007 using java prog...

Thanks,

Prithvi

[Olj · Accepted solution]

Thanks Prithviraj,

what about database? Strange I can't find any tables\views like "ci_systemobjects" in BOE db

[Former Member · Accepted solution]

Hi Daulet,

ci_systemobjects is the virtual table name. Physical table names are different.

Refer to the below wiki for the same.

http://wiki.scn.sap.com/wiki/display/BOBJ/How+to+browse+CMS+repository

However, it is not recommended to execute queries directly on the CMS database.

Thanks,

Prithvi

[Former Member · Accepted solution]

Prithviraj,

Thank you for sharing the Wiki Page but do we have any updated one with Product Version BI 4.1?

Shakeel

[former_member1255924 · Accepted solution]

Big Help, Is it the list of active users?

as in BO CMC user list is showing for me is 2037 and when I ran that query its showing only 1000.

[former_member1255924 · Accepted solution]

is there a way we can see 2000 user at a time, this query returning only first 1000 users at a time. ?

[denis_konovalov · Accepted solution]

you use TOP statement in the query to set number of records to retrieve.

[Former Member]

Hi

Check SAP note 1207593

After Genrating the Report go to file and save as html in your local .

Select the HTML Page and Right click Open with Excel

Regards,

Atul B