SQL execution - GermainUX Docs

ComponentsEngine

Availability2020.2 or later

Execution Modes

Choose when SQL runs

Configure the SQL Action

Build a reporting SQL action

Add the SQL Query

Write the login activity query

Security and Performance Recommendations

Safe, efficient SQL execution

GermainUX can execute SQL queries against a configured database or the GermainUX Datamart. Query results can be included in an email, attached as a file, or used as part of an automated workflow.

Execution Modes

SQL Actions can run:

Manually
On a configurable schedule
When an SLA condition is met

Configure a SQL Action

Using the Wizard

Go to GermainUX Workspace > Wizards > SQL Action.

Using the Configuration Screen

Go to GermainUX Workspace > Automation > SQL. Select an existing SQL Action to edit it, or click + to open the SQL Action wizard.

SQL Action Reference

Workspace field	Configuration key	Description	Possible values
Name	`name`	Unique name for the action.	String
Execute via Engine	`remote`	Executes the action through a GermainUX Engine. When enabled, a target server can be specified.	Boolean
Target Server	`targetExpression`	MVEL expression used to identify the target server for remote execution.	String
Logging Enabled	`loggingEnabled`	Records each execution of the action.	Boolean
Notify on Success	`notifyOnSuccess`	Creates a notification when the action succeeds.	Boolean
Notify on Failure	`notifyOnFailure`	Creates a notification when the action fails.	Boolean
Execution Count	`limitCount`	Maximum number of executions allowed during the configured interval.	Integer
Execution Interval	`limitInterval`	Period during which the execution-count limit applies.	`YEAR`, `MONTH`, `WEEK`, `DAY`, `HOUR`, or `MINUTE`
Distribution List	`alertGroupName`	Distribution list that receives the report.	Existing distribution-list name
Alert Template	`templateName`	Template used to generate the report message.	Existing template name
Suppress Email if Result Is Empty	`suppressIfEmptyResult`	Prevents report delivery when the query returns no results.	Boolean
Monitored Database	`monitoredDatabase`	Configured database against which the query runs.	Existing database configuration
Credentials	`credentials`	Configured credentials used to connect to the database.	Existing credential configuration
Attach Result	`attachResult`	Attaches the query results to the report.	Boolean
Datamart Query	`datamartQuery`	Runs the query against the GermainUX Datamart.	Boolean
Run on Schedule	`schedule`	Enables scheduled execution and allows a CRON expression to be defined.	Boolean
References	`references`	Advanced references to credentials, configuration entries, or custom values used by the action or template.	Reference collection
SQL Queries	`sqlQueries`	Queries included in the SQL report.	List of `SqlReportQueryConfig` objects
Triggered by SLAs	—	SLAs configured to trigger this action.	Collection of SLAs

SQL Query Configuration

Each entry in sqlQueries can contain:

Property	Description
`name`	Unique name for the query.
`sqlText`	SQL statement to execute.
`intervalType`	Time interval applied to the query.
`attachmentNameTemplate`	Template used to name the result attachment.

References

References allow the action or report template to access other GermainUX configuration objects securely.

Property	Description	Example
`name`	Unique name used to reference the configuration item.	`Credentials`
`key`	GermainUX configuration collection key.	`germain.apm.monitoringConfig.credentials`
`itemName`	Name of the item within the collection.	`ReportingCredentials`
`value`	Direct custom value when no configuration item is referenced.	A non-sensitive report parameter

A referenced property can be accessed with an expression such as:

${Credentials.username}

Use configured credentials for usernames, passwords, tokens, and other secrets. Do not store sensitive values directly in SQL statements, templates, or custom references. This example creates a daily email report containing an attachment with the GermainUX login activity recorded during the previous day.

1 Step 1: Configure the SQL Action

Go to GermainUX Workspace > Automation > SQL.
Click + to open the SQL Action wizard.
Enter a unique action name.
Select or create the distribution list that will receive the report.
Select or create the email template.
Enable Attach Result.
Click Next.
Configure the SQL Action - GermainUX

2 Step 2: Configure the Connection

To query the GermainUX Datamart, enable Run against GermainUX Datamart. To query another database:

Select a configured database.
Select the credentials used to access it.
Test the connection, if that option is available.
Click Next.
Configure the Connection - GermainUX

3 Step 3: Add the SQL Query

Add the query that returns GermainUX login activity from the previous day. A SQL Action can contain one or more queries. The selected database and credentials from the previous step determine where those queries execute. Preview or validate the query results before continuing.

4 Step 4: Configure the Schedule

Enable Run on Schedule.
Configure the desired execution frequency or enter a CRON expression.
Set the report to run once per day at the required time.
Click Next.
Configure the Schedule - GermainUX

5 Step 5: Configure an SLA Trigger

SQL Actions can run on a schedule or when an SLA is breached. Because this example uses a daily schedule, leave the SLA selection empty and click Finish. GermainUX will now execute the query each day and send the resulting login report to the selected distribution list.

Attachment in a report example - GermainUX

Security and Performance Recommendations

Use a dedicated database account with the minimum required permissions.
Prefer read-only credentials for reporting queries.
Store credentials in GermainUX credential configurations.
Use parameterized values where supported.
Avoid unrestricted or destructive SQL statements.
Validate queries against a non-production database before enabling them.

Show all 9

Apply execution limits and query timeouts.
Schedule resource-intensive queries outside peak operating periods.
Suppress delivery when an empty result provides no useful information.

Get Help

Contact GermainUX Support

The Germain Team can help you set this up.

Can't find what you need?

Search all GermainUX docs with Ctrl + K, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE LLC.

Execution Modes

Configure the SQL Action

Add the SQL Query

Security and Performance Recommendations

​Execution Modes

​Configure a SQL Action

​Using the Wizard

​Using the Configuration Screen

​SQL Action Reference

​SQL Query Configuration

​References

​Example: Scheduled GermainUX Login Report

​1 Step 1: Configure the SQL Action

​2 Step 2: Configure the Connection

​3 Step 3: Add the SQL Query

​4 Step 4: Configure the Schedule

​5 Step 5: Configure an SLA Trigger

​Security and Performance Recommendations

​Get Help

Contact GermainUX Support

Can't find what you need?

Execution Modes

Configure a SQL Action

Using the Wizard

Using the Configuration Screen

SQL Action Reference

SQL Query Configuration

References

Example: Scheduled GermainUX Login Report

1 Step 1: Configure the SQL Action

2 Step 2: Configure the Connection

3 Step 3: Add the SQL Query

4 Step 4: Configure the Schedule

5 Step 5: Configure an SLA Trigger

Security and Performance Recommendations

Get Help