02-06-2014 06:56 AM
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.