A friend of mine wanted to take two scripts he had:

1. Obtained device free handheld memory
2. Grabbed some user info from various tables (Name, email address, BES, Mode, OS Version, Password status (enabled / disabled) IT Policy name & applied time)

and wanted them combined into a single query. The difficult thing is that to get free handheld memory you need to do some converting and parsing of data from the SyncDeviceMgmt table in the BlackBerry Configuration Database.

...

UPDATED:

Since creating the script below, I've put together a simpler one that works the same:

SELECT CAST(ServerDN AS VARCHAR(256)) , COUNT (*)
FROM UserConfig
GROUP BY CAST(ServerDN AS VARCHAR(256))

----------

RadHaz75 @ port3101.org posted a request for a SQL script to count the number of BES users per mail server in his BlackBerry Configuration Database.

I've posted the script in the thread, but here it is...