Welcome to IDERA Virtual Education for SQL Compliance Manager. Today I am going to show you how you can go in and check the communication between the different components of SQL Compliance Manager. First off, we bring up the console. And for whatever instance that we have questions about for the communication, we should see the current server status on the main screen. My instance name IDERA prod VM is displaying an okay status. It also shows the recent heartbeat was just a couple of moments ago. So that has one way we can check the status. We can also see on the right-hand side that there has been some recent event activity. That can also be an indicator of good communication. But to very specifically check the communication, we will go to the administration section on the left-hand side. So once we go to the administration section on the upper left-hand side of the screen, we will be able to see different administrative functions like to create event filters or alert rules or to review change activity or create logins. There is also a section for registered SQL Servers where you can add new instances to be audited. When you select that section on the right-hand side, you will see a list of the current instances that have been added for auditing. One indicator of good communication will be the green check next to each instance. Other indicators of good communication will be the status check. This will display an OK status if we have good communication. Or it will also display any messages around any problem activity that would be causing communication problems. We can also check the audit status and ensure that the auditing is enabled. And also review the last agent contact. There is also the option to right-click the instance and check the agent status. Which will cause the collection service to reach out to the remote audited instance. And communicate with the agent to ensure that it is, in fact, active. We can also quickly review the agent properties to see when the last heartbeat was received. The heartbeat interval time period. The last agent update. And you can also go to the trace options to see how frequently we can expect that the event data would be processed. My collection interval is every two minutes. And this is easily configurable through this. These settings, as well. You also have the ability to go into the changelog or activity log to see what has happened recently, either changing audit settings remotely to an instance or the recent activity with agents starting or stopping or collection service resolution communication. All of that will be logged here as well. And you should see the recent activities displayed on this screen. Last but not least, you can also reach out directly to an instance and force an audit collection by right-clicking the instance and selecting the option to collect audit data. This will communicate with the agent and tell the agent to go ahead and pull together the trace data, compress it, and send it to the collection service immediately. A quick refresh will display the most recent event data on the right-hand side. And then, from that standpoint, you can drill down into the underlying audit events. And do your additional filtering on that event data. If you want to so. This concludes the IDERA Virtual Education for SQL Compliance Manager communication. Thanks for watching and have a nice day.

Topics : Database Compliance,Database Security,

Products : SQL Compliance Manager,

How to Check the Communication between Different Components in SQL Compliance Manager

SQL Compliance Manager is a comprehensive auditing solution that uses policy-based algorithms to track changes to your SQL Server objects and data. SQL Compliance Manager gives you detailed visibility to determine who did “what”, “when”, “where”, and “how”, whether the event is initiated by privileged users or hackers.

SQL Compliance Manager also helps ensure compliance with regulatory and data security requirements such as SOX, PCI, GLBA, HIPAA(HITECH), and Basel l and II. SQL Compliance Manager goes beyond traditional auditing approaches by providing real-time monitoring, alerting, and auditing of all data access, selects, updates, schema modifications and permission changes to SQL Server databases. Learn More →

Contact IDERA: