Script to list users per bes

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

Script for listing apps installed on bb

Script for listing applications installed on blackberry

SELECT U.DisplayName, U.MailboxSMTPAddr, C.ServiceName, S.ModuleVersion, D.ModelName
FROM UserConfig U INNER JOIN SyncDeviceMgmt S ON U.Id = S.UserConfigId, ServerConfig C, SyncDeviceMgmtSummary D
WHERE (S.ModuleName = 'net_rim_bb_qm_lcs') and C.Id = U.ServerConfigId and U.ID = D.UserConfigID