Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
Script to pull all 3rd Party Apps installed
 
  #1 (permalink)  
Old 02-24-2010, 12:34 AM
BES Activated
 
Join Date: Feb 2010
Location: Milwaukee
Posts: 3
Question Script to pull all 3rd Party Apps installed

I'm looking to disable installation of 3rd party apps. But I would like to review all 3rd party apps installed. I don't want to manually look at each user.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-24-2010, 07:09 AM
BES Administrator
 
Join Date: Feb 2009
Posts: 21
Default

Just create a software configuration where you set the Disposition for unlisted applications to disallowed.

Then assign those to the users/groups.
Reply With Quote
  #3 (permalink)  
Old 02-24-2010, 08:58 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

setting a Disposition for unlisted applications to disallowed will remove them without letting the OP review them.

If you want to get a list of all installed applications you can either dig through each user to see what applications they have installed.

You can use the BRK tool BlackBerry Application Reporting Tool with the following syntax to pull info on applications installed.

HHAppReport -n SQLSERVER -db BESMgmtDATABASE
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #4 (permalink)  
Old 02-24-2010, 11:28 AM
leob's Avatar
BES Administrator
 
Join Date: Feb 2009
Location: Michigan
Posts: 12
Default

Is there a way to use the BRK to get a list of 3rd party apps by user? Thanks!
Reply With Quote
  #5 (permalink)  
Old 02-24-2010, 11:38 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

see KB15364 - List applications installed on BlackBerry smartphones
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #6 (permalink)  
Old 02-24-2010, 06:37 PM
BES Activated
 
Join Date: Feb 2010
Location: Milwaukee
Posts: 3
Default

OK, this sounds like just what I want
I will set up a small server and install the resource kit on it.
Thanks
Reply With Quote
  #7 (permalink)  
Old 02-24-2010, 08:44 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

There's not need to setup a server; just run the tool on the BES. Sure officially RIM will never say to do that, but it is just fine ... its just a performance hit.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #8 (permalink)  
Old 03-04-2010, 10:00 AM
noname's Avatar
BES Administrator
 
Join Date: Apr 2009
Location: Congested Islet of Foreign Talents (42% of population) - Singapore.
Posts: 24
Default

But HHAppReport -n SQLSERVER -db BESMgmtDATABASE is per Domain...

What about "per user" or "per PIN"?
__________________
【noname】- Native but 3rd class citizen of a nation governed by idiots who import congestions and contention.
BlackBerry® Certified Solution Designer + System Administrator
IBM Certified Advanced Application Developer + Associate System Administrator - Lotus Notes and Domino
Reply With Quote
  #9 (permalink)  
Old 05-25-2010, 02:03 AM
Sp1d3rM@n's Avatar
BES Administrator
 
Join Date: Jul 2009
Location: Nowhere, USA
Posts: 46
Default

noname - That KB that hdawg listed talks about using HHAppReport to get a list of all apps (with no user or qty info) and also using BESUserAdminClient to target a single user and get their apps, or list all users with a single appname. in the past all three ways have been useful for me depending on what people asked to see.

Now I need to report on all apps for 10k users.. monthly. I guess I will be looking at querying the BESmgmt directly for this info

Last edited by Sp1d3rM@n; 05-25-2010 at 02:05 AM. Reason: typos
Reply With Quote
  #10 (permalink)  
Old 07-30-2010, 10:51 AM
Banned
 
Join Date: Jul 2010
Posts: 1
Default

hmm, that make sense
Reply With Quote
  #11 (permalink)  
Old 08-02-2010, 10:12 PM
BES Activated
 
Join Date: Feb 2009
Location: Sydney, Australia
Posts: 5
Default

I use the following SQL query on the besmgmt database to get a list of all applications installed, ordered by user.

Quote:
SELECT U.DisplayName, U.MailboxSMTPAddr, S.ModuleName, S.ModuleVersion
FROM UserConfig U INNER JOIN
SyncDeviceMgmt S ON U.Id = S.UserConfigId
WHERE S.ModuleName NOT LIKE 'net_rim_%'
ORDER BY U.DisplayName
Reply With Quote
  #12 (permalink)  
Old 08-16-2010, 03:43 PM
BES Activated
 
Join Date: Apr 2009
Location: kansas
Posts: 6
Default script to poll applications

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
Reply With Quote
  #13 (permalink)  
Old 11-17-2010, 08:49 AM
Joolie's Avatar
Super Moderator
 
Join Date: Dec 2008
Location: West Michigan
Posts: 763
Default

Quote:
Originally Posted by Burnsie View Post
I use the following SQL query on the besmgmt database to get a list of all applications installed, ordered by user.
Genius! Thanks!
__________________
You may know me as Juwaack68
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
3rd party downloads and unlisted apps BES 5.0 MaxTPower Port 3101: The BES Admin Bar & Grill 2 08-07-2012 11:27 AM
BES 5.0.2 and 3rd party apps help leob Port 3101: The BES Admin Bar & Grill 2 10-01-2010 09:33 AM
How To: Backup 3rd Party Apps John Clark Power Users 12 02-02-2010 07:31 AM
script to pull Blackbery encryption AUTiger92 Scripts & Tools / Hints & Tricks 5 01-31-2010 09:24 PM
Removing third party applications installed prior to IT policy to block them... NATIONAL BES ADMIN Port 3101: The BES Admin Bar & Grill 3 10-07-2009 03:44 AM


All times are GMT -4. The time now is 02:24 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2