IBM Security Guardium

Hello, 

I want to parse SQL field and get value to another field in report
is there any option to resolve this problem?

For example: select * from employee where id = '012345'
I want to get '012345' to another field to compare critical employee ids.

------------------------------
Levani Chubinidze
------------------------------

Hi @Levani Chubinidze,

That value should be parsing into the 'Field' entity already. If you create a report from the Access domain and use 'Main entity = Field', then include the Field Name attribute as one of your selected columns, you should find it. You can then build a group and use the group in your report conditions. 

If you want to create a custom field and parse it into it as well, that gets a bit more complicated, requiring customization and some creativity. You can look into using a computed attribute: https://www.ibm.com/docs/en/guardium/11.5?topic=reference-create-computed-attribute maybe.

------------------------------
Wendy Zemba
Sr. Consultant, Data Protection
wendy.zemba@convergetp.com
Converge Technology Solutions

Need help with your Guardium deployment? Contact me directly to discuss engagement opportunities. Currently serving North America.
------------------------------

Original Message:
Sent: Thu May 16, 2024 03:32 AM
From: Levani Chubinidze
Subject: SQL Parser

Hello, 

I want to parse SQL field and get value to another field in report
is there any option to resolve this problem?

For example: select * from employee where id = '012345'
I want to get '012345' to another field to compare critical employee ids.

------------------------------
Levani Chubinidze
------------------------------

Hi,

You can try to create Computed Attribute to create custom field. You can use MySQL expressions to create new value based on the SQL field.

Documentation: https://www.ibm.com/docs/en/guardium/11.4?topic=reference-create-computed-attribute

Sample: https://www.ibm.com/support/pages/how-create-custom-computed-attribute-shows-if-guardium-gui-user-enabled-or-disabled

MySQL functions for v11 (Check MySQL v8 documentation for Guardium v12)- https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html

------------------------------
Marek Dziarski
------------------------------

Original Message:
Sent: Thu May 16, 2024 03:32 AM
From: Levani Chubinidze
Subject: SQL Parser

Hello, 

I want to parse SQL field and get value to another field in report
is there any option to resolve this problem?

For example: select * from employee where id = '012345'
I want to get '012345' to another field to compare critical employee ids.

------------------------------
Levani Chubinidze
------------------------------