skip to Main Content

I have one question with Appliance IBM Guardium. I create Security Policy with Category (Audit, Access, Activity) and Rules include Log full details. Then I create Dashboard to show information about (Client Ip, DB Protocol, DB User name, Server IP, timestamp, SQL and Full SQL). It shows all rows, but Full SQL is empty.
The question is – where must I configure in the appliance to show the Full SQL parameter in Dashboard Report or it is something else?

enter image description here

  • Database: Informix 11.7.
  • Guardium: 11.4v
  • CentOS: 7v

2

Answers


  1. You must create your report based on Full SQL entity.
    If you created your report based on SQL entity, it won’t display Full SQL values.

    Hope it helps.

    FULL SQL Report

    Login or Signup to reply.
  2. Full sql is collected depending on your policy rules and actions.
    To have full sql data you need a rule with action log full details to fire
    Be careful when defining such rules as full sql might fill up you Guardium collector, make sure you log only data that you need

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search