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



Reply
 
  #1 (permalink)  
Old 11-18-2015, 11:19 AM
BES Activated
 
Join Date: Nov 2015
Posts: 1
Default 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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 11-23-2015, 11:56 AM
hdawg's Avatar
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
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



All times are GMT -4. The time now is 01:34 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2