You are hereBOXI UserList & Group Extraction
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 tested
Version: V4
Code: VBA inside the Excel file
Download : BOXI UserListV4.xls
History:
V4 (07/03/2008) – 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 modify 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
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.
You need BO libraries to run the VBA ; if you have installed the full client it’s OK. Also disponible on the BoB Forum
Update 01/2011 : I have released a new tool (ExtractCMS) which can do the same as this file, with much more possibility... It's easy to setup, and use all the power of BOXI reporting.
| Attachment | Size |
|---|---|
| BOXI UserListV2.xls | 59 KB |
| BOXI UserListV3.xls | 69.5 KB |
| BOXI UserListV4.xls | 81.5 KB |
Bonjour,
J’ai testé la version V3 de l’extraction…. Elle marche nikel dans une WM à moi. Par contre petit souci, chez mon client actuel, nous n’avons pas Excel installé sur le server !!!! :( J’ai donc un probleme de session et je recois un erreur.
As tu trouvé une solution pour te connecter d’une autre machine ? Je ne connais pas le SDK, malheureusement.
Merci d’avance pour ta réponse.
CED de BoB Forum
Julien,
This is an amazing tool that I came across on BoB. Have you created anything to extract Report names, descriptions and folders? I'm currently using Query Builder to get this info, but the manual work in Excel is overwelming.
Thanks again for sharing the user / group extract.
Sue Kammann
Minneapolis, MN - USA
skamman1@fairview.org
Julien,
This is a great utility. Thank you.
I have a problem however, I am getting a 429 error, can't create VBA project when I try to connect to the CMS. Which, from I understand is an ActiveX Component is not being found / registered.
What can I do to correct this?
BOBJ Man
This is an amazing tool that I came across on BoB. Have you created anything to extract Report names, descriptions and folders? I'm currently using Query Builder to get this info, but the manual work in Excel is overwelming.
Julien,
This is a great utility. Thank you.
I have a problem however, I am getting a 429 error, can't create VBA project when I try to connect to the CMS. Which, from I understand is an ActiveX Component is not being found / registered.
What can I do to correct this?
Thanks
Murali
muralim01@gmail.com
Hello
I came across this great tool, and it is just what we needed.
But we got this error message : timeout after 9 minutes.
Any idea how to solve this ?
thanks
Patrick
adler@eib.org
there is a tool in BOB downloads that will do this for you.
Julien,
I would love to use your tool but I am receiving the following error:
"VBAProject - 13: Type Mismatch 1000013"
The error occurs on the following line:
Set UserObject = UserItem
Hi, you can ind the tool here.
http://www.forumtopics.com/busobj/viewtopic.php?t=118177
br
kim
HI, it's not the same tool :) Not designed by me, indeed !
mine is here : http://www.forumtopics.com/busobj/viewtopic.php?t=89434
Hi Julien, long time no see ;)
I encountered a case where I got an error telling that the SI_LASTLOGONTIME property didn't exist.
Looking at the record causing the error, the field was indeed null and it looks like the '.property("")' function didn't like it.
As I didn't have much time and I am not good at VBA, the only workaround I found was to filter the loop on records for which this column was not null, and making another loop only with records for which this entry was null. In the second loop, I don't retrieve the SI_LASTLOGONTIME and of course don"t reset the rownum count, and it all works fine.
Take care!
Rémy (remember at Alstom?)
Hi remy !
Hope that everything is great in your life (work, kid :) )
I've got the same issue on the SI_FULLNAME property, for example on a special user for Performance Manager (PMuser) ; so there is some specific loop for this case. It's possible to make some news loops for other exeptions :)
I need to send you a new tool, same idea but lot of other data :) Still on XIr2 in alstom ?
see you later and take care !
great tool!
Congratulations!
Miguel
São Paulo - Brazil
Julien,
Do you have a Excel users macro that can update the Users Group membership. I wanted to copy and paste user groups from different columns and export back to CMS on XI 3.1 w/SP2.
Thanks Kindly,
Ajay Gupta
Your Canadian Connection
ust 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).
Julien,
This is a great utility. Thank you.
http://www.uggbootsinde.com/
I have a problem however, I am getting a 429 error, can't create VBA project when I try to connect to the CMS. Which, from I understand is an ActiveX Component is not being found / registered.
What can I do to correct this?
Bonjour Julien,
C'est excellent, Merci beaucoup.
Existe-t-il quelquechose du meme genre pour obtenir la liste de tous les reports.
Evelyne
HI Julien,
How are you !
I looked at your forum and tried excel user extarct from BO.
It works great. Its really amazing.
But, I have similar kind of requirement where in I would like to extract the active user list using shell (linux/unix) script by connecting to CMS.
I would really appreciate, if could forward me the SQL script/commands to pull the active loginIds (No need for full name or email).
Thanks
Amit Singla
HI Julien,
Hope you are doing great.
Could you please help me out in extracting the user list from Business Objects.
Actually, I want to extact the information using shell script.
So, if you could forward me Commands/SQL scripts where in I can pass some parameters like CMS repository name, username and password.
I would really appreciate your help.
Thanks
Amit Singla
amit.singla@gs.com
But, I have similar kind of requirement where in I would like to extract the active user list using shell (linux/unix) script by connecting to CMS.
real soft
I have released a new tool (ExtractCMS) which can do the same as this file, with much more possibility... It's easy to setup, and use all the power of BOXI reporting.
I am getting the same error. We are still an XIR2 shop and dont have Security Universe. How can i get this Macro to run without getting this error.
Thanks,
Adnan.
I am having an issue with inactive users who were deleted from our windows AD directory but they are not deleted from the repository. Because of this reason I am getting "active directory athentication failed..." error and the macro closes. Is there anyway ths macro can be modified to print all users even if they do noit currently belong to any active directory?
Thanks and regards
Anna
Hi Juliene,
We have over 7200 users in our system and when I try to run your Excel tool I get a timeout error, do you know what can i do to fix that?
Here is the error I am getting:
Failure in UsersGroups()
CrystalEnterprise115.InfoStore.1 - -2147219448: Transport error: No response from server, timeout exceeded. 1000440
Adi
This is a handy and great little tool. It was working for for me using with BOE XI 3.1 SP2, but I get VBA reference errors after we upgrade to BOE XI 3.1 SP4. Can anyone tell me where I can find these reference library file for BusinessObjects 12.0 libraries?
I am encountering this error:
VBAProject 458 - Variable uses and automation type no supported in Visual Basic 1000458
Need help.
how to modify and export back to CMS
Post new comment