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?
- Database: Informix 11.7.
- Guardium: 11.4v
- CentOS: 7v
2
Answers
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
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