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)
-   -   How many devices running each OS? (http://www.port3101.org/showthread.php?t=2610)

sbaker33 04-15-2011 06:31 PM

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

SteveE 04-18-2011 04:53 PM

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.

sbaker33 04-25-2011 04:07 PM

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


All times are GMT -4. The time now is 03:56 PM.

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


SEO by vBSEO 3.3.2 PL2