| Lucidchartlucidchart |
|---|
| pageCount | 1 |
|---|
| autoUpdate | false |
|---|
| align | left |
|---|
| pageId | 613974053 |
|---|
| type | rich |
|---|
| autoSize | 1 |
|---|
| macroId | 0d2f48c4-dd5f-4e45-b051-b72782eb4a5a | pageCount |
|---|
| 1 | instanceId | Confluence:8792679401 |
|---|
| pages | |
|---|
| width | 1000 |
|---|
| documentId | be28b108-a693-4c8d-833b-2fbcd992ace9 |
|---|
| align | left |
|---|
| type | rich |
|---|
| updated | 1533143753584documentToken | 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.
| Code Block |
|---|
|
SELECT max(end_time) extraction_time |
...
...
WHERE agent_name= 'analytics.tiger. |
...
...
...
or for multiple agents:
| Code Block |
|---|
|
SELECT min(end_time) extraction_time |
...
...
SELECT max(end_time) end_time |
...
...
WHERE agent_name IN ('analytics. |
...
...
PdoStar', 'analytics.tiger. |
...
...
...
...
...
You can find the agent name using:
| Code Block |
|---|
|
SELECT agent_name |
...
...