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



Reply
LinkBack (1) Thread Tools Display Modes
Script for listing applications installed on Blackberries
 
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 02-04-2009, 12:14 PM
AUTiger92's Avatar
BES Expert
 
Join Date: Jan 2009
Location: Alabama
Posts: 82
Default Script for listing applications installed on Blackberries

Anyone have a script to list application installed on Blackberries? I'm needing to show which users have VZNavigator installed on their Blackberries and really do not want to go one by one via the Blackberry Manager.
__________________
AUTIGER92
Exchange\Blackberry Admin
4 - BES Servers (4.1.6), 3 Exchange Organizations,
~1800 BB Users, and a headache.
War Eagle!!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-04-2009, 03:28 PM
BES Activated
 
Join Date: Feb 2009
Location: Houston, TX
Posts: 4
Default

You can use the following SQL script to return the names of the users who have VZNavigator installed.

Code:
SELECT     U.DisplayName
FROM         UserConfig U INNER JOIN
                      SyncDeviceMgmt S ON U.Id = S.UserConfigId
WHERE     (S.ModuleName = 'VZNavigator')
Reply With Quote
  #3 (permalink)  
Old 02-04-2009, 06:02 PM
AUTiger92's Avatar
BES Expert
 
Join Date: Jan 2009
Location: Alabama
Posts: 82
Default

Getting "Invalid object name 'UserConfig'." error.
__________________
AUTIGER92
Exchange\Blackberry Admin
4 - BES Servers (4.1.6), 3 Exchange Organizations,
~1800 BB Users, and a headache.
War Eagle!!
Reply With Quote
  #4 (permalink)  
Old 02-04-2009, 06:35 PM
BES Activated
 
Join Date: Feb 2009
Location: Houston, TX
Posts: 4
Default

You can either:
Add a
Code:
USE <DATABASENAME>
line the beginning of the script and replace <DATABASENAME> with BESMgmt or the name of your database.

Or if you're using Query Analyzer, just select your database from the drop down dialog.
Reply With Quote
  #5 (permalink)  
Old 02-04-2009, 07:06 PM
AUTiger92's Avatar
BES Expert
 
Join Date: Jan 2009
Location: Alabama
Posts: 82
Default

Doh! My SQL knowledge is enough to get me in trouble. Script works great.

Thanks
__________________
AUTIGER92
Exchange\Blackberry Admin
4 - BES Servers (4.1.6), 3 Exchange Organizations,
~1800 BB Users, and a headache.
War Eagle!!
Reply With Quote
  #6 (permalink)  
Old 02-04-2009, 08:33 PM
Joolie's Avatar
Super Moderator
 
Join Date: Dec 2008
Location: West Michigan
Posts: 763
Default

Nice script, thanks.
__________________
You may know me as Juwaack68
Reply With Quote
  #7 (permalink)  
Old 04-16-2009, 05:46 PM
BES Activated
 
Join Date: Apr 2009
Location: kansas
Posts: 6
Default Is there a way to creat a webpage off of this

I was just thinking it would be a nice to have webpage where someone could enter an application hit submit on a webpage and then the results would be returned to them in a nice frameset. Would that be possible??
Reply With Quote
  #8 (permalink)  
Old 04-16-2009, 06:52 PM
Sith_Apprentice's Avatar
Super Moderator
 
Join Date: Dec 2008
Posts: 1,056
Default

You can also just use excel if you dont like the sql queries. It can connect to the external DB and you can change what info you want to see.
__________________
Reply With Quote
  #9 (permalink)  
Old 04-16-2009, 07:40 PM
BES Activated
 
Join Date: Apr 2009
Location: kansas
Posts: 6
Default

If I wanted to do this via the web like an asp page could I just embed Excel? I guess I'm not sure what you mean by using excel. Are you just referring to using Excel for the output in SQL Manager?
Reply With Quote
  #10 (permalink)  
Old 04-16-2009, 09:22 PM
Sith_Apprentice's Avatar
Super Moderator
 
Join Date: Dec 2008
Posts: 1,056
Default

You can set Excel to do the SQL queries for you. Was more saying that for the comment earlier about knowing enough SQL to get the user in trouble.
__________________
Reply With Quote
  #11 (permalink)  
Old 08-12-2009, 02:40 PM
RadHaz75's Avatar
BES Expert
 
Join Date: May 2009
Location: Philadelphia, PA
Posts: 98
Default

how would you do this and also return what BES they are on? i cant seem to get the coding correct. stupid joins.
__________________
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.
Reply With Quote
  #12 (permalink)  
Old 08-12-2009, 03:00 PM
RadHaz75's Avatar
BES Expert
 
Join Date: May 2009
Location: Philadelphia, PA
Posts: 98
Default

NM, once again i'm impatient. the following code will return the display name, smtp, bes instance, version of app and their device model...

Code:
SELECT U.DisplayName, U.MailboxSMTPAddr, C.ServiceName, S.ModuleVersion, D.ModelName
FROM UserConfig U INNER JOIN SyncDeviceMgmt S ON U.Id = S.UserConfigId, ServerConfig C, SyncDeviceMgmtSummary D
WHERE (S.ModuleName = 'net_rim_bb_qm_lcs') and C.Id = U.ServerConfigId and U.ID = D.UserConfigID
i need this so that when we finally install LCS CWA, i need to push the new app (LCS version) to everyone who has it installed (Windows Messenger version). i also need to know who has a storm to give them the special version.
__________________
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.
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


LinkBacks (?)
LinkBack to this Thread: http://www.port3101.org/scripts-tools-hints-tricks/477-script-listing-applications-installed-blackberries.html
Posted By For Type Date
Blackberry App Audit - BlackBerryForums.com : Your Number One BlackBerry Community This thread Pingback 09-21-2009 11:01 AM

Similar Threads
Thread Thread Starter Forum Replies Last Post
BES User Role Listing Script Joolie Scripts & Tools / Hints & Tricks 9 02-10-2011 04:12 PM
Script to pull all 3rd Party Apps installed klove Scripts & Tools / Hints & Tricks 12 11-17-2010 08:49 AM
UAE/India and Blackberries, how is your organization planning on dealing with it? Zippygit Port 3101: The BES Admin Bar & Grill 6 08-05-2010 11:20 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
KB15364 - List applications installed on BlackBerry smartphones hdawg Featured BlackBerry KB Articles 0 06-23-2009 11:14 PM


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


 

SEO by vBSEO 3.3.2 PL2