Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.
software:dashboard:analyses:instance_analyses_oracle
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung Nächste Überarbeitung Beide Seiten der Revision | ||
|
software:dashboard:analyses:instance_analyses_oracle [2015/06/08 10:30] manuel.kindler [Durchschnittliche Durchlaufszeit (in hh:mm:ss) der Instanzen einer bestimmten Prozessdefinition je Monat] |
software:dashboard:analyses:instance_analyses_oracle [2015/06/08 10:35] manuel.kindler [Anzahl beendeter Instanzen je Monat für 2 Definitionen] |
||
|---|---|---|---|
| Zeile 819: | Zeile 819: | ||
| <code sql> | <code sql> | ||
| SELECT | SELECT | ||
| - | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))) AS Monat, | + | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))) AS Monat, |
| - | SUM( | + | SUM( |
| - | CASE | + | CASE |
| - | WHEN inst.definitionname ='PROZESSDEFINITIONSNAME 1' | + | WHEN inst.definitionname ='NAME DER PROZESSDEFINITION 1' |
| - | THEN 1 | + | THEN 1 |
| - | ELSE 0 | + | ELSE 0 |
| - | END) AS "PROZESSDEFINITIONSNAME 1 Count", | + | END) AS "Count Prozessdefinition 1", |
| - | SUM( | + | SUM( |
| - | CASE | + | CASE |
| - | WHEN inst.definitionname ='PROZESSDEFINITIONSNAME 2' | + | WHEN inst.definitionname ='NAME DER PROZESSDEFINITION 2' |
| - | THEN 1 | + | THEN 1 |
| - | ELSE 0 | + | ELSE 0 |
| - | END) AS "PROZESSDEFINITIONSNAME 2 Count" | + | END) AS "Count Prozessdefinition 2" |
| - | FROM view_instance inst | + | FROM view_instance inst |
| - | WHERE inst.definitionname = 'PROZESSDEFINITIONSNAME 1' | + | WHERE inst.definitionname = 'NAME DER PROZESSDEFINITION 1' |
| - | OR inst.definitionname = 'PROZESSDEFINITIONSNAME 2' | + | OR inst.definitionname = 'NAME DER PROZESSDEFINITION 2' |
| - | GROUP BY | + | GROUP BY |
| - | EXTRACT(YEAR FROM to_date(SUBSTR(creationtime,0,(INSTR(creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), | + | EXTRACT(YEAR FROM to_date(SUBSTR(creationtime,0,(INSTR(creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), |
| - | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))) | + | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.creationtime,0,(INSTR(inst.creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))), |
| + | EXTRACT(YEAR FROM to_date(SUBSTR(creationtime,0,(INSTR(creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), | ||
| + | EXTRACT(MONTH FROM to_date(SUBSTR(creationtime,0,(INSTR(creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')) | ||
| + | ORDER BY | ||
| + | EXTRACT(YEAR FROM to_date(SUBSTR(creationtime,0,(INSTR(creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), | ||
| + | EXTRACT(MONTH FROM to_date(SUBSTR(creationtime,0,(INSTR(creationtime, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')) | ||
| </code> | </code> | ||
| Zeile 864: | Zeile 869: | ||
| <code sql> | <code sql> | ||
| SELECT | SELECT | ||
| - | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))) AS Monat, | + | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))) AS Monat, |
| - | SUM( | + | SUM( |
| - | CASE | + | CASE |
| - | WHEN inst.definitionname ='PROZESSDEFINITIONSNAME 1' | + | WHEN inst.definitionname ='PROZESSDEFINITIONSNAME 1' |
| - | THEN 1 | + | THEN 1 |
| - | ELSE 0 | + | ELSE 0 |
| - | END) AS "PROZESSDEFINITIONSNAME 1 Count", | + | END) AS "PROZESSDEFINITIONSNAME 1 Count", |
| - | SUM( | + | SUM( |
| - | CASE | + | CASE |
| - | WHEN inst.definitionname ='PROZESSDEFINITIONSNAME 2' | + | WHEN inst.definitionname ='PROZESSDEFINITIONSNAME 2' |
| - | THEN 1 | + | THEN 1 |
| - | ELSE 0 | + | ELSE 0 |
| - | END) AS "PROZESSDEFINITIONSNAME 2 Count" | + | END) AS "PROZESSDEFINITIONSNAME 2 Count" |
| - | FROM view_instance inst WHERE inst.END IS NOT NULL | + | FROM view_instance inst WHERE inst.END IS NOT NULL |
| - | AND (inst.definitionname = 'PROZESSDEFINITIONSNAME 1' OR inst.definitionname = 'PROZESSDEFINITIONSNAME 2') | + | AND (inst.definitionname = 'S-AP-G' OR inst.definitionname = 'S-AP-010-010_1') |
| - | + | GROUP BY | |
| - | GROUP BY | + | EXTRACT(YEAR FROM to_date(SUBSTR(END,0,(INSTR(END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), |
| - | EXTRACT(YEAR FROM to_date(SUBSTR(END,0,(INSTR(END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), | + | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))), |
| - | CONCAT(CONCAT(SUBSTR(to_char(to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'), 'Month'),1,3),' '),EXTRACT(YEAR FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS'))) | + | EXTRACT(YEAR FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), |
| + | EXTRACT(MONTH FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')) | ||
| + | ORDER BY | ||
| + | EXTRACT(YEAR FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')), | ||
| + | EXTRACT(MONTH FROM to_date(SUBSTR(inst.END,0,(INSTR(inst.END, '.', -1)-1)), 'DD-MM-YY HH24:MI:SS')) | ||
| </code> | </code> | ||
software/dashboard/analyses/instance_analyses_oracle.txt · Zuletzt geändert: 2021/07/01 09:52 (Externe Bearbeitung)
Falls nicht anders bezeichnet, ist der Inhalt dieses Wikis unter der folgenden Lizenz veröffentlicht: 2013 T!M Solutions GmbH
