| Gliffy |
|---|
name | Tableau Reports Based on Data marts| Lucidchart |
|---|
| pageCount | 1 |
|---|
| autoUpdate | false |
|---|
| align | left |
|---|
| pageId | 613974053 |
|---|
| type | rich |
|---|
| autoSize | 1 |
|---|
| macroId | 0d2f48c4-dd5f-4e45-b051-b72782eb4a5a |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | |
|---|
| width | 1000 |
|---|
| documentId | be28b108-a693-4c8d-833b-2fbcd992ace9 |
|---|
| documentToken | be28b108-a693-4c8d-833b-2fbcd992ace9|42323|613974053|2+38W1rIdkFtu7Az9fJmfmVRbf/Pjs1cK1u6YPwOgDw= |
|---|
| consumerKey | Confluence:8792679401 |
|---|
| height | 1000 |
|---|
|
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 |
...
...
WHERE agent_name= 'analytics.tiger.agents.PdoStar'
AND return_code=0 |
or for multiple agents:
| Code Block |
|---|
|
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 |
...
You can find the agent name using:
| Code Block |
|---|
|
SELECT agent_name
FROM etl_runs
GROUP BY agent_name |