Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
SQL Script to search for user by phone number
 
  #1 (permalink)  
Old 02-02-2009, 11:17 AM
BES Activated
 
Join Date: Feb 2009
Location: DE
Posts: 3
Default SQL Script to search for user by phone number

We have found this usefull if the billing team needs to find out what user is incurring charges.

Just substitute 1231231234 with phone number and the user information will be displayed.

WARNING: This script is a SELECT statement. It will only be reading from your database. Don't go changing any data using other SQL statements as you could irrevocably destroy your BESMgmt database.
--------------------------------------------------------------------------------------
select uc.DisplayName,
uc.PIN,
ds.ModelName,
ds.AppsVer,
ds.PlatformVer,
ds.PhoneNumber,
ds.IMEI,
ds.HomeNetwork,
ds.ESN,
ds.ICCID,
ds.IMSI,
ds.FlashSize,
ds.ITPolicyName,
ds.ITPolicyTime from UserConfig uc
left join SyncDeviceMgmtSummary ds on uc.Id=ds.UserConfigId
where ds.PhoneNumber like '%1231231234%'
order by uc.DisplayName
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-02-2009, 11:58 AM
Joolie's Avatar
Super Moderator
 
Join Date: Dec 2008
Location: West Michigan
Posts: 763
Default

Thanks for sharing!
__________________
You may know me as Juwaack68
Reply With Quote
  #3 (permalink)  
Old 05-28-2009, 04:16 PM
BES Activated
 
Join Date: May 2009
Location: LA
Posts: 3
Default

I am getting the following error. Anyone knows how to fix it? thnx in advance.

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserConfig'.
Reply With Quote
  #4 (permalink)  
Old 05-28-2009, 04:23 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

Quote:
Originally Posted by imbadmin View Post
I am getting the following error. Anyone knows how to fix it? thnx in advance.

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.UserConfig'.
make sure you've selected the BESMgmt database.

Alternatively you could add the line:

USE BESMgmt;

or whatever your BlackBerry Configuration Database name is.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #5 (permalink)  
Old 05-28-2009, 05:22 PM
Otto's Avatar
Proprietor
 
Join Date: Nov 2008
Location: Atlanta, GA
Posts: 2,033
Blog Entries: 14
Default

...add that to the TOP of the statement
__________________
BCSA (4.1, 5.0) | BCSD (4.1, 5.0)

The views expressed by me on Port3101.org are my own and do not necessarily reflect the views of my employer.
Reply With Quote
  #6 (permalink)  
Old 06-03-2009, 08:08 PM
BES Activated
 
Join Date: May 2009
Location: LA
Posts: 3
Default

It worked. thnx again.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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

BB 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
Thread Thread Starter Forum Replies Last Post
BES User Role Listing Script Joolie Scripts & Tools / Hints & Tricks 9 02-10-2011 04:12 PM
KB16416 - User is prompted to press 1 to answer a phone call on the BlackBerry hdawg Featured BlackBerry KB Articles 0 07-30-2009 02:25 PM
KB16415 - How to switch to a new BlackBerry smartphone with the same phone number hdawg Featured BlackBerry KB Articles 0 07-30-2009 02:20 PM
KB15871 - Phone number or wireless service provider do not populate in BB Manager hdawg Featured BlackBerry KB Articles 0 05-26-2009 12:50 PM


All times are GMT -4. The time now is 12:54 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2