BOXI UserList & Group Extraction

system · May 21, 2009, 7:23pm

When I run the script against my CMS, I get a timeout after 10 minutes. We have 14.000 users in the CMS. Does anyone have any idea to set a timeout or some workaround?

Remark: I used this script in Excel, then exported in a VBS-script. I run this on a daily basis to export the data in a Database. The original script is very usefull!!!

Geert (BOB member since 2002-07-10)

system · June 4, 2009, 4:22pm

When I attempt to connect to the CMC I get this error:

Failure In UsersGroups()
VBAProject - 429: ActiveX Component can’t create object 1000429

I have attempted to register the DCOM dll but I can’t tell which ones it is barking about.

Any suggestions?

BOBJ_MAN (BOB member since 2008-12-08)

system · June 11, 2009, 5:08pm

Hi Julien,

What about your V5 for XI 3.x ?
Did you find time to work on it ?

G.

Landharma (BOB member since 2006-01-12)

system · June 15, 2009, 12:13pm

I took the original and created a BusObj Deski report with a VBA dataprovider to gather the info from the CMS. This works well but has just started failing with the “CMS operation timed out after 9 min” that BOpat had “enjoyed” some time ago and Geert is getting now. I have only about 1100 users in the CMS?

Have either BOpat or Geert got an answer to this timeout? Anyone else with ideas? Please.

OllyB (BOB member since 2008-04-17)

system · June 16, 2009, 4:30pm

I am having a problem running this using Excel 2007 against BOE XI 3.0. I get a compile error related to SessionMgr.

I am not very good at VB so not sure what I can do here??

Charles Killam (BOB member since 2003-04-24)

system · June 16, 2009, 8:14pm

Is there any way we can get to know the list of crystal reports for different data connections through SDK.

I have the SQL where I could get it partly
SELECT SI_ID, SI_NAME ,si_processinfo.si_logon_info FROM CI_INFOOBJECTS WHERE SI_KIND = ‘CrystalReport’

This SQL gives me the total list.
I need to go to si_processinfo.si_logon_info.si_logon1.si_server value. But when I use this in the query, it doesnot give anything for this column

SELECT SI_ID, SI_NAME ,si_processinfo.si_logon_info.si_logon1.si_server FROM CI_INFOOBJECTS WHERE SI_KIND = ‘CrystalReport’

Can someone please let me know how to achieve this.

Thanks

Chikki (BOB member since 2006-05-08)

system · June 29, 2009, 1:06pm

This macro sounds like a great tool. I too am new to BO, and am on 3.1 and having a tough time auditing which users belong to each group, and what privileges each has on all the different objects. If this tool can organize that info into a spreadsheet or report, that would be awesome.

Julien, please post if you have a 3.1 version developed.

Many thanks,
Dave

darneson (BOB member since 2009-03-10)

system · July 5, 2009, 7:37am

Hello That utility works great .Please is there any way to get list of report and groups which have access to those reports.please help me

rekha (BOB member since 2008-06-08)

system · July 7, 2009, 5:58pm

Hi,

We were using this and it worked perfectly but now we are getting the following error on the BOXI R2 version. We do not have Crystal. We are on SP4.

“VBAProject - 13: Type mismatch 1000013” when it hits the following code

Set UserObject = UserItem '''' THIS LINE IS FAILING EVERYTIME
    RowNum = RowNum + 1
    Rng(RowNum, 1) = UserItem.ID
    Rng(RowNum, 2) = UserItem.Title
    ErrorState = "FullName"
    Rng(RowNum, 3) = UserObject.FullName
    Rng(RowNum, 4) = UserObject.EmailAddress
    GroupNum = 0

It was a very helpful tool. If anyone can tell us how to fix it, it would be greatly appreciated.

Thank you,

gdbo

gdbo (BOB member since 2009-07-07)

system · July 21, 2009, 9:14pm

Hi all,
It is not working for me but It worked last year, I get
“VBAProject - 13: Type mismatch 1000013” error.
Other than that, this tool is amazing… better than CMC…

Thanks
Remata

remata (BOB member since 2006-04-19)

system · July 23, 2009, 6:24pm

We are using an Admin account for the BO XI R2 version of the BO XI UserList and Group Extraction and we still get the error. Is there any other way to get user account info in BO XI R2? We beed to respond to several audit points and have been unable to automate the gathering of this data.
Thanks,

gdbo

gdbo (BOB member since 2009-07-07)

system · July 31, 2009, 2:42pm

When I try to run this I the following error: VBAProject -424: Object required 10000424: any thoughts? I would really love to be able to use this.[/img]

rniccolls (BOB member since 2007-07-18)

system · August 6, 2009, 8:55pm

Thank you for posting this! It was extremely helpful.

A Durgan (BOB member since 2006-02-24)

system · August 12, 2009, 3:27pm

Great Job Julien.

The last field you added (last connexion) is so helpfull for us.
I suggest you one more challenge = adding a column which indicates the number of connexion of a user.

Thanx in advance
Pat

pathqn (BOB member since 2009-08-12)

system · August 14, 2009, 12:44pm

I downloaded the V3 code and I can bring back the ID & Title for each user in the CMS, but all the other items fail with “VBA Project -438: Object doesn’t support this property or method 1000438”. Could this be an issue with not having the correct Library Reference loaded in VBA? I loaded all the Business Objects 12 reference libraries.

I am running on XI 3.1 and using Excel 2003.

I also get an error when I use the declarations for “SessionMgr”. The error states “Compile error: User-defined type not defined”. Again, I think this might relate to reference libraries, but I have so many to choose from I was hoping someone might be able to tell me exactly which libraries I need.

Thanks,

bdiss (BOB member since 2007-12-05)

system · September 1, 2009, 2:36pm

Hi Julien,
Great work julien! Just one little problem though(unless I am doing it wrong!) I add in new names into the extracted spreadsheet to try and load into XI but the details do not load. The extraction works fine but now i need to add users to the lists but can’t seem to get them into XI. Please help as I have to go live soon.

olut (BOB member since 2009-08-20)

system · September 3, 2009, 3:34pm

Hi muru09, saw your post and can’t find any response to it for the solution as i am having the same issue at the moment. cannot update the cms.

olut (BOB member since 2009-08-20)

system · September 15, 2009, 6:32pm

I would love to use the tool but I’m getting the following error:

“VBAProject - 13: Type Mismatch 1000013”

Thanks in advance!

gridironcoach (BOB member since 2009-05-15)

system · October 2, 2009, 9:31pm

Hi guys,
I’m using this VBA code to pull the groups and so on. I’m getting an error like this “Compiler Error” -> User - Defined type not defined…
Is any Expertise know this issue

Madu (BOB member since 2008-02-08)

system · October 14, 2009, 7:59pm

Hi Julien… Thanks, this is a GREAT tool.

I was able to pull the users with no problem! I also pulled reports but there were fields not populated due to field names.

The only issue I’ve run into is that the field names are a little different. It’s like using CE10 fields.

How do I make the translation for some of the fields that are in the scheduling & processig info sections? When I use the QB I select si_scheduleinfo.si_schedule_type… .

Another example: BeginDate is SI_StartTime.

I’d also like to pull fields from the systeminfo & processinginfo sections.

Hope this makes sense…

cenie (BOB member since 2009-05-23)