Port3101.org : Your BES Connection

Port3101.org : Your BES Connection (http://www.port3101.org/index.php)
-   Scripts & Tools / Hints & Tricks (http://www.port3101.org/forumdisplay.php?f=12)
-   -   BES 12 SQL Query (http://www.port3101.org/showthread.php?t=3340)

mcooper 11-18-2015 11:19 AM

BES 12 SQL Query
 
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

hdawg 11-23-2015 11:56 AM

Quote:

Originally Posted by mcooper (Post 16345)
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?

:grandpa:


All times are GMT -4. The time now is 05:24 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.


SEO by vBSEO 3.3.2 PL2