Details Table

Overview

The detailsTable function prints a two-column table consisting of window and command fields in the specified format.

Decimal numbers presented in the table are rounded to 5 significant digits, except on the Logging and Derived Commands tabs.

Syntax

detailsTable(string format [, section])

The optional section parameters can be used to control which fields to include in the table.

Formats

markdown
ascii
html
property
csv

Sections

overview
entity
metric
statistics
variables

Entity name
Entity label
Entity tags
Window placeholders
Command tags
Value
Statistical functions
User-defined variables

Examples

The examples below are written to a log file on the Logging tab and maintain the original numeric precision.

`ascii`

detailsTable('ascii')

+-------------------+-----------------------------------+
| Name              | Value                             |
+-------------------+-----------------------------------+
| name              | atsd                              |
| label             | Axibase Time Series Database      |
| app               | ATSD                              |
| host              | NURSWGVML007                      |
| metric            | jvm_memory_used_percent           |
| metric_label      | JVM Memory Used, %                |
| expression        | avg() > 0                         |
| window            | time(1 minute)                    |
| severity          | warning                           |
| alert_type        | OPEN                              |
| timezone          | GMT (+00:00)                      |
| command_time      | 2018-09-13T12:18Z[Etc/UTC]        |
| command_first_time| 2018-09-13T12:18Z[Etc/UTC]        |
| update_time       | 2018-09-13T12:18:00.007Z[Etc/UTC] |
| open_time         | 2018-09-13T12:18:00.007Z[Etc/UTC] |
| value             | 22.72808635185156                 |
| status            | OPEN                              |
| tags.host         | NURSWGVML007                      |
| count             | 3                                 |
| sum               | 62.80243733055981                 |
| avg               | 20.93414577685327                 |
| first             | 18.97742859958052                 |
| last              | 22.72808635185156                 |
| diff              | 3.7506577522710387                |
| max               | 22.72808635185156                 |
| min               | 18.97742859958052                 |
| variance          | 3.5367305603537185                |
| stddev            | 1.8806197277370347                |
| wavg              | 21.559255402231774                |
| wtavg             | 22.10622632443797                 |
| percentile(50)     | 21.09692237912773                 |
| percentile(75)     | 22.72808635185156                 |
| percentile(90)     | 22.72808635185156                 |
| percentile(95)     | 22.72808635185156                 |
| percentile(99)     | 22.72808635185156                 |
| slope             | 1.2502e-4                         |
| intercept         | -1.8922e8                         |
+-------------------+-----------------------------------+

`markdown`

detailsTable('markdown')

| **Name** | **Value** |
|:---|:---|
| name | atsd |
| label | Axibase Time Series Database |
| app | ATSD |
| host | NURSWGVML007 |
| metric | jvm_memory_used_percent |
| metric_label | JVM Memory Used, % |
| expression | avg() > 0 |
| window | time(1 minute) |
| severity | warning |
| alert_type | OPEN |
| timezone | GMT (+00:00) |
| command_time | 2018-09-13T12:18Z[Etc/UTC] |
| command_first_time | 2018-09-13T12:18Z[Etc/UTC] |
| update_time | 2018-09-13T12:18:00.007Z[Etc/UTC] |
| open_time | 2018-09-13T12:18:00.007Z[Etc/UTC] |
| value | 22.72808635185156 |
| status | OPEN |
| tags.host | NURSWGVML007 |
| count | 3 |
| sum | 62.80243733055981 |
| avg | 20.93414577685327 |
| first | 18.97742859958052 |
| last | 22.72808635185156 |
| diff | 3.7506577522710387 |
| max | 22.72808635185156 |
| min | 18.97742859958052 |
| variance | 3.5367305603537185 |
| stddev | 1.8806197277370347 |
| wavg | 21.559255402231774 |
| wtavg | 22.10622632443797 |
| percentile(50) | 21.09692237912773 |
| percentile(75) | 22.72808635185156 |
| percentile(90) | 22.72808635185156 |
| percentile(95) | 22.72808635185156 |
| percentile(99) | 22.72808635185156 |
| slope | 1.2502e-4 |
| intercept | -1.8922e8 |

`csv`

detailsTable('csv')

Name,Value
name,atsd
label,Axibase Time Series Database
app,ATSD
host,NURSWGVML007
metric,jvm_memory_used_percent
metric_label,"JVM Memory Used, %"
expression,avg() > 0
window,time(1 minute)
severity,warning
alert_type,OPEN
timezone,GMT (+00:00)
command_time,2018-09-13T12:18Z[Etc/UTC]
command_first_time,2018-09-13T12:18Z[Etc/UTC]
update_time,2018-09-13T12:18:00.007Z[Etc/UTC]
open_time,2018-09-13T12:18:00.007Z[Etc/UTC]
value,22.72808635185156
status,OPEN
tags.host,NURSWGVML007
count,3
sum,62.80243733055981
avg,20.93414577685327
first,18.97742859958052
last,22.72808635185156
diff,3.7506577522710387
max,22.72808635185156
min,18.97742859958052
variance,3.5367305603537185
stddev,1.8806197277370347
wavg,21.559255402231774
wtavg,22.10622632443797
percentile(50),21.09692237912773
percentile(75),22.72808635185156
percentile(90),22.72808635185156
percentile(95),22.72808635185156
percentile(99),22.72808635185156
slope,1.2502e-4
intercept,-1.8922e8

`html`

detailsTable('html')

<table style="font-family: monospace, consolas, sans-serif; border-collapse: collapse;"><tbody><tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">name</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;"><a href="https://atsd_hostname:8443/entities/atsd">atsd</a></td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">label</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">Axibase Time Series Database</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">app</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">ATSD</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">url</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">https://atsd_hostname:8443</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">host</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">NURSWGVML007</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">metric</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;"><a href="https://atsd_hostname:8443/metrics/metric.xhtml?metricName=jvm_memory_used_percent">jvm_memory_used_percent</a></td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">metric_label</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">JVM Memory Used, %</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">expression</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">avg() > 0</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">window</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">time(1 minute)</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">severity</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">warning</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">alert_type</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">OPEN</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">timezone</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">GMT (+00:00)</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">command_time</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">2018-09-13T12:18Z[Etc/UTC]</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">command_first_time</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">2018-09-13T12:18Z[Etc/UTC]</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">update_time</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">2018-09-13T12:18:00.007Z[Etc/UTC]</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">open_time</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">2018-09-13T12:18:00.007Z[Etc/UTC]</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">value</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">status</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">OPEN</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">tags.host</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">NURSWGVML007</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">count</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">3</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">sum</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">62.80243733055981</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">avg</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">20.93414577685327</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">first</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">18.97742859958052</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">last</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">diff</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">3.7506577522710387</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">max</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">min</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">18.97742859958052</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">variance</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">3.5367305603537185</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">stddev</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">1.8806197277370347</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">wavg</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">21.559255402231774</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">wtavg</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.10622632443797</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">percentile(50)</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">21.09692237912773</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">percentile(75)</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">percentile(90)</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">percentile(95)</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">percentile(99)</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">22.72808635185156</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">slope</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">1.2502e-4</td></tr>
<tr><td bgcolor="#f0f0f0" align="right" style="font-weight: bold;border: 1px solid #d0d0d0;padding: 4px;">intercept</td><td align="left" style="border: 1px solid #d0d0d0;padding: 4px;">-1.8922e8</td></tr>
</tbody></table>

`property`

detailsTable('property')

name=atsd
label=Axibase Time Series Database
app=ATSD
url=https://atsd_host
host=NURSWGVML007
metric=jvm_memory_used_percent
metric_label=JVM Memory Used, %
expression=avg() > 0
window=time(1 minute)
severity=warning
alert_type=OPEN
timezone=GMT (+00:00)
command_time=2018-09-13T12:18Z[Etc/UTC]
command_first_time=2018-09-13T12:18Z[Etc/UTC]
update_time=2018-09-13T12:18:00.007Z[Etc/UTC]
open_time=2018-09-13T12:18:00.007Z[Etc/UTC]
value=22.72808635185156
status=OPEN
tags.host=NURSWGVML007
count=3
sum=62.80243733055981
avg=20.93414577685327
first=18.97742859958052
last=22.72808635185156
diff=3.7506577522710387
max=22.72808635185156
min=18.97742859958052
variance=3.5367305603537185
stddev=1.8806197277370347
wavg=21.559255402231774
wtavg=22.10622632443797
percentile(50)=21.09692237912773
percentile(75)=22.72808635185156
percentile(90)=22.72808635185156
percentile(95)=22.72808635185156
percentile(99)=22.72808635185156
slope=1.2502e-4
intercept=-1.8922e8

# Details Table

# Overview

# Syntax

# Formats

# Sections

# Contents

# Examples

# ascii

# markdown

# csv

# html

# property