public View_Logins()
{
InitializeComponent();
m_menuConfiguration = new Utility.MenuConfiguration();
this._label_Summary.Text = Utility.Constants.ViewSummary_Logins;
_smallTask_NewLogin.TaskText = Utility.Constants.Task_Title_NewLogins;
_smallTask_NewLogin.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.NewLogin);
_smallTask_NewLogin.TaskHandler += new System.EventHandler(this.newLogin);
_dt_logins.Columns.Add(colTypeIcon, typeof(Image));
_dt_logins.Columns.Add(colHeaderName, typeof(String));
_dt_logins.Columns.Add(colHeaderType, typeof(String));
_dt_logins.Columns.Add(colHeaderServerAccess, typeof(String));
_dt_logins.Columns.Add(colHeaderPermission, typeof(String));
newLoginToolStripMenuItem.Image = AppIcons.AppImage16(AppIcons.Enum.NewSQLsecureLogin);
deleteToolStripMenuItem.Image = AppIcons.AppImage16(AppIcons.Enum.Remove);
refreshToolStripMenuItem.Image = AppIcons.AppImage16(AppIcons.Enum.Refresh);
propertiesToolStripMenuItem.Image = AppIcons.AppImage16(AppIcons.Enum.Properties);
_grid_Logins.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
}
public PolicyChangeLog()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
// hook the toolbar labels to the grids so the heading can be used for printing
_grid_ChangeLog.Tag = _label_ChangeLog;
// hook the grids to the toolbars so they can be used for button processing
_headerStrip_ChangeLog.Tag = _grid_ChangeLog;
// Hookup all application images
_toolStripButton_ColumnChooser.Image = AppIcons.AppImage16(AppIcons.Enum.GridFieldChooser);
_toolStripButton_GroupBy.Image = AppIcons.AppImage16(AppIcons.Enum.GridGroupBy);
_toolStripButton_Save.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_toolStripButton_Print.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
// set all grids to start in the same initial display mode
_grid_ChangeLog.DisplayLayout.GroupByBox.Hidden = Utility.Constants.InitialState_GroupByBoxHidden;
// Initialize the grids
initDataSources();
// Hide the focus rectangles on tabs and grids
_grid_ChangeLog.DrawFilter = new HideFocusRectangleDrawFilter();
}
public View_PermissionExplorer() : base()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
// Setup the summary label.
_label_Summary.Text = Utility.Constants.ViewSummary_Permissions;
// Setup tasks.
_smallTask_Collect.TaskText = Utility.Constants.Task_Title_CollectData;
_smallTask_Collect.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.Snapshot);
_smallTask_Collect.TaskHandler += new System.EventHandler(this.collectData);
_smallTask_Configure.TaskText = Utility.Constants.Task_Title_Configure;
_smallTask_Configure.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.ConfigureAuditSettings);
_smallTask_Configure.TaskHandler += new System.EventHandler(this.configureServer);
//force to initial disable because there is no security handler at initial construction
_smallTask_Collect.Enabled = false;
_smallTask_Configure.Enabled = false;
// Hide the focus rectangles on tabs and grids
_ultraTabControl.DrawFilter = new HideFocusRectangleDrawFilter();
}
public View_Main_SecuritySummary()
{
InitializeComponent();
// Initialize menu configuration.
m_MenuConfiguration = new Utility.MenuConfiguration();
_ultraToolbarsManager.Tools[RibbonTaskButton.AddPolicy].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.EditPolicy].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.CopyAssessment].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.Compare].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.AddServer].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.Configure].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.TakeSnapshot].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.ExploreUsers].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.ExploreRoles].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.ExploreObjects].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.ImportServers].SharedProps.Enabled = false;
// Dock the controls that are not docked in the designer for visibility
_policySummary.Dock =
_sqlServerSettings.Dock =
_policyUsers.Dock =
_label_Msg.Dock = DockStyle.Fill;
_label_Msg.Text = DisplayNoServers;
_label_Msg.Visible =
_sqlServerSettings.Visible =
_policyUsers.Visible = false;
_policySummary.Visible = true;
}
public View_PolicyAssessment()
{
InitializeComponent();
// Initialize menu configuration.
m_MenuConfiguration = new Utility.MenuConfiguration();
_ultraToolbarsManager.Tools[RibbonTaskButton.EditPolicy].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.UpdatePolicyFindings].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.Promote].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.CopyAssessment].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.Compare].SharedProps.Enabled =
_ultraToolbarsManager.Tools[RibbonTaskButton.TakeSnapshot].SharedProps.Enabled = false;
// Dock the controls that are not docked in the designer for visibility
_policySummary.Dock =
_policyChangeLog.Dock =
_label_Msg.Dock = DockStyle.Fill;
_label_Msg.Text = DisplayNoServers;
_label_Msg.Visible =
_policyChangeLog.Visible = false;
_policySummary.Visible = true;
_policySummary.RegisterReportCardMetricChangedDelegate(ReportCardMetricChanged);
}
public AuditedServers()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
// hook the toolbar labels to the grids so the heading can be used for printing
_grid_Servers.Tag = _label_AuditedServers;
_grid_Databases.Tag = _label_Databases;
// hook the grids to the toolbars so they can be used for button processing
_headerStrip_Servers.Tag = _grid_Servers;
_headerStrip_Databases.Tag = _grid_Databases;
_toolStripButton_ServersColumnChooser.Image =
_toolStripButton_DatabasesColumnChooser.Image = AppIcons.AppImage16(AppIcons.Enum.GridFieldChooser);
_toolStripButton_ServersGroupBy.Image =
_toolStripButton_DatabasesGroupBy.Image = AppIcons.AppImage16(AppIcons.Enum.GridGroupBy);
_toolStripButton_ServersSave.Image =
_toolStripButton_DatabasesSave.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_toolStripButton_ServersPrint.Image =
_toolStripButton_DatabasesPrint.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
_cmsi_Server_exploreUserPermissions.Image = AppIcons.AppImage16(AppIcons.Enum.UserPermissions);
_cmsi_Server_exploreSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.ObjectExplorer);
_cmsi_Server_properties.Image = AppIcons.AppImage16(AppIcons.Enum.Properties);
_cmsi_Server_refresh.Image = AppIcons.AppImage16(AppIcons.Enum.Refresh);
_cmsi_Server_registerSQLServer.Image = AppIcons.AppImage16(AppIcons.Enum.AuditSQLServer);
_cmsi_Server_removeSQLServer.Image = AppIcons.AppImage16(AppIcons.Enum.Remove);
_cmsi_Server_collectDataSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.CollectDataSnapshot);
_cmsi_Server_configureDataCollection.Image = AppIcons.AppImage16(AppIcons.Enum.ConfigureAuditSettingsSM);
// load value lists for grid display
ValueList severityValueList = new ValueList();
severityValueList.Key = ValueListYesNo;
severityValueList.DisplayStyle = ValueListDisplayStyle.DisplayText;
_grid_Databases.DisplayLayout.ValueLists.Add(severityValueList);
ValueListItem listItem;
severityValueList.ValueListItems.Clear();
listItem = new ValueListItem(true, "Yes");
severityValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(false, "No");
severityValueList.ValueListItems.Add(listItem);
// Initialize the grids
initDataSources();
_grid_Servers.DisplayLayout.FilterDropDownButtonImage = AppIcons.AppImage16(AppIcons.Enum.GridFilter);
_grid_Servers.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
_grid_Servers.DisplayLayout.GroupByBox.Hidden = Utility.Constants.InitialState_GroupByBoxHidden;
_grid_Databases.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
_grid_Databases.DisplayLayout.GroupByBox.Hidden = Utility.Constants.InitialState_GroupByBoxHidden;
}
public View_ExploreSnapshots() : base()
{
InitializeComponent();
// Initialize base class fields.
this._label_Summary.Text = Utility.Constants.ViewSummary_ExploreSnapshots;
m_menuConfiguration = new Utility.MenuConfiguration();
}
public View_Main_ExplorePermissions()
{
InitializeComponent();
// pictureBox1.Image = imageList1.Images[0];
// Display text.
_lbl_Tag.Text = Utility.Constants.ViewTitle_Main_Explore;
_lbl_Intro.Text = Utility.Constants.ViewSummary_Main_Explore;
// Initialize menu configuration.
m_MenuConfiguration = new Utility.MenuConfiguration();
// Initialize and hook up all of the tasks
_commonTask1.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.AuditSQLServerCTSmall);
_commonTask1.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.AuditSQLServerHoverCT);
_commonTask1.TaskText = Utility.Constants.Task_Title_Register;
_commonTask1.TaskDescription = Utility.Constants.Task_Descr_Register;
_commonTask1.TaskHandler += new System.EventHandler(this.registerServer);
_commonTask2.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.UserPermissionsCTSmall);
_commonTask2.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.UserPermissionsHoverCT);
_commonTask2.TaskText = Utility.Constants.Task_Title_User;
_commonTask2.TaskDescription = Utility.Constants.Task_Descr_User;
_commonTask2.TaskHandler += new System.EventHandler(this.exploreUserPermissions);
_commonTask3.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.ReportsCTSmall);
_commonTask3.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.ReportsHoverCT);
_commonTask3.TaskText = Utility.Constants.Task_Title_Reports;
_commonTask3.TaskDescription = Utility.Constants.Task_Descr_Reports;
_commonTask3.TaskHandler += new System.EventHandler(this.selectReports);
_commonTask4.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.ConfigureAuditSettingsCTSmall);
_commonTask4.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.ConfigureAuditSettingsHoverCT);
_commonTask4.TaskText = Utility.Constants.Task_Title_Configure;
_commonTask4.TaskDescription = Utility.Constants.Task_Descr_Configure;
_commonTask4.TaskHandler += new System.EventHandler(this.configureDataCollection);
_commonTask5.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.ObjectExplorerCTSmall);
_commonTask5.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.ObjectExplorerHoverCT);
_commonTask5.TaskText = Utility.Constants.Task_Title_Object;
_commonTask5.TaskDescription = Utility.Constants.Task_Descr_Object;
_commonTask5.TaskHandler += new System.EventHandler(this.exploreObjectPermissions);
_commonTask6.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.SQLsecureLoginCTSmall);
_commonTask6.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.SQLsecureLoginCT);
_commonTask6.TaskText = Utility.Constants.Task_Title_NewUser;
_commonTask6.TaskDescription = Utility.Constants.Task_Descr_NewUser;
_commonTask6.TaskHandler += new System.EventHandler(this.AddNewUser);
//force to initial disable because there is no security handler at initial construction
_commonTask1.Enabled =
_commonTask2.Enabled =
_commonTask3.Enabled =
_commonTask4.Enabled =
_commonTask5.Enabled =
_commonTask6.Enabled = false;
}
public View_Main_ManageSQLsecure()
{
InitializeComponent();
// Initialize base class fields.
this._label_Summary.Text = Utility.Constants.ViewSummary_ManageSQLsecure;
m_menuConfiguration = new Utility.MenuConfiguration();
// Set the title.
Title = Utility.Constants.ViewTitle_ManageSQLsecure;
// Set the grid columns.
_dt_servers.Columns.Add(colIcon, typeof(Image));
_dt_servers.Columns.Add(colServer, typeof(String));
_dt_servers.Columns.Add(colStatus, typeof(String));
_dt_servers.Columns.Add(colLastCollectionTime, typeof(DateTime));
_dt_servers.Columns.Add(colCurrentCollectionTime, typeof(DateTime));
_dt_servers.Columns.Add(colJobStatus, typeof(String));
// Setup tasks.
_smallTask_Register.TaskText = Utility.Constants.Task_Title_Register;
_smallTask_Register.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.RegisterSQLserver);
_smallTask_Register.TaskHandler += new System.EventHandler(this.registerServer);
_smallTask_Import.TaskText = Utility.Constants.Task_Title_Import;
_smallTask_Import.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.ImportServers);
_smallTask_Import.TaskHandler += new System.EventHandler(this.ImportServers);
_smallTask_Collect.TaskText = Utility.Constants.Task_Title_CollectData;
_smallTask_Collect.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.Snapshot);
_smallTask_Collect.TaskHandler += new System.EventHandler(this.collectDataTask);
_smallTask_Collect.Visible = false;
_smallTask_Configure.TaskText = Utility.Constants.Task_Title_Configure;
_smallTask_Configure.TaskImage = AppIcons.AppImage32(AppIcons.Enum32.ConfigureAuditSettings);
_smallTask_Configure.TaskHandler += new System.EventHandler(this.configureServerTask);
_smallTask_Configure.Visible = false;
_cmsi_Server_exploreUserPermissions.Image = AppIcons.AppImage16(AppIcons.Enum.UserPermissions);
_cmsi_Server_exploreSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.ObjectExplorer);
_cmsi_Server_properties.Image = AppIcons.AppImage16(AppIcons.Enum.Properties);
_cmsi_Server_refresh.Image = AppIcons.AppImage16(AppIcons.Enum.Refresh);
_cmsi_Server_registerSQLServer.Image = AppIcons.AppImage16(AppIcons.Enum.AuditSQLServer);
_cmsi_Server_removeSQLServer.Image = AppIcons.AppImage16(AppIcons.Enum.Remove);
_cmsi_Server_collectDataSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.CollectDataSnapshot);
_cmsi_Server_configureDataCollection.Image = AppIcons.AppImage16(AppIcons.Enum.ConfigureAuditSettingsSM);
_grid.DisplayLayout.GroupByBox.Hidden = true;
_grid.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
_label_AuditedBar.BackColor = Color.Transparent;
_label_RemainingLicensesBar.BackColor = Color.Transparent;
_label_LicenseBar.BackColor = Color.Transparent;
}
public View_UserPermissions()
: base()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
_button_ShowPermissions.Enabled = checkProcessValid();
}
public BaseReport()
{
InitializeComponent();
// Initialize menu configuration.
m_menuConfiguration = new Utility.MenuConfiguration();
_toolStripButton_ShowSelections.Text = SelectionsHide;
_toolStripButton_ShowSelections.Image = global::Idera.SQLsecure.UI.Console.Properties.Resources.TaskHide_161;
//reports always start all expanded
_isExpanded = true;
//set default values for fields that may not be used on all reports
m_ServerId = 0;
m_ServerName = allserverstext;
m_usePolicy = true;
m_useBaseline = false;
}
public Snapshots() : base()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
m_dt_snapshots.Columns.Add(colIcon, typeof(Image));
m_dt_snapshots.Columns.Add(colId, typeof(int));
m_dt_snapshots.Columns.Add(colStartDate, typeof(DateTime));
m_dt_snapshots.Columns.Add(colStartTime, typeof(DateTime));
//m_dt_snapshots.Columns.Add(colAutomated, typeof(Image));
m_dt_snapshots.Columns.Add(colStatus, typeof(String));
m_dt_snapshots.Columns.Add(colComments, typeof(String));
m_dt_snapshots.Columns.Add(colBaseline, typeof(String));
m_dt_snapshots.Columns.Add(colBaselineComments, typeof(String));
m_dt_snapshots.Columns.Add(colObjects, typeof(int));
m_dt_snapshots.Columns.Add(colPermissions, typeof(int));
m_dt_snapshots.Columns.Add(colLogins, typeof(int));
m_dt_snapshots.Columns.Add(colWindowsGroupMembers, typeof(int));
m_dt_snapshots.Columns.Add(colSnapshot, typeof(object));
_toolStripButton_GridColumnChooser.Image = AppIcons.AppImage16(AppIcons.Enum.GridFieldChooser);
_toolStripButton_GridGroupBy.Image = AppIcons.AppImage16(AppIcons.Enum.GridGroupBy);
_toolStripButton_GridSave.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_toolStripButton_GridPrint.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
_cmsi_Snapshot_exploreUserPermissions.Image = AppIcons.AppImage16(AppIcons.Enum.UserPermissions);
_cmsi_Snapshot_exploreSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.ObjectExplorer);
_cmsi_Snapshot_baselineSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.MarkAsBaseline);
_cmsi_Snapshot_deleteSnapshot.Image = AppIcons.AppImage16(AppIcons.Enum.Remove);
//_cmsi_Snapshot_GroupByBox.Image - uses a checked value/image instead of app image
_cmsi_Snapshot_Save.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_cmsi_Snapshot_Print.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
_cmsi_Snapshot_refresh.Image = AppIcons.AppImage16(AppIcons.Enum.Refresh);
_cmsi_Snapshot_properties.Image = AppIcons.AppImage16(AppIcons.Enum.Properties);
_label_Snapshot.Text = HeaderSnapshots;
_grid.DisplayLayout.FilterDropDownButtonImage = AppIcons.AppImage16(AppIcons.Enum.GridFilter);
_grid.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
_grid.DisplayLayout.GroupByBox.Hidden = Utility.Constants.InitialState_GroupByBoxHidden;
}
public PolicySummary()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
// hook the toolbar labels to the grids so the heading can be used for printing
_grid_Servers.Tag = _label_Servers;
// hook the grids to the toolbars so they can be used for button processing
_headerStrip_Servers.Tag = _grid_Servers;
// Hookup all application images
_toolStripButton_ServersSave.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_toolStripButton_ServersPrint.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
initDataSource();
// Hide the focus rectangles on tabs and grids
_grid_Servers.DrawFilter = new HideFocusRectangleDrawFilter();
}
public View_Server()
: base()
{
InitializeComponent();
this._label_Summary.Text = Utility.Constants.ViewSummary_Server;
_snapshots.m_RefreshParentView += new UI.Console.Controls.Snapshots.RefreshViewHandlerDelegate(ShowRefresh);
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
// Configure tasks
_commonTask1.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.ConfigureAuditSettingsCTSmall);
_commonTask1.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.ConfigureAuditSettingsHoverCT);
_commonTask1.TaskText = Utility.Constants.Task_Title_Configure_Short;
_commonTask1.TaskDescription = Utility.Constants.Task_Descr_Configure;
_commonTask1.TaskHandler += new System.EventHandler(this.configureDataCollection);
_commonTask2.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.CollectDataCTSmall);
_commonTask2.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.CollectDataHoverCT);
_commonTask2.TaskText = Utility.Constants.Task_Title_Collect;
_commonTask2.TaskDescription = Utility.Constants.Task_Descr_Collect;
_commonTask2.TaskHandler += new System.EventHandler(this.takeSnapshot);
_commonTask3.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.UserPermissionsCTSmall);
_commonTask3.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.UserPermissionsHoverCT);
_commonTask3.TaskText = Utility.Constants.Task_Title_User_Short;
_commonTask3.TaskDescription = Utility.Constants.Task_Descr_User;
_commonTask3.TaskHandler += new System.EventHandler(this.exploreUserPermissions);
_commonTask4.TaskImage = AppIcons.AppImageCommonTaskSmall(AppIcons.EnumCommonTaskSmall.ObjectExplorerCTSmall);
_commonTask4.HoverTaskImage = AppIcons.AppImageCommonTask(AppIcons.EnumCommonTask.ObjectExplorerHoverCT);
_commonTask4.TaskText = Utility.Constants.Task_Title_Object_Short;
_commonTask4.TaskDescription = Utility.Constants.Task_Descr_Object;
_commonTask4.TaskHandler += new System.EventHandler(this.exploreObjectPermissions);
}
public PolicyUsers()
{
InitializeComponent();
// Initialize base class fields.
m_menuConfiguration = new Utility.MenuConfiguration();
_ultraTabControl_Users.ImageList = AppIcons.AppImageList16();
// hook the toolbar labels to the grids so the heading can be used for printing
_grid_Users.Tag = _label_Users;
// hook the grids to the toolbars so they can be used for button processing
_headerStrip_Users.Tag = _grid_Users;
// Hookup all application images
_toolStripButton_ColumnChooser.Image = AppIcons.AppImage16(AppIcons.Enum.GridFieldChooser);
_toolStripButton_GroupBy.Image = AppIcons.AppImage16(AppIcons.Enum.GridGroupBy);
_toolStripButton_Save.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_toolStripButton_Print.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
// set all grids to start in the same initial display mode
_grid_Users.DisplayLayout.GroupByBox.Hidden = Utility.Constants.InitialState_GroupByBoxHidden;
// load value lists for grid display
ValueList severityValueList = new ValueList();
severityValueList.Key = ValueListYesNo;
severityValueList.DisplayStyle = ValueListDisplayStyle.DisplayText;
_grid_Users.DisplayLayout.ValueLists.Add(severityValueList);
ValueListItem listItem;
severityValueList.ValueListItems.Clear();
listItem = new ValueListItem("Y", "Yes");
severityValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem("N", "No");
severityValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(string.Empty, "N/A");
severityValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(" ", "N/A");
severityValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(null, "N/A");
severityValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(DBNull.Value, "N/A");
severityValueList.ValueListItems.Add(listItem);
// Initialize the tabs
_ultraTabControl_Users.SuspendLayout();
_ultraTabControl_Users.Tabs.Clear();
//Start-SQLsecure 3.1 (Tushar)--Adding support for Azure SQL Database.
string[] userTypes;
if (m_serverInstance != null && m_serverInstance.ServerType == ServerType.AzureSQLDatabase)
{
userTypes = new string[] { tabKey_AzureSQLDatabase, tabKey_Sql, tabKey_All };
}
else if (m_serverInstance != null && m_serverInstance.ServerType != ServerType.AzureSQLDatabase)
{
userTypes = new string[] { tabKey_Windows, tabKey_Sql, tabKey_All };
}
else
{
userTypes = new string[] { tabKey_Windows, tabKey_AzureSQLDatabase, tabKey_Sql, tabKey_All };
}
foreach (string usertype in userTypes)
{
_ultraTabControl_Users.Tabs.Add(usertype, usertype);
}
//End-SQLsecure 3.1 (Tushar)--Adding support for Azure SQL Database.
_ultraTabControl_Users.ResumeLayout();
// Initialize the grids
initDataSource();
// Hide the focus rectangles on tabs and grids
_ultraTabControl_Users.DrawFilter = new HideFocusRectangleDrawFilter();
_grid_Users.DrawFilter = new HideFocusRectangleDrawFilter();
}
public View_SQLsecureActivity()
{
InitializeComponent();
// Initialize base class fields.
this._label_Summary.Text = Utility.Constants.ViewSummary_SQLsecureActivity;
m_menuConfiguration = new Utility.MenuConfiguration();
// Setup the crumb and regular title.
Title = Utility.Constants.ViewTitle_SQLsecureActivity;
// Setup the grid columns.
_dt_activity.Columns.Add(colActivityType, typeof(String));
_dt_activity.Columns.Add(colEventDate, typeof(DateTime));
_dt_activity.Columns.Add(colEventTime, typeof(DateTime));
//_dt_activity.Columns.Add(colApplicationSource, typeof(String));
_dt_activity.Columns.Add(colConnectionName, typeof(String));
_dt_activity.Columns.Add(colServerLogin, typeof(String));
_dt_activity.Columns.Add(colCategory, typeof(String));
_dt_activity.Columns.Add(colEventCode, typeof(String));
_dt_activity.Columns.Add(colDescription, typeof(String));
// hook the toolbar labels to the grids so the heading can be used for printing
_grid.Tag = _label_Activity;
// hook the grids to the toolbars so they can be used for button processing
_headerStrip_Activity.Tag = _grid;
// Hookup all application images
_toolStripButton_ActivityColumnChooser.Image = AppIcons.AppImage16(AppIcons.Enum.GridFieldChooser);
_toolStripButton_ActivityGroupBy.Image = AppIcons.AppImage16(AppIcons.Enum.GridGroupBy);
_toolStripButton_ActivitySave.Image = AppIcons.AppImage16(AppIcons.Enum.GridSaveToExcel);
_toolStripButton_ActivityPrint.Image = AppIcons.AppImage16(AppIcons.Enum.Print);
// set all grids to start in the same initial display mode
_grid.DisplayLayout.GroupByBox.Hidden = Utility.Constants.InitialState_GroupByBoxHidden;
// load value lists for grid display
ValueList statusValueList = new ValueList();
statusValueList.Key = ValueListStatus;
statusValueList.DisplayStyle = ValueListDisplayStyle.DisplayTextAndPicture;
_grid.DisplayLayout.ValueLists.Add(statusValueList);
ValueListItem listItem;
statusValueList.ValueListItems.Clear();
listItem = new ValueListItem(Utility.Activity.TypeInfo, Utility.Activity.TypeInfoText);
listItem.Appearance.Image = AppIcons.AppImage16(AppIcons.Enum.ActivityInfo);
statusValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(Utility.Activity.TypeWarning, Utility.Activity.TypeWarningText);
listItem.Appearance.Image = AppIcons.AppImage16(AppIcons.Enum.ActivityWarn);
statusValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(Utility.Activity.TypeError, Utility.Activity.TypeErrorText);
listItem.Appearance.Image = AppIcons.AppImage16(AppIcons.Enum.ActivityError);
statusValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(Utility.Activity.TypeAuditSuccess, Utility.Activity.TypeAuditSuccessText);
listItem.Appearance.Image = AppIcons.AppImage16(AppIcons.Enum.ActivitySuccessAudit);
statusValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(Utility.Activity.TypeAuditFailure, Utility.Activity.TypeAuditFailureText);
listItem.Appearance.Image = AppIcons.AppImage16(AppIcons.Enum.ActivityFailureAudit);
statusValueList.ValueListItems.Add(listItem);
listItem = new ValueListItem(DBNull.Value, Utility.Activity.TypeUnknownText);
listItem.Appearance.Image = AppIcons.AppImage16(AppIcons.Enum.Unknown);
statusValueList.ValueListItems.Add(listItem);
// hide the focus rectangle
_grid.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
_cmsi_refresh.Image = AppIcons.AppImage16(AppIcons.Enum.Refresh);
}
public View_Main_Reports()
{
InitializeComponent();
// Initialize base class fields.
_label_Summary.Text = Utility.Constants.ViewSummary_Main_Reports;
m_menuConfiguration = new Utility.MenuConfiguration();
// General Reports
commonTask_GeneralReport_1.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_AuditedSQLServers_32;
commonTask_GeneralReport_1.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_AuditedSQLServers_48;
commonTask_GeneralReport_1.TaskText = Utility.Constants.ReportTitle_AuditedServers;
commonTask_GeneralReport_1.TaskDescription = Utility.Constants.ReportSummary_AuditedServers;
commonTask_GeneralReport_1.TaskHandler += new System.EventHandler(showAuditedServers);
commonTask_GeneralReport_2.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_CrossServerLoginCheck_32;
commonTask_GeneralReport_2.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_CrossServerLoginCheck_48;
commonTask_GeneralReport_2.TaskText = Utility.Constants.ReportTitle_CrossServerLoginCheck;
commonTask_GeneralReport_2.TaskDescription = Utility.Constants.ReportSummary_CrossServerLoginCheck;
commonTask_GeneralReport_2.TaskHandler += new System.EventHandler(showServerAccess);
commonTask_GeneralReport_3.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DataCollectionFilters_32;
commonTask_GeneralReport_3.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DataCollectionFilters_48;
commonTask_GeneralReport_3.TaskText = Utility.Constants.ReportTitle_Filters;
commonTask_GeneralReport_3.TaskDescription = Utility.Constants.ReportSummary_Filters;
commonTask_GeneralReport_3.TaskHandler += new System.EventHandler(showFilters);
commonTask_GeneralReport_4.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_ActivityHistory_32;
commonTask_GeneralReport_4.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_ActivityHistory_48;
commonTask_GeneralReport_4.TaskText = Utility.Constants.ReportTitle_ActivityHistory;
commonTask_GeneralReport_4.TaskDescription = Utility.Constants.ReportSummary_ActivityHistory;
commonTask_GeneralReport_4.TaskHandler += new System.EventHandler(showActivityHistory);
commonTask_GeneralReport_5.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SQLsecureUsers_32;
commonTask_GeneralReport_5.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SQLsecureUsers_48;
commonTask_GeneralReport_5.TaskText = Utility.Constants.ReportTitle_Users;
commonTask_GeneralReport_5.TaskDescription = Utility.Constants.ReportSummary_Users;
commonTask_GeneralReport_5.TaskHandler += new System.EventHandler(showUsers);
commonTask_GeneralReport_6.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_RiskAssessment_32;
commonTask_GeneralReport_6.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_RiskAssessment_48;
commonTask_GeneralReport_6.TaskText = Utility.Constants.ReportTitle_RiskAssessment;
commonTask_GeneralReport_6.TaskDescription = Utility.Constants.ReportSummary_RiskAssessment;
commonTask_GeneralReport_6.TaskHandler += new System.EventHandler(showRiskAssessment);
// Entitlement Reports
commonTask_EntitlementReport_1.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SuspectWindowsAccounts_32;
commonTask_EntitlementReport_1.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SuspectWindowsAccounts_48;
commonTask_EntitlementReport_1.TaskText = Utility.Constants.ReportTitle_SuspectWindowsAccounts;
commonTask_EntitlementReport_1.TaskDescription = Utility.Constants.ReportSummary_SuspectWindowsAccounts;
commonTask_EntitlementReport_1.TaskHandler += new System.EventHandler(showOrphanedLogins);
commonTask_EntitlementReport_7.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SuspectSqlLogins_32;
commonTask_EntitlementReport_7.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SuspectSqlLogins_48;
commonTask_EntitlementReport_7.TaskText = Utility.Constants.ReportTitle_SuspectSqlLogins;
commonTask_EntitlementReport_7.TaskDescription = Utility.Constants.ReportSummary_SuspectSqlLogins;
commonTask_EntitlementReport_7.TaskHandler += new System.EventHandler(showSqlLogins);
commonTask_EntitlementReport_2.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_ServerLoginsAndUserMappings_32;
commonTask_EntitlementReport_2.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_ServerLoginsAndUserMappings_48;
commonTask_EntitlementReport_2.TaskText = Utility.Constants.ReportTitle_ServerLoginsAndUserMappings;
commonTask_EntitlementReport_2.TaskDescription = Utility.Constants.ReportSummary_ServerLoginsAndUserMappings;
commonTask_EntitlementReport_2.TaskHandler += new System.EventHandler(showServerDatabaseUsers);
commonTask_EntitlementReport_3.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_UserPermissions_32;
commonTask_EntitlementReport_3.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_UserPermissions_48;
commonTask_EntitlementReport_3.TaskText = Utility.Constants.ReportTitle_UsersPermissions;
commonTask_EntitlementReport_3.TaskDescription = Utility.Constants.ReportSummary_UsersPermissions;
commonTask_EntitlementReport_3.TaskHandler += new System.EventHandler(showUserPermissions);
commonTask_EntitlementReport_4.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_AllUserPermissions_32;
commonTask_EntitlementReport_4.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_AllUserPermissions_48;
commonTask_EntitlementReport_4.TaskText = Utility.Constants.ReportTitle_AllObjectsWithPermissions;
commonTask_EntitlementReport_4.TaskDescription = Utility.Constants.ReportSummary_AllObjectsWithPermissions;
commonTask_EntitlementReport_4.TaskHandler += new System.EventHandler(showAllObjectsWithPermissions);
commonTask_EntitlementReport_5.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_ServerRoles_32;
commonTask_EntitlementReport_5.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_ServerRoles_48;
commonTask_EntitlementReport_5.TaskText = Utility.Constants.ReportTitle_ServerRoles;
commonTask_EntitlementReport_5.TaskDescription = Utility.Constants.ReportSummary_ServerRoles;
commonTask_EntitlementReport_5.TaskHandler += new System.EventHandler(showServerRoles);
commonTask_EntitlementReport_6.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DatabaseRoles_32;
commonTask_EntitlementReport_6.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DatabaseRoles_48;
commonTask_EntitlementReport_6.TaskText = Utility.Constants.ReportTitle_DatabaseRoles;
commonTask_EntitlementReport_6.TaskDescription = Utility.Constants.ReportSummary_DatabaseRoles;
commonTask_EntitlementReport_6.TaskHandler += new System.EventHandler(showDatabaseRoles);
// Vulnerability Reports
commonTask_VulnerabilityReport_1.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_MixedModeAuthentication_32;
commonTask_VulnerabilityReport_1.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_MixedModeAuthentication_48;
commonTask_VulnerabilityReport_1.TaskText = Utility.Constants.ReportTitle_MixedModeAuthentication;
commonTask_VulnerabilityReport_1.TaskDescription = Utility.Constants.ReportSummary_MixedModeAuthentication;
commonTask_VulnerabilityReport_1.TaskHandler += new System.EventHandler(showAuthentication);
commonTask_VulnerabilityReport_2.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_GuestEnabledDatabases_32;
commonTask_VulnerabilityReport_2.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_GuestEnabledDatabases_48;
commonTask_VulnerabilityReport_2.TaskText = Utility.Constants.ReportTitle_GuestEnabledDatabases;
commonTask_VulnerabilityReport_2.TaskDescription = Utility.Constants.ReportSummary_GuestEnabledDatabases;
commonTask_VulnerabilityReport_2.TaskHandler += new System.EventHandler(showGuestEnabledDatabases);
commonTask_VulnerabilityReport_3.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_OSVunerabilityviaXSPs_32;
commonTask_VulnerabilityReport_3.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_OSVunerabilityviaXSPs_48;
commonTask_VulnerabilityReport_3.TaskText = Utility.Constants.ReportTitle_OSVulnerability;
commonTask_VulnerabilityReport_3.TaskDescription = Utility.Constants.ReportSummary_OSVulnerability;
commonTask_VulnerabilityReport_3.TaskHandler += new System.EventHandler(showSPsWithGuestAccess);
commonTask_VulnerabilityReport_4.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_VunerableFixedRoles_32;
commonTask_VulnerabilityReport_4.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_VunerableFixedRoles_48;
commonTask_VulnerabilityReport_4.TaskText = Utility.Constants.ReportTitle_VulnerableFixedRoles;
commonTask_VulnerabilityReport_4.TaskDescription = Utility.Constants.ReportSummary_VulnerableFixedRoles;
commonTask_VulnerabilityReport_4.TaskHandler += new System.EventHandler(showFixedRolesAssignedToPublic);
commonTask_VulnerabilityReport_5.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SystemAdministratorVunerability_32;
commonTask_VulnerabilityReport_5.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SystemAdministratorVunerability_48;
commonTask_VulnerabilityReport_5.TaskText = Utility.Constants.ReportTitle_SystemAdministratorVulnerability;
commonTask_VulnerabilityReport_5.TaskDescription = Utility.Constants.ReportSummary_SystemAdministratorVulnerability;
commonTask_VulnerabilityReport_5.TaskHandler += new System.EventHandler(showBuiltAdmin);
commonTask_VulnerabilityReport_6.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DangerousWindowsGroups_32a;
commonTask_VulnerabilityReport_6.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DangerousWindowsGroups_48a;
commonTask_VulnerabilityReport_6.TaskText = Utility.Constants.ReportTitle_ServersWithDangerousGroups;
commonTask_VulnerabilityReport_6.TaskDescription = Utility.Constants.ReportSummary_ServersWithDangerousGroups;
commonTask_VulnerabilityReport_6.TaskHandler += new System.EventHandler(showEveryoneGroupAccess);
commonTask_VulnerabilityReport_7.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DatabaseChainingEnabled_32;
commonTask_VulnerabilityReport_7.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_DatabaseChainingEnabled_48;
commonTask_VulnerabilityReport_7.TaskText = Utility.Constants.ReportTitle_DatabaseChaining;
commonTask_VulnerabilityReport_7.TaskDescription = Utility.Constants.ReportSummary_DatabaseChaining;
commonTask_VulnerabilityReport_7.TaskHandler += new System.EventHandler(showDatabaseChaining);
commonTask_VulnerabilityReport_8.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_MailVunerability_32;
commonTask_VulnerabilityReport_8.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_MailVunerability_48;
commonTask_VulnerabilityReport_8.TaskText = Utility.Constants.ReportTitle_MailVulnerability;
commonTask_VulnerabilityReport_8.TaskDescription = Utility.Constants.ReportSummary_MailVulnerability;
commonTask_VulnerabilityReport_8.TaskHandler += new System.EventHandler(showMailVulnerability);
commonTask_VulnerabilityReport_9.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_VulnerableLogins_32;
commonTask_VulnerabilityReport_9.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_VulnerableLogins_48;
commonTask_VulnerabilityReport_9.TaskText = Utility.Constants.ReportTitle_LoginVulnerability;
commonTask_VulnerabilityReport_9.TaskDescription = Utility.Constants.ReportSummary_LoginVulnerability;
commonTask_VulnerabilityReport_9.TaskHandler += new System.EventHandler(showLoginVulnerability);
// Comparison Reports
commonTask_ComparisonReport_1.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_AssessmentCompare_32;
commonTask_ComparisonReport_1.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_AssessmentCompare_48;
commonTask_ComparisonReport_1.TaskText = Utility.Constants.ReportTitle_CompareAssessments;
commonTask_ComparisonReport_1.TaskDescription = Utility.Constants.ReportSummary_CompareAssessments;
commonTask_ComparisonReport_1.TaskHandler += new System.EventHandler(showCompareAssessmentsReport);
commonTask_ComparisonReport_2.TaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SnapshotCompare_32;
commonTask_ComparisonReport_2.HoverTaskImage = global::Idera.SQLsecure.UI.Console.Properties.Resources.Report_SnapshotCompare_48;
commonTask_ComparisonReport_2.TaskText = Utility.Constants.ReportTitle_CompareSnapshots;
commonTask_ComparisonReport_2.TaskDescription = Utility.Constants.ReportSummary_CompareSnapshots;
commonTask_ComparisonReport_2.TaskHandler += new System.EventHandler(showCompareSnapshotsReport);
//This code fails in design mode and renders the form unviewable at times
try
{
// Set the security for the tasks
commonTask_GeneralReport_1.Enabled =
commonTask_GeneralReport_2.Enabled =
commonTask_GeneralReport_3.Enabled =
commonTask_GeneralReport_4.Enabled =
commonTask_GeneralReport_5.Enabled =
commonTask_EntitlementReport_1.Enabled =
commonTask_EntitlementReport_2.Enabled =
commonTask_EntitlementReport_3.Enabled =
commonTask_EntitlementReport_4.Enabled =
commonTask_EntitlementReport_5.Enabled =
commonTask_EntitlementReport_6.Enabled =
commonTask_VulnerabilityReport_1.Enabled =
commonTask_VulnerabilityReport_2.Enabled =
commonTask_VulnerabilityReport_3.Enabled =
commonTask_VulnerabilityReport_4.Enabled =
commonTask_VulnerabilityReport_5.Enabled =
commonTask_VulnerabilityReport_6.Enabled =
commonTask_VulnerabilityReport_7.Enabled =
commonTask_VulnerabilityReport_8.Enabled =
commonTask_VulnerabilityReport_9.Enabled =
commonTask_ComparisonReport_1.Enabled =
commonTask_ComparisonReport_2.Enabled = Program.gController.isViewer;
}
catch { }
//Setup reporting services section
_label_ReportingServicesSummary.Text = Utility.Constants.ReportSummary_ReportingServices;
ultraTabControl1.DrawFilter = new Utility.HideFocusRectangleDrawFilter();
}
