BOXI UserList & Group Extraction

Hi,

Share, for sure someone will be interesting one day or another! :wink:

Gôm

Do we have extraction macro for Xi 3.0 and higher?


MightyBO :us: (BOB member since 2007-06-28)

This works with 3.1


Bolandb (BOB member since 2010-06-08)

Hello experts,

SELECT SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_KIND = ‘User’
gives me list of ALL users in the system. We have a hierarchical User Group structure. Group “A” has sub-groups “B” & “C” under it and Group “D” has sub-groups “E” & “F” under it.
Is there a query that I can fire via Query Builder that wil extract list of users from/within Group “A” hierarchy only? (list of sub-groups under “A” is very big, I don’t want to list all of them).
Please assist.

Thanks,
Buddy.


Buddy :india: (BOB member since 2006-08-04)

Hi Bolandb,

I would like to know, what is the importance of Never Connected Field?

If the Last Logon Time is NULL, Should it display ‘1’ or ‘0’?

If the Last Logon Time is NULL, that means User is never logged in right?

Can you please share the excel, which pulls users belong to Windows AD authentication?

What about LDAP, is the same work for LDAP also?

Thanks


MightyBO :us: (BOB member since 2007-06-28)

Do I need to have BO client installed on the machine where I am executing this macro?


nithya_raj (BOB member since 2007-02-03)

I do not have a clue on the Lsat Logon Time. As for shareing the Excel file, I tried to put it up on the uploads, and haven’t heard anything recently. Not sure if it didn’t work or not.

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

That line right there is the major difference. In the original it was secEnterprise, if you change it to I think it’s secLDAP it should work for ldap.

I don’t use LDAP, so I’m not positive about the name of that.


Bolandb (BOB member since 2010-06-08)

HI,

I am able to fetching 1000 users only, but in my environment we have 2000 + users… how can i fetch all user at a time?

do i need to change anything in macro… please help me on this.

Thanks,
venkat


venkata_somisetty (BOB member since 2009-08-12)

Hi All.
I am using XI 3.1 and Excel 2003. I made the above changes in VB.
While connecting When asked for CMS: I gave dev url and my login credentials… but it says…" Pls verify the name and network name resolution is working properly"…

Thanks in advance…


Adious (BOB member since 2009-10-06)

Thanks for sharing!!!


Songjun (BOB member since 2009-10-21)

Hi,

I’m trying to use the tool, but I obtain a mesaage I read in this thread before: “VBAProject - 13: Type Mismatch 1000013”

I can’t found any tip to solve this trouble.

Where I can find the solution?

Thanks a lot


Info:
Windows XP Pro SP2
BO XI R2 version 11.5.10.1263
Excel 2007


pattern (BOB member since 2010-09-22)

You don’t use the URL for the server, you use the CMS name, like logging into QaaWS or Designer. I use the Cluster name.


Bolandb (BOB member since 2010-06-08)

It’s seems like the connection it’s OK, because the first time I tried to use I obtained a message from a user that wasn’t in DA.
I removed this user, and now I get this message: “VBAProject - 13: Type Mismatch 1000013”

In fact, in the Excel, beside the button, appears the data of the server (Server name, user and update Date)

Is it works for BOXI R2?
Maybe a problem from the Excel version?


pattern (BOB member since 2010-09-22)

Thanks ! it works fine! :+1:


tigresse (BOB member since 2009-01-14)

can anyone share the version for 3.x?

I cannot install client in my workstation and i just download the library from server and import the library in VBA.

But i get this error…
“VBAProject - 429 : ActiveX component can’t create object 10000429”

thanks a lot


nicktyk (BOB member since 2010-04-22)

Yes, Please!


nelkyle (BOB member since 2010-10-26)

Thanks for sharing this file.

But it’s giving error, Error is
Failure is UsersGroups()
VBAProject - 458: Variable uses an Automation type not supported in visual basic 100458

Please help


Anis_gul :pakistan: (BOB member since 2010-03-05)

Hi All,
Thank you for interesting tool.
I want delete some of disabled and old users, but I have some difficulties with delete synthax. Have you pls any idea about That.
Thank a lot,
ME


erafmoss (BOB member since 2007-06-11)

How to make it work for Windows AD Authentication?


BOBJGuy :uk: (BOB member since 2010-02-25)

Hi Friends,

Yesterday we got a requirement like to find inactive users from the repository. Inactive users in the sense who are not logged after 01-OCT-2009. I think we can track this thing by using last login time. for this I have downloaded BOXI user list and group extraction from the BOB downlaods.

Here my question is where we need to change the code to get inactive users.

Please reply to me If you have any solutions.

Regards,
Venkata Eswara Ayyappa.


eswar519 (BOB member since 2009-05-26)