BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BI + Analytics conference: Aug 9.

Get User Group Details From CMS repository SAP BI4.1/4.2


 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
BI_SPY
Forum Member
Forum Member



Joined: 15 Mar 2012

Posts: 18



PostPosted: Wed Nov 16, 2016 10:40 am 
Post subject: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi All,

I have developed an utility which will fetch the user group details from the SAP Business Objects repository and will provide the output in the excel format.

I have developed this utility using the JAVA SDKs which uses the libraries of SAP Business Intelligence 4.1 version.

In order to use this utility with your SAP Business Objects servers, please follow the steps below.

Step 1: Download the attached zip file and extract it. It has the JAR file.


Step 2: Configure the CLASSPATH variable for the below libraries on the system where you will run this utility.

Required Libraries can be found at :
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib

Dependent Libraries can be found at :
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external

Step 3: Copy this utility to the same folder where you have copied above libraries and set the CLASSPATH variable for this utility as well.


Step 4: Open the command prompt and run the following command.


Command:

java.exe -classpath %CLASSPATH% UGDetailsM 10.10.254.183 administrator password F:\JavaOutput\UserGroupDetails.xlsx

Points to note for running the above command:
1. UGDetailsM is the class name which needs to be used in the command as it is. It is case sensitive so please use it as it is.
2. Provide the IP address for SAP Business Objects server.
3. Provide the Username/Password to login to SAP Business Objects server.
4. Provide the file name along with the extension of excel file in double quotes.
5. File name and Path can be anything.
6. This utility will only work with enterprise authentication since I have hard coded it in the source code.

Step 5: Generated excel file would be in the below format.

    User ID
    Full Name
    Email Address
    Status
    Last Logon Time
    Creation Time
    License Type
    Group Details


This utility is tested with SAP Business Intelligence 4.1 and Business Intelligence 4.2 versions only. I am going to develop the same utility for SAP Business Objects 3.1 version as well and will share it soon.

Please use this utility and share your views.

Thanks,
SPY



UserDetailsSAPBI41.zip
 Description:
Zip file which contains the JAR file.

Download
 Filename:  UserDetailsSAPBI41.zip
 Filesize:  7.77 KB
 Downloaded:  279 Time(s)

This post has been reported for Wrong Forum. The current status is Closed / Resolved.
Moderator Dave Rathbun closed this report Click for Details
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22077
Location: Dallas, Texas


flag
PostPosted: Wed Nov 16, 2016 4:06 pm 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Moved to the Downloads forum, thanks.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2016-05-19 Visualize Whirled Peas
• 2016-03-15 What Is Your Waffle House?
• 2016-02-22 When Charts Go Bad…
Back to top
aposullivan
Principal Member
Principal Member



Joined: 22 Jul 2004
ASUG Icon
Posts: 181
Location: Australia


flag
PostPosted: Mon Dec 12, 2016 1:00 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi,

I am getting an error saying

Error: Could not find or load main class UGDetailsM.

I'm sure I've done everything as explained.

Any tips?

Thanks,
Ainsley
Back to top
BI_SPY
Forum Member
Forum Member



Joined: 15 Mar 2012

Posts: 18



PostPosted: Tue Dec 13, 2016 5:24 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi Ainsley,

Try this https://www.dropbox.com/s/b8ugfvjbpzu7yv1/UserDetailsSAPBI41-V3.zip?dl=0

Download this file and run it directly. This new file would not need any classpath variable to be set as I have already included required libraries in this JAR file.

Command:

java.exe jar jarfilename BOServerIP Userid Password

~SPY
Back to top
aposullivan
Principal Member
Principal Member



Joined: 22 Jul 2004
ASUG Icon
Posts: 181
Location: Australia


flag
PostPosted: Tue Dec 13, 2016 11:31 pm 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi Spy,

this is the command I typed in:
java.exe jar 192.168.206.232 Administrator <password> C:\Users\k09179\Documents\UserGroupDetails.xlsx

That correct?

TIA
Back to top
BI_SPY
Forum Member
Forum Member



Joined: 15 Mar 2012

Posts: 18



PostPosted: Thu Dec 15, 2016 12:17 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi Tia,

You would need to extract the downloaded zip file and go to the same folder in command prompt.

E.g. If you saved this extracted zip folder in C:\UserDetailsSAPBI41-V3 then go to this folder location in the command prompt and run the following command.

Commnad should be as below:

JAVA.exe -jar UserDetailsSAPBI41-V3.jar BOServerIP username "Password"

Please do not specify the file path in the command.

In your case, command should be as below:

java.exe jar UserDetailsSAPBI41-V3.jar 192.168.206.232 Administrator <password>

~SPY
Back to top
aniketp
Forum Addict
Forum Addict



Joined: 05 Oct 2007

Posts: 3629
Location: Manchester


flag
PostPosted: Fri Dec 30, 2016 1:03 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Can we run this on machine having BO client installed?
_________________
Regards
Aniket
Back to top
aniketp
Forum Addict
Forum Addict



Joined: 05 Oct 2007

Posts: 3629
Location: Manchester


flag
PostPosted: Wed Jan 18, 2017 1:01 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

I tried using it on BI client machine but it throws errors -

Could not find or load main class? jar

Can you please guide me how to correct it?

_________________
Regards
Aniket
Back to top
passport
Senior Member
Senior Member



Joined: 07 May 2010

Posts: 87



PostPosted: Tue Jan 24, 2017 11:33 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Unzipped the Jar file from the dropbox and using the command prompt at the location where i unzipped the file i executed the following command

C:\Users\CON0070\Downloads\UserDetailsSAPBI41-V3>java.exe -jar UserDetailsSAPBI
41-V3.jar <serverIP> Administrator <Password>

I encountered the same error

Error: Could not find or load main class ?jar

I also copied the lib files from the BO server and place in the same folder and executed the command with no success.

Thanks
Arun
Back to top
BI_SPY
Forum Member
Forum Member



Joined: 15 Mar 2012

Posts: 18



PostPosted: Mon Feb 06, 2017 5:43 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi Arun,

I apologize for the delayed response. I have not used this forum since long.

Please use the link below to download a new file, this file does not need any BI client installed and class_path to be set on the system from where you will run it.

https://www.dropbox.com/s/b8ugfvjbpzu7yv1/UserDetailsSAPBI41-V3.zip?dl=0

Please follow the below steps to use this new JAR file.

- Download this new jar file.
- Extract it and go to the same folder in command prompt.
- Run the following command.

Command:

C:\>java.exe -jar UserDetailsSAPBI41-V3.jar BOServerIP administrator Password

Hope this would be helpful.

~SPY
Back to top
reddyvmk
Forum Member
Forum Member



Joined: 28 May 2005

Posts: 1



PostPosted: Mon Feb 20, 2017 5:06 pm 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

i am still getting error

C:\temp>java.exe -jar UserDetailsSAPBI41-V3.jar XX.XX.XX.XXXX administrator xxxxxx
Exception in thread "main" java.lang.UnsupportedClassVersionError: JVMCFRE003 ba
d major version; class=UGDetailsM, offset=6
at java.lang.ClassLoader.defineClass(ClassLoader.java:364)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:15
4)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:777)
at java.net.URLClassLoader.access$400(URLClassLoader.java:96)
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:1225)
at java.security.AccessController.doPrivileged(AccessController.java:366
)
at java.net.URLClassLoader.findClass(URLClassLoader.java:660)
at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:942)
at java.lang.ClassLoader.loadClass(ClassLoader.java:851)
at java.lang.ClassLoader.loadClass(ClassLoader.java:827)
at java.lang.Class.forNameImpl(Native Method)
at java.lang.Class.forName(Class.java:237)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoa
der.java:56)
Back to top
BI_SPY
Forum Member
Forum Member



Joined: 15 Mar 2012

Posts: 18



PostPosted: Wed Feb 22, 2017 6:46 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Could you please confirm the JAVA version you are using on your system?

I will have to compare it with the version of JAVA which was used to compile this utility.

~SPY
Back to top
ash0550
Principal Member
Principal Member



Joined: 12 Sep 2011

Posts: 230


flag
PostPosted: Tue Jun 20, 2017 2:51 pm 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi,
Thanks for the tool, But i have a quick question is there any way if i can pull the last pw reset date onto this excel sheet
Back to top
BI_SPY
Forum Member
Forum Member



Joined: 15 Mar 2012

Posts: 18



PostPosted: Tue Jun 27, 2017 12:26 am 
Post subject: Re: Get User Group Details From CMS repository SAP BI4.1/4.2

Hi,

I have checked this but did not find any option which shows the date/time for last password change. BI does not have any property set for fetching this information at the user level.

Regards,
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0512 seconds using 20 queries. (SQL 0.0049 Parse 0.0355 Other 0.0107)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo