BlackBerry® Enterprise Server Version 5.0

[Sheen]

Hi

On BES 4.1, something I used to do quite often was list all users on the BES in the console and then filter by Last Contact time. I would then also add the "Last Forwarded Time" and "Last Result" columns - this would give me a good idea that messages were being delivered to the devices.

How can I do this on BES using the BAS? I can't see a way to view all users on each BES, nor the fields that I used to use in BES 4?

[MikeQC]

I guess you can't if u use the BAS interface.. i can only see 1000 users since it's the max fetch size.

You could do a sql query on the db and get the info you want.. Probably something like:

SELECT US.LastContactTime, UC.MailBoxSMTPAddr, UC.CreationTime FROM UserStats US
INNER JOIN UserConfig UC ON UC.id = US.UserConfigId
ORDER BY US.LastContactTime