All Products
Search

This Product

    CloudMonitor:Hologres use management

    Document Center

    CloudMonitor:Hologres use management

    Last Updated:Oct 16, 2024

    This topic describes how to manage Hologres instances and use SQL audit logs of Hologres instances to show the analysis results and visual reports for the SQL audit logs of Hologres instances.

    Procedure

    1. Log on to the CloudMonitor console.

    2. In the left-side navigation pane, choose CloudLens > CloudLens for Hologres. The CloudLens for Hologres page appears.

      Data Import Management

      1. In the left-side navigation pane, click Data Import Management and then click the Hologres Instance tab.

      2. On the Hologres Instance tab, view the basic information including Instances, Data Collection Instance, and Region. In the Access Overview section, the Hologres instances are summarized to facilitate resource auditing and log collection management.

      3. In the instance list in the lower part, view the details in the Production Instance ID/Name, Region, Instance Type, Version, and SQL Audit Log columns.

      4. Click the Destination Logstores tab. On the Destination Logstores tab, view the following information about the destination Logstores for Hologres: Destination, Region, Data Retention Period (Days), Collected Instance, and Type.

      Query and Analysis

      1. In the left-side navigation pane, click Query and Analysis > SQL Audit Log

      2. Select the ID of the Hologres instance and then query and analyze the SQL audit logs.

        Note

        For more information about how to query and analyze logs, see Query and analyze logs.

      Report Center

      1. In the left-side navigation pane, click Report Center and then click the SQL Audit Overview tab.

      2. Select the ID of the Hologres instance. On the right side of the page, set the time for SQL audit log analysis. You can also manually refresh and reset the time. You can click Save As to save the log. The report is displayed in full-screen mode on the page.

      3. Set multiple conditions to filter audit logs and show data reports, such as Instance ID, Database, Account, Type, Client IP, and Status.

      4. Analyze the SQL audit logs and collect statistics. The statistics are displayed in charts.

        • Statistics section: displays metrics such as Number of Users, Number of Audit Logs, Number of Clients, Execution Failure, and Number of Operated Databases.

        • Top data trend analysis section: displays charts for metrics such as Top 5 Users, Top 5 Executed Commands, and Top 5 Clients.

        • Quantity trend analysis section: displays charts for metrics such as Trend of Log Quantity and Trend of Logged-on Clients.

        • Audit Log Details: displays information such as Instance ID, Username, Authentication Information, Client IP, Collection Time, Database, Type, Status, Query, Start Time, End Time, and Duration.