View Single Post
  #3 (permalink)  
Old 04-25-2011, 04:07 PM
sbaker33 sbaker33 is offline
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