protected void loadData()
{
m_serverInstance.RefreshServer();
_label_Server.Text = m_serverInstance.ConnectionName;
_label_Version.Text = m_serverInstance.VersionFriendlyLong;
_label_Edition.Text = m_serverInstance.Edition;
//Start-SQLsecure 3.1 (Tushar)--Added support for Azure SQL Database
if (m_serverInstance.ServerType == ServerType.AzureSQLDatabase)
{
_label_Os.Visible = false;
}
else
{
_label_Os.Text = m_serverInstance.OS;
}
//End-SQLsecure 3.1 (Tushar)--Added support for Azure SQL Database
_label_CurrentSnapshotTime.Text = m_serverInstance.CurrentCollectionTime;
_label_LastSuccessfulTime.Text = m_serverInstance.LastCollectionTime;
_label_NextAuditTime.Text = m_serverInstance.NextCollectionTime;
_pictureBox_AuditStatus.Image = null;
Sql.Snapshot snap = Sql.Snapshot.GetSnapShot(m_serverInstance.LastCollectionSnapshotId);
if (snap != null)
{
_label_Duration.Text = snap.Duration;
_label_Objects.Text = snap.NumObject.ToString("n0");
_label_Permissions.Text = snap.NumPermission.ToString("n0");
_label_Logins.Text = snap.NumLogin.ToString("n0");
//Start-SQLsecure 3.1 (Tushar)--Added support for Azure SQL Database
if (m_serverInstance.ServerType == ServerType.AzureSQLDatabase)
{
this._lbl_ND.Text = "Azure AD accounts";
_label_GroupMembers.Text = Convert.ToString(Helper.AzureADUsersAndGroupCount(snap.SnapshotId));
}
else
{
this._lbl_ND.Text = "Windows accounts";
_label_GroupMembers.Text = snap.NumWindowsGroupMember.ToString("n0");
}
//End-SQLsecure 3.1 (Tushar)--Added support for Azure SQL Database
if (string.Compare(snap.Status, Utility.Snapshot.StatusSuccessful) == 0)
{
_pictureBox_AuditStatus.Image = AppIcons.AppImage48(AppIcons.EnumImageList48.StatusGood);
}
else if (string.Compare(snap.Status, Utility.Snapshot.StatusWarning) == 0)
{
_pictureBox_AuditStatus.Image = AppIcons.AppImage48(AppIcons.EnumImageList48.StatusWarning);
}
else
{
_pictureBox_AuditStatus.Image = AppIcons.AppImage48(AppIcons.EnumImageList48.StatusError);
}
List <Sql.Database> databases = Sql.Database.GetSnapshotDatabases(snap.SnapshotId);
if (databases != null)
{
_label_Databases.Text = databases.Count.ToString();
}
else
{
_label_Databases.Text = String.Empty;
}
List <Sql.WindowsAccount> accounts = Sql.WindowsAccount.GetSuspectAccounts(snap.SnapshotId);
//Start-SQLsecure 3.1 (Tushar)--Added support for Azure SQL Database
if (m_serverInstance.ServerType != ServerType.AzureSQLDatabase)
{
label5.Visible = true;
if (accounts != null)
{
int wellknownaccounts = 0;
foreach (Sql.WindowsAccount acct in accounts)
{
wellknownaccounts += (acct.AccountType == Sql.WindowsAccount.Type.WellKnownGroup) ? 1 : 0;
}
_label_WellKnownGroups.Text = wellknownaccounts.ToString("n0");
}
else
{
_label_WellKnownGroups.Text = String.Empty;
}
}
else
{
label5.Visible = false;
_label_WellKnownGroups.Visible = false;
}
if (m_serverInstance.ServerType == ServerType.AzureSQLDatabase)
{
_lbl_WindowsOS.Visible = false;
}
else
{
_lbl_WindowsOS.Visible = true;
}
//End-SQLsecure 3.1 (Tushar)--Added support for Azure SQL Database
}
else
{
_label_Duration.Text =
_label_Objects.Text =
_label_Permissions.Text =
_label_Logins.Text =
_label_GroupMembers.Text =
_label_Databases.Text =
_label_WellKnownGroups.Text = String.Empty;
}
}
