Changeset 41253 for trunk/ippMonitor/def/minidvodbRun.d

Timestamp:

Jan 29, 2020, 2:28:01 PM (6 years ago)

Author:

ippitc

Message:

CCL: add number of smf files in each minidvodb

File:

• trunk/ippMonitor/def/minidvodbRun.d (modified) (2 diffs)

trunk/ippMonitor/def/minidvodbRun.d

@@ -1 +1 @@
 TABLE minidvodbRun 
+#TABLE minidvodbRun LEFT JOIN (SELECT count(*) AS addnum, minidvodb_name FROM addRun GROUP BY minidvodb_name) AS sub ON sub.minidvodb_name = minidvodbRun.minidvodb_name
 TITLE minidvodb Runs
 FILE  minidvodbRun.php
@@ -13 +14 @@
 FIELD minidvodbRun.minidvodb_group,       5, %s,     minidvodb_group
 FIELD minidvodbRun.minidvodb_path,    25, %s,     minidvodb_path
+FIELD minidvodbRun.minidvodb_host,    5, %s,     minidvodb_host
 #FIELD minidvodbRun.mergedvodb_path,          25, %s,     mergedvodb_path
 FIELD state,          5, %s,    State
+#FIELD addnum,                          5, %d,     addnum
 FIELD creation_date,        5, %T,     epoch