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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Access Level Lister
1 members found this topic helpful
Goto page Previous  1, 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
craiggsmith
Principal Member
Principal Member



Joined: 01 Jun 2009

Posts: 267



PostPosted: Thu Feb 02, 2017 12:52 pm 
Post subject: Re: Access Level Lister

I created a folder at the root level of my C drive called RightsLister for ease of access, added the jar file to it, and use the following batch file. Note that it only returns custom levels, so if you want to see the rights for standard levels you have to copy them. There are a few rights that come back as Unknown right in 4.2; most are related to new features such as BI commentary or send to SFTP, but some I could not find a match for. There is even one right that displays as Unknown right in the CMC!

@echo off

set /p server=server:
set /p username=username:
set /p password=password:
cls

java.exe -cp "C:\RightsLister\*;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\*" com.forumtopics.bob.RightsLister %username% %password% %server%.csw.l-3com.com secEnterprise C:\RightsLister\access_level_rights_%server%.txt

start "" /b "C:\Program Files (x86)\Microsoft Office\Office14\excel.exe" C:\RightsLister\access_level_rights_%server%.txt
Back to top
sapaa
Principal Member
Principal Member



Joined: 21 Feb 2014

Posts: 207



PostPosted: Thu Feb 02, 2017 3:21 pm 
Post subject: Re: Access Level Lister

got it to work!!!! with some modifications on your batch!!!!!!!!!
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007
ASUG Icon
Posts: 141


flag
PostPosted: Fri Oct 26, 2018 8:44 am 
Post subject: Re: Access Level Lister

Jatinder Bhatti wrote:
Hi
...
Further if you could help us with export of Groups, FoldersName along with Access Levels that would be great..

You can access those info from QueryBuilder.
But yes, its output is .... difficult to export

or isn't it ?


BICLEVER ( dot com ) offers a FREE tool ( .exe, sorry, for windows ) that is called "CMSquerybuilder"
It accepts exactly the same queries that you put in QueryBuilder, but has an option to "export to excel"

Seems to work now with 4.2 (client tools installed) and MS Office 64bit
Jatinder Bhatti wrote:
..
Thanks
Jatinder Bhatti


And I guess there will be a "thanks" from me too.
Now trying to get this to work, looks very promising.

_________________
Transitioning to : XI 4.2 (SP3)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out : BI 4.1 SP5 . Mostly Webi.
Phased out : BO-XI 3.1 SP6 . Mostly Webi.
Phased out : BO651, full clients. No Webi.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
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.0313 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0278)
CCBot/2.0 (https://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