Hi Community,

Is it possible to get the row count based on the entered query entered by an user in guardium data protection(12.1V).

Use case :

A user is entering a query on the database - select * from customers.customers1; (Schema is customers, table is customers1)

Now this query returns more than 1000 rows.

I want an alert triggered when returned row count of 1000 exceeds for a query.

After the some research, I found an option in 'Other Criteria' --> "Records affected threshold" which has the option to 'exceed row count' but it does not allow me to change the value from '0'. Please find the below screenshot.

Not sure whether this is the correct approach or not. 

If you have an insight on this please advice the way I should be taken.

Regards,

Inura Katulanda.