Configuration Guide › Integrating CA GovernanceMinder with Other CA Products › CA User Activity Reporting Integration › Import CA GovernanceMinder Queries Into CA User Activity Reporting › Modifying SQL Queries for Certain Endpoint Types

Modifying SQL Queries for Certain Endpoint Types

An advanced integration option allows you to change the way CA GovernanceMinder counts endpoint usage data from CA User Activity Reporting. The default filter counts all kinds of login events, but you may decide that you only want to count certain login events. For example, if you have an SAP system and you only want to count events of a specific SAP transaction type.

Also, you may have some endpoints that provide a different type of event, for example, an endpoint with session creation events, and you want to count those events instead of login events.

In the previous use cases, you can change the default filter for your scenario, but it must comply with SQL WHERE clause syntax, using fields defined in the CA User Activity Reporting Common Event Grammar Guide.

For example:

(event_action = 'Login Attempt') AND (event_result = 'S')