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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BOXI UserList & Group Extraction
7 members found this topic helpful
Goto page 1, 2, 3 ... 14, 15, 16  Next
 
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
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 94


flag
PostPosted: Wed Jul 25, 2007 8:53 am 
Post subject: BOXI UserList & Group Extraction

Here is a little excel file with a bit of VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership…
It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description.

Platform: BO XI R2 / BOXI3.1 (it's necessary to change the libs to fits XI3.1, see below)
Version: V4
Code: VBA inside the Excel file

History:
V4 (07/03/2008) - To be download here : http://julien.sidoine.org/post/boxi-userlist-group-extraction (Just changed alittle property in Excel selection ; when you copy-past a value for more than one user ; all the users will be flagged for update (and not just one like previous version)).
V3 (17/01/2008) – Added the Last Login Time data, and the possibility to modifiy the Login, FullName, Email, Disabled and Description column and sync it to the CMS.
V2 (04/01/2008) – Corrected the 1000 objects limit (hard coded to 1000000 objects) ; and the FullUser parameters, add of a topic for discussion
V1 (25/07/2007) – Original Release

Download : BOXI UserListV3.xls

What is it ? :
It’s simply an Excel file ith a little VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership…
Information provided for each user : id, login, full name, email adress, group list, flag user activated, flag is password to change, description and last login time.
It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description.

Some tips :


XI3 version
I have read that a lot of people can't use the XLS tool on a XI3.x installation. It's true, because th XLS file search for version 11.5(XIR2) librairies ; but there is only version 12(XI3.x) librairies. To change that, you just need to go to Visual BAsic (Alt + F11) ; go to Tools/References (or something like that, i've got a french version here icon_wink.gif )and change the 11.5 librairies reference to 12 librairies reference. There is about 5 BOXI librairies used :

Crystal Enterprise Framework Library
Crystal Enterprise InfoStore Library
Crystal Enterprise Plugin Manager Library
Crystal Enterprise User PlugIn
Crystal Enterprise UserGroup PlugIn

BO Librairies
An other very important point is that the BO libs must be installed on the client where you launch the macro. Typically, you just need to install the client version of BO (with Designer, Desktop Intelligence) and theise lib are automatically installed.

SQL Used
There is no way to the equivalent using simple SQL and query a special database. There is no database containing theise infos ! Today, the only way to do that is query via the SDK, using a commercial tools (there are many like the Sebastien one, which is not dedicated for that) or using the CMC...

Audit DB
Last point, i am not using the auditing database ; just the repo.



BOXI UserListV3.xls
 Description:
BOXI UserList v3

Download
 Filename:  BOXI UserListV3.xls
 Filesize:  69.5 KB
 Downloaded:  23580 Time(s)


BOXI UserList v2.xls
 Description:
BOXI UserList v2

Download
 Filename:  BOXI UserList v2.xls
 Filesize:  59.5 KB
 Downloaded:  5447 Time(s)


BOXI UserList.xls
 Description:
BO XI R2 User List & Group Retrieve

Download
 Filename:  BOXI UserList.xls
 Filesize:  55.5 KB
 Downloaded:  7537 Time(s)


_________________
Julien Bras


Last edited by julienbras on Wed Nov 16, 2016 8:47 am, edited 4 times in total
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Fri Jan 04, 2008 8:36 am 
Post subject: Re: BOXI UserList & Group Extraction

Updated with version 2.
_________________
Dwayne Hoffpauir
Image link
Back to top
Diane1969
Principal Member
Principal Member



Joined: 18 Jan 2007

Posts: 213
Location: Birmingham


flag
PostPosted: Fri Jan 11, 2008 5:34 am 
Post subject: Re: BOXI UserList & Group Extraction

Perfect - works a treat and really useful!!
Back to top
surreal
Forum Member
Forum Member



Joined: 29 Aug 2007

Posts: 23
Location: NC


flag
PostPosted: Fri Jan 18, 2008 9:59 am 
Post subject: Re: BOXI UserList & Group Extraction

Very useful, thanks. Is it possible to add a column to determine a user's last login date?
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Sat Jan 19, 2008 11:02 am 
Post subject: Re: BOXI UserList & Group Extraction

Updated with V3
_________________
Dwayne Hoffpauir
Image link
Back to top
surreal
Forum Member
Forum Member



Joined: 29 Aug 2007

Posts: 23
Location: NC


flag
PostPosted: Sat Jan 19, 2008 4:06 pm 
Post subject: Re: BOXI UserList & Group Extraction

This is great. Thanks so much!
Back to top
Arnaud Delalande
Forum Member
Forum Member



Joined: 09 Mar 2006

Posts: 12
Location: Nantes


flag
PostPosted: Tue Jan 22, 2008 4:22 am 
Post subject: Re: BOXI UserList & Group Extraction

I have just tested it !

Great, thanks very much !

_________________
Arnaud Delalande
BI Consultant
BO 5, 6, XI
Cognos 7.1 and C8
Back to top
surreal
Forum Member
Forum Member



Joined: 29 Aug 2007

Posts: 23
Location: NC


flag
PostPosted: Thu Jan 24, 2008 10:22 am 
Post subject: Re: BOXI UserList & Group Extraction

Everything was working fine but I installed CR 10 and now when I try to retrieve data from CMS I get an error stating 'VBAProject - 13: Type mismatch 1000013'. Anyone know what is causing this error and how to fix it? Thanks.
Back to top
kmspsu93
Principal Member
Principal Member



Joined: 06 Apr 2006
ASUG Icon
Posts: 134
Location: Atlanta, GA


flag
PostPosted: Mon Jan 28, 2008 2:49 pm 
Post subject: Re: BOXI UserList & Group Extraction

Thanks for sharing!!!
Back to top
ashishk
Forum Member
Forum Member



Joined: 10 Mar 2005

Posts: 27
Location: Mumbai


flag
PostPosted: Thu Jan 31, 2008 2:56 am 
Post subject: Re: BOXI UserList & Group Extraction

Hi,
Tried this and its great. Is there any tool present which can give the entire security snapshot of a BO system?

Thanks & Regards,
Ashish K
Back to top
hbunicorns
Senior Member
Senior Member



Joined: 31 May 2007
ASUG Icon
Posts: 83
Location: Orange County, California


flag
PostPosted: Thu Feb 14, 2008 2:09 pm 
Post subject: Re: BOXI UserList & Group Extraction

Hi,

I would really love to use this tool, however when I connect I receive the following error message -
"VBAProject - 13: Type mismatch 1000013"

Any suggestions?

Ruan
Back to top
nyck944
Senior Member
Senior Member



Joined: 20 Oct 2004

Posts: 41
Location: Los Angeles, California


flag
PostPosted: Tue Apr 01, 2008 12:52 pm 
Post subject: Re: BOXI UserList & Group Extraction

Hi there - this looks like a great tool, but I'm getting the following error when I try to connect:

CrystalEnterprise12.SessionManager1 - 2147024891: Access Denied - You cannot logon to an older version of the CMS. 1000440

We are on BO XI R2, SP2.7 - we only use BO, no crystal.

Any ideas on this?

_________________
Nick Suciu, BOCP- BOE
XI Migration Specialist
Union Bank of California
847-922-4645
Back to top
JohnBClark
Forum Enthusiast
Forum Enthusiast



Joined: 27 Mar 2007
ASUG Icon
Posts: 1036
Location: Appleton, WI USA


flag
PostPosted: Fri Apr 04, 2008 2:50 pm 
Post subject: Re: BOXI UserList & Group Extraction

nyck944 wrote:
Hi there - this looks like a great tool, but I'm getting the following error when I try to connect:

CrystalEnterprise12.SessionManager1 - 2147024891: Access Denied - You cannot logon to an older version of the CMS. 1000440

We are on BO XI R2, SP2.7 - we only use BO, no crystal.

Any ideas on this?


It looks like you need to have Crystal Reports installed in order for this to work. The VBA code references several Crystal Reports files.

I was going to post a screenshot of the references but I can't figure out how. Hope this helps.

_________________
BusinessObjects BI4.2sp4, SQL Server 2016 (CMS)
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2016sp4, Web Intelligence
Operating System: Windows 2016 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle, Hive
Information Steward 4.2sp10
History: BO5, BO6, XIR2, XI3.1, BI4.1.x
Back to top
Ron Johnson
Forum Member
Forum Member



Joined: 07 Sep 2004

Posts: 10



PostPosted: Tue Apr 08, 2008 4:09 pm 
Post subject: Re: BOXI UserList & Group Extraction

I get an error
CrystalEnterprise115.InfoStore.1 --2137210999: Active Directory Authentication failed to get the active Directory groups for the acount with ID "841250165026213482174"ADEDUS". Please make sure this account is valid and belongs to an accessible domain.

I am assuming I am only getting this error because we are using active Directory for our security

I am going to try getting a domain service account added to one of our Active Directory groups and then set that as an Administrator and try again.
Back to top
alpha1145
Principal Member
Principal Member



Joined: 04 Jan 2006

Posts: 181
Location: Salt Lake City, UT


flag
PostPosted: Tue May 06, 2008 12:56 pm 
Post subject: Re: BOXI UserList & Group Extraction

Quote:
Hi there - this looks like a great tool, but I'm getting the following error when I try to connect:

CrystalEnterprise12.SessionManager1 - 2147024891: Access Denied - You cannot logon to an older version of the CMS. 1000440

We are on BO XI R2, SP2.7 - we only use BO, no crystal.

Any ideas on this?


Looks like installing Crystal Reports 2008 breaks the macro. The macro tries to reference the newer components in CR2008 and thus it does not work with XIR2. Uninstall CR2008 and see if that fixes your ability to run the Macro.

_________________
BOE 4.1 SP6
3 Server Cluster - 24 CPU, Front-End Load Balancing
Teradata : Oracle : SQL Server : DB2 : Greenplum : SAS : Hadoop
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 16 All times are GMT - 5 Hours
Goto page 1, 2, 3 ... 14, 15, 16  Next
 
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.0958 seconds using 19 queries. (SQL 0.0058 Parse 0.0625 Other 0.0275)
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