View Single Post
Old 08-15-2012, 10:43 AM   #1 (permalink)
RobertBBadmin
New Member
 
Join Date: Aug 2012
Model: 9900
PIN: N/A
Carrier: AT&T
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES SQL Query question

Please Login to Remove!

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
Offline   Reply With Quote