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

Thanks for sharing!

__________________
You may know me as Juwaack68

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/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.

...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.

It worked. thnx again.