IBM Support

"Value Removed" appearing in Full SQL field in a report on a Guardium Aggregator

Question & Answer


Question

Why is the string "Value Removed" appearing in Full SQL field in a Report on a Guardium Aggregator?

Answer


The string "Value Removed" appears in the Full SQL field when data is exported and "Export Values" flag is not ticked. This is expected behaviour.

FULL SQL Report Showing "Value Removed" string in an Aggregator:


Data Export Configuration with "Export Values" unchecked


In order to see the values in the Aggregator the "Export Values" option needs to be checked in the Data Export configuration on the Collectors . All exports made from that point on will contain the Values and will get imported into the Aggregator.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.0;9.1;9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21987665