Port3101.org : Your BES Connection

Port3101.org : Your BES Connection (http://www.port3101.org/index.php)
-   Scripts & Tools / Hints & Tricks (http://www.port3101.org/forumdisplay.php?f=12)
-   -   Script for listing applications installed on Blackberries (http://www.port3101.org/showthread.php?t=477)

AUTiger92 02-04-2009 12:14 PM

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.

ronster76 02-04-2009 03:28 PM

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')


AUTiger92 02-04-2009 06:02 PM

Getting "Invalid object name 'UserConfig'." error.

ronster76 02-04-2009 06:35 PM

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.

AUTiger92 02-04-2009 07:06 PM

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

Thanks

Joolie 02-04-2009 08:33 PM

Nice script, thanks.

hayabusa 04-16-2009 05:46 PM

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??

Sith_Apprentice 04-16-2009 06:52 PM

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.

hayabusa 04-16-2009 07:40 PM

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?

Sith_Apprentice 04-16-2009 09:22 PM

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.

RadHaz75 08-12-2009 02:40 PM

how would you do this and also return what BES they are on? i cant seem to get the coding correct. stupid joins.

RadHaz75 08-12-2009 03:00 PM

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.


All times are GMT -4. The time now is 10:29 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


SEO by vBSEO 3.3.2 PL2