In BMS > Reporting > Create custom report, I'm unable to find the option to report on users number of redirected folders.

This existed on BES 4.1 BMS.

Is this no longer a choice.

I ended up opening a ticket with RIM.

Their official answer - In 5.0, there is no way to run a report, listing all users and number of redirected folders. They suggested to view each user one at a time in BAS.

Bad enough to have to click through each user, but then you have to manually count each folder selected for redirection to get a total.

They gave no explanation why this was taken out. Additionally, I asked if they knew of a SQL query to get the info and they said no.

If you want a SQL query you can run the below (note that this will only display users where you've selected which folders are redirected, if they have the option "inbox and sent tiems only" this is a different table and therefore will not show using this command:

select displayname,numberofselectedfolders from userconfig where NumberOfSelectedFolders >= 1

HelixFelix,

Exactly what I need. Thx!

I sent this script to the support person at RIM, so he can put it into his knowledge base. I also asked him if there's a suggestion e-mail address, so I can ask to have this function put back into BMS Reporting.

Thanks again!