Versions Compared

Version Old Version 7 New Version 8
Changes made by

Lucidchart Diagrams Connector

Rafael Sanchez (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Lucidchart
autoSize1
macroId0d2f48c4-dd5f-4e45-b051-b72782eb4a5a
pageCount1
instanceIdConfluence:8792679401
width1000
documentIdbe28b108-a693-4c8d-833b-2fbcd992ace9
alignleft
typerich
updated1533143753584
height1000

Exposing the last time an agent ran successfully

The following script generates a single-record table (you can put in WHERE clause whatever agent you are interested in). Add it to your Tableau workbook as a separate data connection and let it JOIN (join condition doesn't matter since it's always going to have only 1 record). Then you should be able to expose this time to your end users.

The connection is COGNOS@SEQPROD. 


SELECT max(end_time) extraction_time

FROM etl_runs a

 WHERE agent_name= 'analytics.etl.PdoStar5Agent$'

 AND return_code=0

or for multiple agents:

SELECT min(end_time) extraction_time
FROM (
SELECT max(end_time) end_time
FROM etl_runs a
WHERE agent_name IN ('analytics.etl.PdoStar5Agent$', 'analytics.etl2.BspPicoEtl')
AND return_code=0
GROUP BY agent_name
)

...