07-17-2009, 03:35 PM
Join Date: Jun 2009
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;Registration:Etisalat3Registrati onEt isalat network upgrade for Blackberry service. Please download to ensure continous service quality.4.9100Etisalat " or
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%'));