Does anyone know of a way to find out which third party applications are installed on all BES users handhelds? We are running one BES (4.1) with a remote SQL server. I have been looking in the SQL database for this info but can't seem to locate the table that stores this info.
Thanks in advance

Edit Properties for the user and got to the BlackBerry Device read only section.
Please note that this may not be up to date.

I know where to find the data via Blackberry Manager but I do not want to go into the properties of over 1100 users to see what apps are installed. I was hoping to do a query from the database.
Thanks anyways

This data is not realtime either but its a start...

Create a function in the SQL Database...

Create Function dbo.fnStripTags
(@Dirty varchar(4000))
Returns varchar(4000)
As

BEGIN
DECLARE @Start int, @End int, @Length int

SELECT @Start = CharIndex('>', @Dirty, CharIndex('<t4>', @Dirty))
SELECT @End = CharIndex('<', @Dirty, CharIndex('</t4>', @Dirty))
SELECT @Length = (@End - @Start) - 1
If @Length > 0
BEGIN
SET @Dirty = Substring(@Dirty, @Start + 1, @Length)
END

RETURN @Dirty
END

Run the function on the data field in vHandheldInfo.

SELECT PIN, fnStripTags(data) FROM vHandheldInfo

The <t4> field will occasionally provide the name of the app installed. If I add an additional filter to get rid of entries that are numbers it gives a readable list.