how can I get list of all BO users in BOXIR2?

[system]

Hi,

Using query builder, Can anyone please help me with the query to pull a list of users in BO?

Thank you!

-Madhuri

---

madhurikiran (BOB member since 2006-02-03)

[system]

SELECT SI_ID, SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_PROGID=‘CrystalEnterprise.USER’

I figured out that above query works; But, I recall that we could export these results to an excel sheet too. Can anyone help me with that?

Thanks,
Madhuri

---

madhurikiran (BOB member since 2006-02-03)

[system]

I got one way of doing it!!
With your IE results, Ctrl+A , Ctrl+C and whatelse?! Ctrl+V onto an excel sheet

Thats it! Please let me know if there is any other “Intelligent way” of doing this.

Thanks,
Madhuri

---

madhurikiran (BOB member since 2006-02-03)

[system]

https://bobj-board.org/t/96166

---

bension (BOB member since 2005-09-01)

[system]

Hi

Look in the link.

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, s…

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)