Create a Automatic Report

Here are 3 ways to create a automatic report (CSV, PDF, HTML) with data stored in different types of datastores.

Relational Database Report

Select SQL Report option to create an automatic CSV, PDF or HTML report with data pulled from a relational database.

Germain Workspace > Left Menu > Automation > Report > + icon > SQL Report

And if this report consists in pulling data stored in separate relational databases, add separate SQL queries respectively for pulling data from each database.

For instance, the first SQL query looks like this:

SQL statement example for one report - Germain UX

Report File Name

For example:

CODE

Report ${config.name} - ${.now?string[\"dd_MMM_yyyy\"]} - ${result.rowCount} rows

Your file name will be

CODE

MyReport - 04_MAY_2020 - 1384 rows.csv

Elasticsearch Report

Select ES Report to create a report in CSV, PDF or HTML format can be automatically generated at a set interval, by pulling data from an Elasticsearch datastore.

Germain Workspace > Left Menu > Automation > Report > + icon > ES Report

Native Elasticsearch SQL is used by Germain UX to pull any data from an Elasticsearch datastore. More details about Elasticsearch SQL.

Scripted Approach

Select Scripted Report to create a report in CSV, PDF or HTML format cannot automatically generated using either above approaches.

Germain Workspace > Left Menu > Automation > Report > + icon >Scripted Report

Example 1:

Example 2:

Germain loads the data and perform the equivalent of a join for a SQL like this:

CODE

select
    db.timestamp
    , substr(clk.name,5) USER_CLICK_NAME
    , db.queryid SQL_ID
    , db.duration SQL_DURATION
    , clk.duration USER_CLICK_DURATION
    , clk.USER_NAME USER_NAME
    , clk.SIEBEL_VIEW SIEBEL_VIEW
    , clk.SIEBEL_APPLET SIEBEL_APPLET
from 
    siebel_database_txn db
    left join siebel_web_svc_txn txn 
        on txn.sequence = substr(db.sequence, 1, instr(db.sequence, '.', -1, 1) -1)
    left join siebel_out_http_req req
        on req.backendsequence = txn.sequence
    left join siebel_user_click clk
        on clk.sequence = substr(req.sequence, 1, instr(req.sequence, '.', -1, 1) -1)
where
    clk.siebel_command like 'ExecuteNamedQuery'
    and clk.application_name = 'Argus PS18'
    and db.color != 'GREEN'
    and db.timestamp between ? and ?
order by
    db.duration desc

Template

Templates are either HTML, Text or SMS format and very customizable.

Access them: Germain Workspace > Left Menu > System>Alert Templates

More details on Alert Template Reference.

Feature Availability: 2023.4 or later