View Single Post
  #1 (permalink)  
Old 02-02-2009, 11:17 AM
Snapp Snapp is offline
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