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

BI40 Users and Groups Lists

Goto page Previous  1, 2, 3
 
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
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19318
Location: Bratislava


flag
PostPosted: Thu Jul 30, 2015 11:40 am 
Post subject: Re: BI40 Users and Groups Lists

lokeshborse wrote:
It worked successfully. I was able to retrieve 96k users.
Excellent thumbsup.gif
_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Lynnieshell
Forum Member
Forum Member



Joined: 18 Sep 2012

Posts: 20


flag
PostPosted: Wed Sep 02, 2015 8:18 am 
Post subject: Re: BI40 Users and Groups Lists

I was using this happily but have been moved to excel 2013 and now I get an error

Compile Error: Can't find Project or Library.

Any ideas what this means and how I fix it?

I'm lost without this little tool nopity.gif
Back to top
Arun8006
Senior Member
Senior Member



Joined: 22 Dec 2006

Posts: 62



PostPosted: Fri Nov 06, 2015 9:12 am 
Post subject: Re: BI40 Users and Groups Lists

Hi All,

I tried running the code but get error as my BO authentication type is Windows.

Can someone help me as what should be the authentication type string here

Set esession = SessionManager.Logon(tbName, tbPassword, tbCMS, "secEnterprise")

What should be the value instead of SecEnterprise if my authentication type is Windows.

Thank you,
Arun
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19318
Location: Bratislava


flag
PostPosted: Fri Nov 06, 2015 9:37 am 
Post subject: Re: BI40 Users and Groups Lists

Hi,

Then try using secWinAD instead of secEnterprise.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Arun8006
Senior Member
Senior Member



Joined: 22 Dec 2006

Posts: 62



PostPosted: Fri Nov 06, 2015 9:43 am 
Post subject: Re: BI40 Users and Groups Lists

Wow ... That worked!

Thank you very much
Arun
Back to top
OmaCoder
Forum Member
Forum Member



Joined: 03 Nov 2015

Posts: 6



PostPosted: Fri Dec 04, 2015 2:15 pm 
Post subject: Re: BI40 Users and Groups Lists

Great utility!! We recently upgraded to 4.1 SP06 Patch 04

I had to update one of the references as the old one was missing... It was a Crystal reference but I didn't write down the specific one...

Now I get the error:

Failure in UsersGroups()
VBAProject - -2147467259: Automation error
Unspecified error 1000440

Any ideas?
Back to top
anutosh.dhar
Forum Member
Forum Member



Joined: 30 Jan 2014

Posts: 16



PostPosted: Tue Feb 23, 2016 10:15 am 
Post subject: Re: BI40 Users and Groups Lists

I am getting "Active directory authentication failed to get the active directory groups for the account with ID......" . I am not able to find the username to delete form the CMC so I am not able to progress it further. Any idea how can it move further?
Back to top
EmilBras
Forum Member
Forum Member



Joined: 09 Dec 2011

Posts: 1



PostPosted: Fri Mar 11, 2016 11:11 am 
Post subject: Re: BI40 Users and Groups Lists

Is there way to add the universe?
We have universe in a usergroup

so I can see which user has access to the universe
Back to top
GK1494
Forum Member
Forum Member



Joined: 30 Sep 2016

Posts: 1



PostPosted: Fri Sep 30, 2016 11:09 am 
Post subject: Re: BI40 Users and Groups Lists

Hello,

I am getting the following error when I try to run the User List macro:

CrystalEnterprise14.SessionMgr.1 --2147210751: Unable to log on: Could not connect to server xxx:6400. Please check that the server name is correct, and that the server is running. 1000440.

I am on BI 4.1 SP4 but I previously had it running fine on BI 3.0 and 4.0. Any suggestions on how to get this to

work are greatly appreciated.

Thanks.

Update 10/3/2016: I was able to get it working. Thanks!
Back to top
amarnatha
Principal Member
Principal Member



Joined: 07 May 2006

Posts: 165


flag
PostPosted: Wed Apr 24, 2019 7:59 am 
Post subject: Re: BI40 Users and Groups Lists

Hi

I'm getting error "VBAProject - 13: Type mismatch 1000013".

Please help me to resolve this.

My Office version : Office 365 ProPlus (16.0.11328.20230) 64 bit

BO 4.2 SP5 P5

Your help much appreciated.

Warm Regards
Amar
Back to top
amarnatha
Principal Member
Principal Member



Joined: 07 May 2006

Posts: 165


flag
PostPosted: Wed May 01, 2019 7:57 am 
Post subject: Re: BI40 Users and Groups Lists

Can anyone help me to resolve this issue.

Appreciate your help.


Warm Regards
Amar
Back to top
gezgincomrade
Forum Member
Forum Member



Joined: 14 Jul 2019

Posts: 1



PostPosted: Sun Jul 14, 2019 4:20 am 
Post subject: Re: BI40 Users and Groups Lists

Hi,

very useful sharing. thanks.

I have one question.

Can we list which reports BO users have access to

Version BO4.2
Back to top
amarnatha
Principal Member
Principal Member



Joined: 07 May 2006

Posts: 165


flag
PostPosted: Fri Jul 19, 2019 10:29 am 
Post subject: Re: BI40 Users and Groups Lists

this tool ran successfully on 32 bit version of office 365.


Thanks
Amar
Back to top
giggles7840
Senior Member
Senior Member



Joined: 13 Jul 2007

Posts: 74



PostPosted: Fri Aug 30, 2019 2:22 pm 
Post subject: Re: BI40 Users and Groups Lists

Has anyone figured out how to update this file for 64-bit using 4.2 SP5? This is my favorite file... icon_sad.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 3 of 3 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3
 
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.0341 seconds using 17 queries. (SQL 0.0042 Parse 0.0010 Other 0.0290)
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