BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-15-2012, 10:43 AM   #1 (permalink)
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  
Old 08-15-2012, 11:20 AM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,176
Post Thanks: 361
Thanked 373 Times in 343 Posts
Default Re: BES SQL Query question

lots of info here on scripts

Scripts & Tools / Hints & Tricks - Port3101.org : Your BES Connection
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads for: BES SQL Query question
Thread Thread Starter Forum Replies Last Post
BES 4.1 Upgrade to 5.0.2 with SQL Mirroring (parallel with Ex2003 to Ex2010 upgrade) Jay247 BES Admin Corner 4 11-21-2010 10:05 AM
bes 5.0 ha sql mirror placement of witness server elbutre BES Admin Corner 0 10-05-2010 07:10 AM
Single BES/SQL to new BES and remote SQL RipThorn BES Admin Corner 4 06-26-2008 04:14 PM
Another Activating Initializing on BB Professional patrickd26 BES Admin Corner 4 05-06-2008 05:12 AM
BES 4.1 with a SQL Cluster(Named Instance) and non-default SQL port Korbyn BES Admin Corner 1 05-16-2006 03:02 PM

Genuine OEM Dell RF223 High Yield Toner Cartridge CN-0RF223 5,000 18115dn NIB
$28.0
Genuine OEM Dell RF223 High Yield Toner Cartridge CN-0RF223 5,000 18115dn NIB pictureGenuine OEM Dell 3200MP Osram Replacement Lamp & Housing 310-2328
$79.99
Genuine OEM Dell 3200MP Osram Replacement Lamp & Housing  310-2328 picture(J158) Dell 130w PA-4E OEM (DA130PE1-00) Genuine Laptop AC Power Adapter
$25.0
(J158) Dell 130w PA-4E OEM (DA130PE1-00) Genuine Laptop AC Power Adapter pictureOEM Original Philips UHP 210/160W 0.9 Projector Bare Lamp For Dell 1510X/1610HD
$25.0
OEM Original Philips UHP 210/160W 0.9 Projector Bare Lamp For Dell 1510X/1610HD pictureOEM Original Philips UHP 210/160W 0.9 Projector Bare Lamp For Dell 1510X/1610HD
$45.0
OEM Original Philips UHP 210/160W 0.9 Projector Bare Lamp For Dell 1510X/1610HD picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.