I created a new view in my database and then I excluded some basic firmware noise and applicaitons that I knew I allowed on my devices. Feel free to take out the applications in the view that you don't allow so you can report on them.
======================================================
SELECT TOP (100) PERCENT U.MailboxSMTPAddr AS Email, S.ModuleName AS Application, S.ModuleVersion AS AppVersion, U.PIN
FROM dbo.UserConfig AS U INNER JOIN
dbo.SyncDeviceMgmt AS S ON U.Id = S.UserConfigId
WHERE (S.ModuleName NOT LIKE 'net_%') AND (S.ModuleName NOT LIKE 'DocsToGo%') AND (S.ModuleName NOT LIKE 'SheetToGo%') AND
(S.ModuleName NOT LIKE 'SlideshowToGo%') AND (S.ModuleName NOT LIKE 'WordToGo%') AND (S.ModuleName NOT LIKE 'com_bloomberg%') AND
(S.ModuleName NOT LIKE 'RepliGoPro%') AND (S.ModuleName NOT LIKE 'KlonDike%') AND (S.ModuleName NOT LIKE 'Sudoku%') AND
(S.ModuleName NOT LIKE 'SecurIDLib%') AND (S.ModuleName NOT LIKE 'TeleNav%') AND (S.ModuleName NOT LIKE 'Navigator%') AND
(S.ModuleName NOT LIKE 'Facebook%') AND (S.ModuleName NOT LIKE 'THK2%') AND (S.ModuleName NOT LIKE 'rwdsclient%') AND
(S.ModuleName NOT LIKE 'VZNavigator%') AND (S.ModuleName NOT LIKE 'salesforce_%') AND (S.ModuleName NOT LIKE 'bn_plugin%') AND
(S.ModuleName NOT LIKE 'bn_rim%') AND (S.ModuleName NOT LIKE 'THK3%') AND (S.ModuleName NOT LIKE 'Sage%') AND
(S.ModuleName NOT LIKE 'dynamic%') AND (S.ModuleName NOT LIKE 'WSJournal%') AND (S.ModuleName NOT LIKE 'vmail_%') AND
(S.ModuleName NOT LIKE 'vvmlistener_%') AND (S.ModuleName NOT LIKE 'trwdsclient%') AND (S.ModuleName NOT LIKE 'vvmlib%') AND
(S.ModuleName NOT LIKE 'tn_rim_%') AND (S.ModuleName NOT LIKE 'tn51__%') AND (S.ModuleName NOT LIKE 'sn_%') AND
(S.ModuleName NOT LIKE 'sn21_%') AND (S.ModuleName NOT LIKE 'Reuters%') AND (S.ModuleName NOT LIKE 'tn55_%') AND
(S.ModuleName NOT LIKE 'com_%') AND (S.ModuleName NOT LIKE 'vvmail_%') AND (S.ModuleName NOT LIKE 'tnmaps_%') AND
(S.ModuleName NOT LIKE 'MPTT%') AND (S.ModuleName NOT LIKE 'RimGanInjector%') AND (S.ModuleName NOT LIKE 'KnJCDE%') AND
(S.ModuleName NOT LIKE 'com_plazmic_themereader%')
ORDER BY Application