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



Reply
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.

Thanks

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

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
Default

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:

SELECT
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
FROM
dbo.UserConfig
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
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
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 04:58 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2