Log360 permette di collezionare molte informazioni su applicazioni come Microsoft SQL Server dove è possibile fare principalmente almeno due tipologie di monitoraggio. Server SQL e database.
Qui riporto ciò che si può fare sui database. I report generabili sono davvero molti e ne riportiamo alcuni di seguito.
Database backup report | Database restoration report | Transaction log backup report | Admin authority changes report | Permission changes report | Owner Changes report | Created server roles | Dropped server roles | Altered server roles | Created Server Audits | Dropped Server Audits | Altered server audits | Created Server Audit Specifications | Dropped Server Audit Specifications | Altered Server Audit Specifications | Created Database Audit Specifications | Dropped Database Audit Specifications | Altered Database Audit Specifications | Changed Audit Sessions | Shutdown and Failure Audits | Trace Audit C2 On | Trace Audit C2 Off | Started Trace Audits | Stopped Trace Audits | Server Startups | Server shutdowns | Logons | Failure logons | Logout Accounts | Top logons based on user | Top logons based on remote hosts | Top failure logons based on users | Top failure logons based on remote hosts | Logons Trend | Failed Logons Trend | Event Trend report | Most Used Tables | Table Update Report | Index Information report | Server Information Report | Waits Information Report | Blocked Processes Report | Schema Change History | Object Change History | Connected Applications Report | Last Backup of Database | Last DBCC Activity
Qui riporto ciò che si può fare sul server SQL. Con i report generabili.
• Privileged user activity analysis: Detect unauthorized access with successful and failed logon reports, keep track of permission and authority changes, identify the most frequent accesses, and more.
• SQL Server object change tracking: Track user activity with reports on creation, deletion, and modification of several server-level objects, such as server roles, server audit objects, and server audit specification objects.
• SQL Server activity monitoring: Monitor server activity such as server startups and shutdowns, backup and recovery, SQL trace activity, and more.
• Server event trend analysis: Analyze SQL Server activity over time.