XIR2 Query Builder Admin Reports

[system]

In the download section there is a excel file which gives you all the information about groups and users. The file name is BOXI_UserListV3.xls.

you can find it here :

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…

This excel writes all the groups which a user belongs in to one cell. So you can not filter by group. But it is very easy to change the code.

Here is my version of this xls file. The only difference is, it writes each group which a user belongs in to a new cell.

Feel free to try both files and change it to your own needs.
BOXI_UserListV3_1.xls (56.0 KB)

---

bozgul (BOB member since 2006-11-06)