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

LinkBack Thread Tools Display Modes
How many devices running each OS?
  #1 (permalink)  
Old 04-15-2011, 06:31 PM
BES Activated
Join Date: Apr 2011
Posts: 4
Default How many devices running each OS?

Is there way to determine how many devices are running each OS version? I don't need subversions (although that would be fine) just need to know how many are 4.x, 5.x, etc.

I am a noob so if this is answered somewhere else or is in the UI please direct me there.


Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-18-2011, 04:53 PM
BES Activated
Join Date: May 2010
Posts: 3

If you're running BES 5 or higher, you can generate a report within the monitoring interface that will give you the software version of the devices in your environment.
Reply With Quote
  #3 (permalink)  
Old 04-25-2011, 04:07 PM
BES Activated
Join Date: Apr 2011
Posts: 4

Thanks SteveE.

I haven't had and time and open change windows to implement Monitoring Services but I did find this query that gave me what I needed and seemed pretty useful. So, I thought I would share it:

dbo.UserConfig.DisplayName AS Name,
dbo.ServerConfig.ServiceName AS [BES Server],
dbo.UserConfig.ServerDN AS [Exchange Server],
dbo.UserConfig.PIN AS PIN, dbo.ITPolicy2.PolicyName AS [IT Policy],
dbo.HandheldConfig.Name AS [Software Configuration],
dbo.SyncDeviceMgmtSummary.ModelName AS BBModel,
dbo.SyncDeviceMgmtSummary.PlatformVer AS PlatformVer,
dbo.SyncDeviceMgmtSummary.AppsVer AS AppsVer,
dbo.SyncDeviceMgmtSummary.IMEI AS IMEI, dbo.UserConfig.CreationTime AS CreationTime,
dbo.UserConfig.MailboxSMTPAddr AS emailaddress
LEFT OUTER JOIN dbo.ServerConfig ON dbo.UserConfig.ServerConfigId = dbo.ServerConfig.Id
LEFT OUTER JOIN dbo.ITPolicy2 ON dbo.UserConfig.ITPolicy2Id = dbo.ITPolicy2.Id
LEFT OUTER JOIN dbo.UserStats ON dbo.UserConfig.Id = dbo.UserStats.Id
LEFT OUTER JOIN dbo.HandheldConfig ON dbo.HandheldConfig.Id = dbo.UserConfig.HandheldConfigId
LEFT OUTER JOIN dbo.SyncDeviceMgmtSummary ON dbo.SyncDeviceMgmtSummary.UserConfigId = dbo.UserConfig.Id
Reply With Quote

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
BES Express and BES Running Together thecollin Port 3101: The BES Admin Bar & Grill 2 03-04-2010 01:41 AM
Anyone running BES 4.1.6.x with Exchange 2007 SP2? Zippygit Port 3101: The BES Admin Bar & Grill 4 11-27-2009 05:08 PM
KB18321 - How to verify that the BlackBerry MVS services are running hdawg Featured BlackBerry KB Articles 0 07-30-2009 10:09 AM
KB16208 - Both primary and standby BES instances are running in Standby mode hdawg Featured BlackBerry KB Articles 0 07-15-2009 02:16 PM
KB15990 - Requirements for running the BlackBerry Calendar Sync Tool (TraitTool.exe) hdawg Featured BlackBerry KB Articles 0 05-26-2009 12:49 PM

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


SEO by vBSEO 3.3.2 PL2