Self-Monitoring

 

Overview

The Guardium solution combines an appliance-based solution with light-weight software probes that are installed on database servers combined with a application code base that allows for a highly comprehensive and customizable set of policies to control and secure corporate databases. These combined mechanisms allows the Guardium solution to see not only traditional client server and web based application communications, but also threats that might originate on database servers--enabling Guardium to take action on all unauthorized access attempts. The Guardium solution is able to secure and limit attacks to a database through monitoring of all database access points (local and remote). Because the Guardium architecture is both network-based and host-based through appliances and software probes respectively--continually monitoring network and servers for database messages, the Guardium solution can be deployed in a variety of operational modes to provide flexibility and complete coverage for all database traffic. With such complete coverage, it follows that Guardium’s solution must take advantage of self-monitoring.

In order to comply with the strict requirements set forth by Guardium to self-monitor its own solution, there exists a four pronged approach to ensuring the Guardium solution is available, functioning properly, has not been tampered with, and alerts users of problems.

 

Components Monitored

System

  Disk space  (%full)

  Report: Select Guardium Monitor > Current Status Monitor, or

             See Predefined admin Reports for report : Current Status Monitor  for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  CPU Load

  Report: Select Guardium Monitor > Current Status Monitor, or

             Select Guardium Monitor > Buffer Usage Monitor, or

             See Predefined admin Reports for report : Current Status Monitor  for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  Uptime & Reboots

  Report: Select Guardium Monitor > Current Status Monitor, or

             Select Guardium Monitor > Buffer Usage Monitor, or

             See Predefined admin Reports for report : Current Status Monitor  for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Memory Usage

  Report: Select Guardium Monitor > Current Status Monitor, or

             Select Guardium Monitor > Buffer Usage Monitor, or

             See Predefined admin Reports for report : Current Status Monitor  for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Security Activity Audit Trail (define ssh users)

  Report:

  Failed Logins

  Report: See Predefined admin Reports for report : Logins to Guardium for more information, or

             See Predefined admin Reports for report : Admin User Logins for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Guardium Login domain and Guardium Users Login entity to create alerts

  Self-Monitoring: Is in use

 

Monitoring Engine (snif)

  Status: up/down/stuck/overloaded

  Report: Select Guardium Monitor > Buffer Usage Monitor

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  CPU Usage

  Report: Select Guardium Monitor > Buffer Usage Monitor, or

             See Predefined admin Reports for report : CPU Usage for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Memory Usage

  Report: Select Guardium Monitor > Buffer Usage Monitor

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  Identify bottle-necks   

  Report: Select Guardium Monitor > Buffer Usage Monitor

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Overload & delays (Queues)

  Report: Select Guardium Monitor > Buffer Usage Monitor

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  Lost requests

  Report: See Daily Monitor > Dropped Requests, or

             See Predefined admin Reports for report : Dropped Requests for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Exceptions domain and Exceptions entity to create alerts

  Self-Monitoring: Is in use

 

Monitored Data

  Database types currently monitored

  Report: See Daily Monitor > Databases by Type, or

             See Predefined admin Reports for report : Databases by Type for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Auto-discovery domain and Host Configuration entity to create alerts

  Change in data patterns

  Report: See Daily Monitor > Values Changed, or

             See Predefined admin Reports for report : Values Changed for more information             

  Alert: See Viewing an Audit Process Definition for alert: Data Source Changes - alert on any data source changes

  Packets rates

  Report: Select Guardium Monitor > Buffer Usage Monitor

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Requests rates

  Report: Select Guardium Monitor > Buffer Usage Monitor, or

             See Predefined admin Reports for report : Request Rate for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Ignored Data (due to selective-audit rules)

  Report: Select Guardium Monitor > Buffer Usage Monitor

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

 

Web Service (tomcat) & Applications Status

  Service Status: up/down

  Self-Monitoring: Is in use

  Scheduled Jobs Exceptions

  Report: Select Guardium Monitor > Scheduled Jobs Exceptions, or

             See Predefined admin Reports for report : Scheduled Job Exceptions for more information, or

             See Predefined admin Reports for report : Scheduled Jobs for more information, or

             See Predefined admin Reports for report : Cls/Asmt Job Queue for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Exceptions domain and Exception Type entity to create alerts

  Audit processes status

  Report: Select Guardium Monitor > Number of Active Audit Processes, or

             See Predefined admin Reports for report : Number of Active Audit Processes for more information, or

             See Predefined admin Reports for report : Outstanding Audit Process Reviews for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Audit Process domain and Audit Process entity to create alerts

  Inspection Engine Changes

  Report: See Tap Monitor > S-Tap Configuration Change History

  Alert: See Viewing an Audit Process Definition for alert: Inspection Engines and STAP - alert on any activity related to inspection engine and stap configuration

  Inspection Engine

  Report: See S-TAP Reports

  Policy Changes & Policy Installations

  Alert: See Viewing an Audit Process Definition for alert: Policy Changes Alert - alert once a day on policy related changes

  Currently installed policy

  Report: Select Administration Console > Policy Installation

  Alert: You can use the Queries and Correlation Alerts, utilizing the Installed Policy domain and Installed Policy entity to create alerts

 

Guardium Users Activity

  Login/Logout

  Report: Select Guardium Monitor > Logins to Guardium, or

             See Predefined admin Reports for report : Logins to Guardium for more information, or

             See Predefined admin Reports for report : Admin User Logins for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Guardium Login domain and SQL Guard Login entity to create alerts

  Failed Logins

  Report: Select Guardium Monitor > Logins to Guardium, or

             See Predefined admin Reports for report : Logins to Guardium for more information, or

             See Predefined admin Reports for report : Admin User Logins for more information

  Alert: See Viewing an Audit Process Definition for alert: Failed Logins To Guardium - alert if have more than 5 failed logins in the last 11 minutes, or

           Select Tools > Report Building > drop-down Report Title: Guardium Logins, See Reports for additional information

  User Activity Audit Trail

  Report: Select Guardium Monitor > User Activity Audit Trail, or

             See Predefined admin Reports for report : User Activity Audit Trail for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Guardium Activity domain and SQL Guard User Activity Audit entity to create alerts

  Creation/Deletion of Users/Roles

  Report: Select Guardium Monitor > User Activity Audit Trail, or

             See Predefined admin Reports for report : User Activity Audit Trail for more information

  Alert: See Viewing an Audit Process Definition for alert: Guardium - Add/Remove Users - alert on any Addition or Removal of Guardium User

  LDAP Configuration Changes

  Alert: See Viewing an Audit Process Definition for alert: Guardium - Credential Activity - alert on any Credential changes including LDAP configuration Changes  

  Permissions monitoring

  Report: Select Guardium Monitor > Guardium Users, or

             Select Guardium Monitor > Guardium Roles, or

             Select Guardium Monitor > Guardium Applications, or

             See Predefined admin Reports for report : Guardium Group Details for more information, or

             See Predefined admin Reports for report : Guardium Users for more information, or

             See Predefined admin Reports for report : Guardium Roles for more information

  Alert: You can use the Queries and Correlation Alerts, utilizing the Application domain and Application Data entity to create alerts

 

Aggregation / Archive

  Activity Log

  Report: See Reporting on Aggregation and Archiving Activity

  Alert: See Viewing an Audit Process Definition for alert: Aggregation/Archive Errors - alert on any aggregation/archive error, runs once a day

  Resolution -- Success/failure

  Report: See Reporting on Aggregation and Archiving Activity

  Alert: See Viewing an Audit Process Definition for alert: Aggregation/Archive Errors - alert on any aggregation/archive error, runs once a day

 

Internal Database (TURBINE)

  Status: up/down

  Report: You can use Reports, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to build a report

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  Disk Space (%Full)

  Report: You can use Reports, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to build a report

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Self-Monitoring: Is in use

  CPU Usage

  Report: You can use Reports, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to build a report

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Memory Usage

  Report: You can use Reports, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to build a report

  Alert: You can use the Queries and Correlation Alerts, utilizing the Sniffer Buffer domain and Sniffer Buffer Usage entity to create alerts

  Currently running queries

  Report: You can use Reports, utilizing the Access domain and Full SQL entity to build a report

  Queries Performance

  Report: You can use Reports, utilizing the Access domain and Full SQL entity to build a report

 

S-Tap

  Status: up/down/synchronizing

  Report: See S-TAP Reports, or

             See Predefined admin Reports for report : STAP Status Monitor for more information

  Alert: See Viewing an Audit Process Definition for alert: Inactive STAPs Since - alert if have inactive staps  

  Database types monitored

  Report: See S-TAP Reports

  Alert: See Viewing an Audit Process Definition for alert: Inspection Engines and STAP - alert on any activity related to inspection engine and stap configuration

  Changes in data patterns from stap

  Report: See S-TAP Reports

  Alert: See Viewing an Audit Process Definition for alert: Inspection Engines and STAP - alert on any activity related to inspection engine and stap configuration

  STap Config Changes

  Report: See S-TAP Reports

  Alert: See Viewing an Audit Process Definition for alert: Inspection Engines and STAP - alert on any activity related to inspection engine and stap configuration

 

CAS

  Status: up/down

  Report: See CAS Status

  Template changes

  Report: See Tap Monitor > CAS > Changes

  Alert: See Viewing an Audit Process Definition for alert: CAS Template Changes - alert on any CAS Tempalce configuration

  CAS Configuration Changes

  Report: See Tap Monitor > CAS > Changes

  Alert: See Viewing an Audit Process Definition for alert: CAS Instance Config Changes - alert on any CAS Instance configuration

  CAS Event

  Report: You can use Reports, utilizing the CAS Host History domain and Host Event entity to build a report

 

External Data Connectors

  Configuration Changes

  Report: See External Data Connector

 

Viewing an Audit Process Definition

After logging into the Guardium interface as the admin user:

  1. Click on the Tools tab

  2. Click on the Config & Control tab

  3. Click on the Audit Process Builder link in the left hand column menu to bring up the Audit Process Finder panel

  4. From the drop-down Process Selection List, select Appliance Monitoring

  5. Use the radio buttons to select show all, active only, or inactive only processes for Appliance Monitoring

  6. Click on the Modify button to bring up the Audit Process Definition panel

  7. See Compliance Workflow Automation for more information