View Single Post
  #2 (permalink)  
Old 11-23-2015, 11:56 AM
hdawg's Avatar
hdawg hdawg is offline
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

Quote:
Originally Posted by mcooper View Post
I'm currently using the below sql query on BES 10

use BDSMgmt
SELECT u.DisplayName, u.EmailAddress, REPLACE(dh.PhoneNumber, '+44', '0') AS PhoneNumber, dh.PIN, dh.IMEI, dm.MarketName AS BBModel,
dh.PlatformVersion AS Platform, 'Deployed' AS AssetStatus, dm.DeviceModelKey, dh.HomeNetwork, dh.ICCID AS SIMNo
FROM DeviceHardware AS dh INNER JOIN
BASDevices AS bd ON bd.PIN = dh.PIN INNER JOIN
DeviceModel AS dm ON dh.HardwareId = dm.HardwareId INNER JOIN
BASUserDeviceAttributes AS da ON da.DeviceId = bd.DeviceId INNER JOIN
EASUsers AS u ON u.UserId = da.UserId

However we are in the process in moving to BES 12 and Blackberry have changed the sql tables again and the query no longer works
Sorry, I don't have a BES12 database to play with. Anyone got one?

__________________
http://blog.port3101.org/hdawg/
Reply With Quote