IBM Support

IBM Security Guardium - Query with a condition using GROUP not working correctly

Troubleshooting


Problem

When creating a custom query with a condition on any field it doesn't give the required result when using operator: IN GROUP NOT IN GROUP LIKE GROUP NOT LIKE GROUP

Symptom

1) I want to see a report of traffic with just the following DB Users :-

SYS

SYSAD

ADMIN


I define my reports query to have a condition to show traffic with db users IN a GROUP called "system", where my group "system" contains SYS% and ADMIN%. However the result of my report is empty.


2) I define group "system" with members SYS, SYSAD, ADMIN on my Managed Unit (MU) and the same query used as above but still get the wrong result.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Guardium Database Activity Monitor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"10.0;10.0.1;10.1;10.1.2;10.1.3;9.0;9.1;9.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21989795