Tableau Reports Datasources

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.tiger.agents.PdoStar'
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.tiger.agents.PdoStar', 'analytics.tiger.agents.PoolingCalculator')
		AND return_code=0
		GROUP BY agent_name
		)

You can find the agent name using:

SELECT agent_name
FROM etl_runs
GROUP BY agent_name