BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/)
-   BES Admin Corner (http://www.blackberryforums.com/bes-admin-corner/)
-   -   BES SQL Query question (http://www.blackberryforums.com/bes-admin-corner/261063-bes-sql-query-question.html)

RobertBBadmin 08-15-2012 10:43 AM

BES SQL Query question
 
Hi I am new to SQL queries. I am using the one below to extract the users smtp email address, user name and mail server. I would like to filter the servers so that the query only returns back results for users on specific mail servers. How would I edit the query to accomplish that. I currently sort and filter the results in Excel. I am looking for a way to automate it so other members of my team can refresh the data.


use BESMgmt
select MailboxSMTPAddr as EmailAddress, displayname as "Display Name",
ServerDN as "Email Server"

from syncdevicemgmtsummary a
inner join
userconfig b
on a.userconfigid=b.id

knottyrope 08-15-2012 11:20 AM

Re: BES SQL Query question
 
lots of info here on scripts

Scripts & Tools / Hints & Tricks - Port3101.org : Your BES Connection


All times are GMT -5. The time now is 12:29 PM.

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.