07-17-2009, 03:35 PM
|
#9 (permalink)
|
| New Member
Join Date: Jun 2009 Model: 8310 PIN: N/A Carrier: AT&T
Posts: 4
Post Thanks: 0 Thanked 0 Times in 0 Posts
| I just put this in another spot, but, I'll put it here too for BES admins who may read this:
I have confirmed with RIM that ETISALAT did in fact send suspicious code to many Middle Eastern devices. The name of the application is
"Registration" or
"Registration;Registration:Etisalat3Registrati onEt isalat network upgrade for Blackberry service. Please download to ensure continous service quality.4.9100Etisalat " or
"Registration4.9100191406 "
======
You can determine if the application has been installed by an end user by querying the table dbo_SyncDeviceMgmt and the field Data for:
Like '%registration%' <-meaning contains "registration"
You will need to link the table to the dbo_UserConfig table in order to determine the user's Display Name or identifying information. The ID fields are different, use the dbo_SyncDeviceMgmt.UserConfigId joined to the dbo_UserConfig.ID field and you should be able to get a list of users who have installed the application to their devices.
=======
Here is my query:
-
SELECT dbo_SyncDeviceMgmt.Data, dbo_UserConfig.DisplayName, dbo_SyncDeviceMgmt.UserConfigId, dbo_SyncDeviceMgmt.Id, dbo_UserConfig.Id
FROM HOUBLAK301 INNER JOIN dbo_SyncDeviceMgmt ON dbo_UserConfig.Id = dbo_SyncDeviceMgmt.UserConfigId
WHERE (((dbo_SyncDeviceMgmt.Data) Like '%registration%')); |
| Offline
| |