[cavy]

What i would like to know if there is anyway to poll all the devices on the system to see what apps they have installed? Our purchasing dept currently controls the blackberry devices and i just run the server for them. The reason i am wondering this is because they don't have the wap shut down so people can't download stuff from the app stores. I want to gather some evidence so i can get wap shut off because it will be a cost savings to the company as of right now you can download anything from wap and it just gets added to the companies bill. Any info would be greatly appreciated.

[Frank Castle]

Not that you can export. You can look at each person's properties / Blackberry Device (read only) and look through Applications.

I believe your carrier can do something on the plan side to prevent this as I cannot buy ringtones / wallpaper etc. I can check with our procurement team that manages that side and find out what they did.

[mahoward]

You can try this SQL query, but it will tax your SQL server for a bit if you have a lot of users. You can then sort the Data field and get rid of the RIM modules listed.

SELECT UserConfig.DisplayName , SyncDeviceMgmt.* FROM SyncDeviceMgmt INNER JOIN UserConfig ON SyncDeviceMgmt.UserConfigId = UserConfig.Id

If you just want to search on a specific app, you can do this:

SELECT UserConfig.DisplayName , SyncDeviceMgmt.* FROM SyncDeviceMgmt INNER JOIN UserConfig ON SyncDeviceMgmt.UserConfigId = UserConfig.Id WHERE (SyncDeviceMgmt.Data LIKE '%metamessage%')

In this case I was searching for a 3rd party product called MetaMessage to see who still had it cause we are decommissioning it.