Here is the code that fills the main datagridview
Code:
SELECT TOP 100 PERCENT dbo.UserConfig.DisplayName, dbo.UserConfig.PIN, dbo.SyncDeviceMgmtSummary.PhoneNumber,
dbo.SyncDeviceMgmtSummary.IMEI, dbo.SyncDeviceMgmtSummary.HomeNetwork, dbo.SyncDeviceMgmtSummary.AppsVer,
dbo.SyncDeviceMgmtSummary.ModelName,
CASE dbo.SyncDeviceMgmtSummary.PasswordEnabled WHEN 1 THEN 'True' WHEN 0 THEN 'False' END AS 'PasswordEnabled',
CASE dbo.UserStats.Status WHEN 12 THEN 'Running' WHEN 10 THEN 'In cradle' WHEN 0 THEN 'Initializing' END AS 'Status',
dbo.SyncDeviceMgmtSummary.ITPolicyName, dbo.UserStats.UserConfigId, dbo.UserStats.MsgsForwarded, dbo.UserStats.MsgsSent,
dbo.UserStats.MsgsPending, dbo.UserStats.MsgsExpired, dbo.UserStats.MsgsFiltered, dbo.UserStats.MsgsFailed, dbo.UserConfig.CreationTime,
dbo.UserConfig.ActivationTime, dbo.UserStats.LastFwdTime, dbo.UserStats.LastSentTime,
CASE dbo.UserConfig.RedirectWhenInCradle WHEN 1 THEN 'True' WHEN 0 THEN 'False' END AS 'RedirectWhenInCradle',
dbo.UserConfig.MailboxSMTPAddr, dbo.UserConfig.OverrideSMTPAddr, dbo.UserConfig.MailboxDN, dbo.UserConfig.ServerDN,
dbo.GroupConfig.GroupName, dbo.GroupConfig.Description AS 'GroupDescription'
FROM dbo.UserConfig FULL OUTER JOIN
dbo.GroupConfig ON dbo.UserConfig.GroupConfigId = dbo.GroupConfig.Id FULL OUTER JOIN
dbo.UserStats ON dbo.UserConfig.Id = dbo.UserStats.UserConfigId FULL OUTER JOIN
dbo.SyncDeviceMgmtSummary ON dbo.UserConfig.Id = dbo.SyncDeviceMgmtSummary.UserConfigId
ORDER BY dbo.UserConfig.DisplayName
here is the code that gets the server info displayed in the label.
Code:
SELECT MachineName, BESVersion
FROM ServerConfig