Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
Highlighted
New Contributor
Posts: 3
Registered: ‎02-06-2014
My Device: Developer
My Carrier: Other

BlackBerry User Summary Reports in BES 10.2

The SQL query we have been using to get User summary report by using "vUserConfigStats" view and ServerConfig table in BES 5.0.x is not working in BES 10.x.

 

SELECT US.[Id], US.[DisplayName], US.[PIN], US.[MsgsForwarded], US.[MsgsSent], US.[MsgsPending], US.[MsgsExpired], US.[MsgsFiltered], US.[MsgsFailed]  FROM dbo.[ServerConfig] SC  JOIN dbo.[vUserConfigStats] US ON SC.[Id] = US.[ServerConfigId] WHERE SC.[ServiceName] = 'ManishBES10' AND [ActivationTime] IS NOT NULL ORDER BY US.[DisplayName]

 

Now since MAPI is not supported in BES 10.x so not sure how to get this information in BES 10. Any help would be highly appreciated. Thanks.