[jgroh9]

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.

[jgroh9]

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

[jinksPadlock]

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.