Exemples de disposition d'association de mosaïques

La mosaïque suivante comporte deux lignes, trois colonnes, un titre personnalisé, une taille de police personnalisée et une couleur pour le titre et le contenu.

Requête :

*
| link
| eval Projects = 65
| eval 'Primary Sites' = 69
| eval Cases = 89122
| eval Files = 589011
| eval Genes = 22900
| eval Mutations = 3150602

Définition XML :

<summary>
  <container>
    <table>
      <row>
        <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Projects">
              <title><title-text color="#85929E">PROJECTS</title-text></title>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Primary Sites">
              <title><title-text color="#85929E">PRIMARY SITES</title-text></title>
            </tile>
          </tiles>
        </column>
           <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Cases">
              <title>
                <title-text color="#85929E">CASES</title-text></title>
            </tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Files">
              <title>
                <title-text color="#85929E">FILES</title-text></title>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Genes">
              <title><title-text color="#85929E">GENES</title-text></title>
            </tile>
          </tiles>
        </column>
           <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Mutations">
              <title><title-text color="#85929E">MUTATIONS</title-text></title>
            </tile>
          </tiles>
        </column>
      </row>      
    </table>
  </container>
</summary>

L'attribut table de l'exemple suivant est défini sur la valeur layout pour compacter la première ligne et présente un remplissage de couleur d'arrière-plan.

Requête :

*
| link
| eval Projects = 65
| eval 'Primary Sites' = 69
| eval Cases = 89122
| eval Files = 589011
| eval Genes = 22900
| eval Mutations = 3150602

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles layout="table" columns="3" background-color="#AED6F1">
            <tile color="#D35400" font-size="large" field="Projects">
              <title><title-text color="#D35400">PROJECTS</title-text></title>
            </tile>
            <tile color="#D35400" font-size="large" field="Primary Sites">
              <title><title-text color="#D35400">PRIMARY SITES</title-text></title>
            </tile>
            <tile color="#D35400" font-size="large" field="Cases">
              <title>
                <title-text color="#D35400">CASES</title-text></title>
            </tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Files">
              <title>
                <title-text color="#85929E">FILES</title-text></title>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Genes">
              <title><title-text color="#85929E">GENES</title-text></title>
            </tile>
          </tiles>
        </column>
           <column>
          <tiles>
            <tile color="#17202A" font-size="large" field="Mutations">
              <title><title-text color="#85929E">MUTATIONS</title-text></title>
            </tile>
          </tiles>
        </column>
      </row>      
    </table>
  </container>
</summary>

L'exemple suivant comporte une ligne, plusieurs colonnes, des noms de champ par défaut, des types de champ mixtes (liens, unités) et aucun séparateur.

Requête :

* | eval 'Raw Size (bytes)' = unit('Raw Size', byte) | link includenulls = true 'Log Source', Entity, cluster() | stats sum('Raw Size (bytes)') as R | addfields [ * | where 'Potential Issue' = '1' | eventstats count as I ], [ * | where Count = 1 | eventstats count as O ] | eval 'Query Duration' = 'Query End Time' - 'Query Start Time' | eventstats distinctcount('Log Source') as L, distinctcount(Entity) as E, sum(Count) as Logs, sum(R) as Size, max(I) as I1, max(O)
      as O1 | eval QS = formatDate('Query Start Time') | eval QE = formatDate('Query End Time') | eval URL_LS = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=hbar&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20stats%20count%20by%20%27Log%20Source%27', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_E = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=pie&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20stats%20count%20by%20%27Entity%27', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_I = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=cluster&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20cluster', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_O = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=cluster&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20cluster', literal(STARTTIME), QS), ENDTIME, QE) | eval 'Log Sources' = url(URL_LS, toString(L)) | eval E1 = if(E != null, E, 0) | eval Entities = url(URL_E, toString(E)) | eval I2 = if(I1 != null, I1, 0) | eval Issues = url(URL_I, toString(I2)) | eval Outliers = url(URL_O, toString(O1)) |
      fields -L, -E, -I, -I1, -I2, -E1, -O, -O1, -QS, -QE, -URL_LS, -URL_I, -URL_O, -URL_E,
      -'Potential Issue', -R, -'Log Source', -'Start Time', -'End Time', -'Query Duration' | head limit = 1

Définition XML :

<summary>
  <container background-color="rgba(77, 182, 172)">
   <title> 
    <title-text color="#BF360C" font-size="20px">Summary</title-text>
    </title>
    <table>
      <row>
        <column><tiles><tile field="Entities"></tile></tiles></column>
        <column><tiles><tile field="Issues"></tile></tiles></column>
        <column><tiles><tile field="Outliers"></tile></tiles></column>
        <column><tiles><tile field="Size"></tile></tiles></column>
        <column><tiles><tile field="Log Sources"></tile></tiles></column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant présente une ligne, une colonne, des cartes emballées et des séparateurs verticaux.

Requête :

* | eval 'Raw Size (bytes)' = unit('Raw Size', byte) | link includenulls = true 'Log Source', Entity, cluster() | stats sum('Raw Size (bytes)') as R | addfields [ * | where 'Potential Issue' = '1' | eventstats count as I ], [ * | where Count = 1 | eventstats count as O ] | eval 'Query Duration' = 'Query End Time' - 'Query Start Time' | eventstats distinctcount('Log Source') as L, distinctcount(Entity) as E, sum(Count) as Logs, sum(R) as Size, max(I) as I1, max(O)
      as O1 | eval QS = formatDate('Query Start Time') | eval QE = formatDate('Query End Time') | eval URL_LS = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=hbar&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20stats%20count%20by%20%27Log%20Source%27', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_E = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=pie&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20stats%20count%20by%20%27Entity%27', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_I = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=cluster&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20cluster', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_O = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=cluster&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20cluster', literal(STARTTIME), QS), ENDTIME, QE) | eval 'Log Sources' = url(URL_LS, toString(L)) | eval E1 = if(E != null, E, 0) | eval Entities = url(URL_E, toString(E)) | eval I2 = if(I1 != null, I1, 0) | eval Issues = url(URL_I, toString(I2)) | eval Outliers = url(URL_O, toString(O1)) |
      fields -L, -E, -I, -I1, -I2, -E1, -O, -O1, -QS, -QE, -URL_LS, -URL_I, -URL_O, -URL_E,
      -'Potential Issue', -R, -'Log Source', -'Start Time', -'End Time', -'Query Duration' | head limit = 1

Définition XML :

<summary>
  <container background-color="#80DEEA">
   <title>
    <title-text color="#212121" font-size="medium">Summary</title-text>
    </title>
    <table>
      <row>
        <column>
         <tiles background-color="#E1F5FE">
           <tile field="Log Sources"><title><title-text font-size="medium">Log Sources</title-text></title></tile>
           <tile field="Entities"><title><title-text font-size="medium">Entities</title-text></title></tile>
           <tile type="separator"/>
           <tile field="Size"><title><title-text font-size="medium">Size</title-text></title></tile>
           <tile type="separator"/>
           <tile field="Issues"><title><title-text font-size="medium">Issues</title-text></title></tile>
           <tile field="Outliers"><title><title-text font-size="medium">Outliers</title-text></title></tile>
         </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant présente un ensemble de cartes séparées par une ligne horizontale, des étiquettes en bas plutôt qu'en haut et une couleur pour des valeurs et des étiquettes spécifiques.

Requête :

* | eval 'Raw Size (bytes)' = unit('Raw Size', byte) | link includenulls = true 'Log Source', Entity, cluster() | stats sum('Raw Size (bytes)') as R | addfields [ * | where 'Potential Issue' = '1' | eventstats count as I ], [ * | where Count = 1 | eventstats count as O ] | eval 'Query Duration' = 'Query End Time' - 'Query Start Time' | eventstats distinctcount('Log Source') as L, distinctcount(Entity) as E, sum(Count) as Logs, sum(R) as Size, max(I) as I1, max(O)
      as O1 | eval QS = formatDate('Query Start Time') | eval QE = formatDate('Query End Time') | eval URL_LS = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=hbar&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20stats%20count%20by%20%27Log%20Source%27', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_E = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=pie&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20stats%20count%20by%20%27Entity%27', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_I = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=cluster&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20cluster', literal(STARTTIME), QS), ENDTIME, QE) | eval URL_O = replace(replace('https://cloud.oracle.com/loganalytics/explorer?viz=cluster&query=Time%20between%20%27STARTTIME%27%20and%20%27ENDTIME%27%20%7C%20cluster', literal(STARTTIME), QS), ENDTIME, QE) | eval 'Log Sources' = url(URL_LS, toString(L)) | eval E1 = if(E != null, E, 0) | eval Entities = url(URL_E, toString(E)) | eval I2 = if(I1 != null, I1, 0) | eval Issues = url(URL_I, toString(I2)) | eval Outliers = url(URL_O, toString(O1)) |
      fields -L, -E, -I, -I1, -I2, -E1, -O, -O1, -QS, -QE, -URL_LS, -URL_I, -URL_O, -URL_E,
      -'Potential Issue', -R, -'Log Source', -'Start Time', -'End Time', -'Query Duration' | head limit = 1

Définition XML :

<summary>
  <container background-color="rgba(228, 245, 211, 0.5)">
   <title><title-text color="rgba(255, 0, 0)" font-size="30px">Enterprise Summary</title-text></title>
    <table>
      <row>
        <column>
         <tiles layout="table" columns="2">
           <tile field="Log Sources"><title align="bottom"><title-text>Log Sources</title-text></title></tile>
           <tile field="Entities"><title align="bottom"><title-text>Servers</title-text></title></tile>
           <tile type="separator" display="horizontal"/>
           <tile field="Logs"><title align="bottom"><title-text>Log Records</title-text></title></tile>
           <tile field="Size"><title align="bottom"><title-text>Space Usage</title-text></title></tile>
           <tile type="separator" display="horizontal"/>
           <tile field="Issues" color="#F31806"><title align="bottom" color="#F31806"><title-text>Issues</title-text></title></tile>
           <tile field="Outliers"><title align="bottom"><title-text>Outliers</title-text></title></tile>
         </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant affiche les 3 principaux problèmes :

Requête :

* | link includenulls = true Label, 'Problem Priority' | eventstats distinctcount(Label) as Events | addfields [ * | where 'Problem Priority' != null | eventstats distinctcount(Label) as IS ] | sort -'Start Time' | addfields [ * | where 'Problem Priority' = High | eventstats distinctcount(Label) as HP, rownum as Row ] | addfields [ * | where Row = 1 | eventstats latest(Label) as L1 ], [ * | where Row = 2 | eventstats latest(Label) as L2 ], [ * | where Row = 3 | eventstats latest(Label) as L3 ] | eventstats max(IS) as 'Issue Events', max(HP) as 'High Priority Events', unique(L1) as HP1, unique(L2) as HP2, unique(L3) as HP3 | fields -L1, -L2, -L3, -IS, -HP, -Row

Définition XML :

<summary>
  <container>
   <title>
     <title-text color="rgba(255, 0, 0)" font-size="30px">Event Summary</title-text>
    </title>
    <table>
      <row>
        <column>
         <tiles layout="table" columns="5">
           <tile field="Events"><title><title-text>Total Events</title-text></title></tile>
           <tile type="separator" display="vertical"/>
           <tile field="Issue Events"/>
           <tile type="separator" display="vertical"/>
           <tile field="High Priority Events"></tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles layout="table">
          <tile type="condition">
            <condition type="if" field="High Priority Events" operator=">=" value="3">
              <tile type="text" value="Top 3 Events"/>
            </condition>
            <condition type="if" field="High Priority Events" operator=">=" value="2">
              <tile type="text" value="Top 2 Events"/>
            </condition>
            <condition type="if" field="High Priority Events" operator=">=" value="1">
              <tile type="text" value="Top Event"/>
            </condition>
          </tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles layout="table">
            <tile type="condition">
              <condition type="if" field="High Priority Events" operator=">=" value="3">
                <tile color="#F44336" field="HP1"><title/></tile>
                <tile type="separator" display="vertical"/>
                <tile color="#F44336" field="HP2"><title/></tile>
                <tile type="separator" display="vertical"/>
                <tile color="#F44336" field="HP3"><title/></tile>
              </condition>
              <condition type="if" field="High Priority Events" operator=">=" value="2">
                <tile color="#F44336" field="HP1"><title/></tile>
                <tile type="separator" display="vertical"/>
                <tile color="#F44336" field="HP2"><title/></tile>
              </condition>
              <condition type="if" field="High Priority Events" operator=">=" value="1">
                <tile color="#F44336" field="HP1"><title/></tile>
              </condition>
            </tile>
          </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant comporte plusieurs colonnes et graphiques dans certaines colonnes.

Requête :

Duration != null | eval D = unit(Duration, second) | link Time, Node | eval Fatal = 30 | eval Critical = 5 | eval Warning = 32 | eval Informational = 80 | eval App = unit(2.07, pct) | eval Database = unit(0, pct) | eval External = unit(97.93, pct) | timestats name = 'Request Response Time' avg(D) as 'Request Response Time' by Node | eventstats avg(D) as 'Avg. Response' | eval Calls = '3.18 / min' | eval Errors = unit(1.2, pct)

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles>
            <title>
              <title-text font-size="large">Alerts</title-text>
            </title>
            <tile font-size="medium" color="#F44336" field="Fatal">
              <title>
                <title-text font-size="medium" color="#90A4AE">Fatal</title-text>
              </title>
            </tile>
            <tile font-size="medium" color="#E57373" field="Critical">
              <title>
                <title-text font-size="medium" color="#90A4AE">Critical</title-text>
              </title>
            </tile>
            <tile font-size="medium" color="#FFEB3B" field="Warning">
              <title>
                <title-text font-size="medium" color="#90A4AE">Warning</title-text>
              </title>
            </tile>
            <tile font-size="medium" color="#3F51B5" field="Informational">
              <title>
                <title-text font-size="medium" color="#90A4AE">Informational</title-text>
              </title>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles layout="table" columns="1">
            <title>
              <title-text font-size="large">Request Response Time</title-text>
            </title>
            <tile field="Avg. Response"><title><title-text>Average Response Time</title-text></title></tile>
            <tile type="chart" chart-type="line">
              <chart-value field="Request Response Time">
                <chart-by-clause field="Node" value="10.20.10.244"/>
              </chart-value>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles layout="table" columns="3">
            <title>
              <title-text font-size="large">Node Average Response</title-text>
            </title>
            <tile field="App"><title><title-text>Application Server</title-text></title></tile>
            <tile field="Database"><title><title-text>Database</title-text></title></tile>
            <tile field="External"><title><title-text>External</title-text></title></tile>           
            <tile type="chart" chart-type="area">
              <chart-value field="Request Response Time">
                <chart-by-clause field="Node" value="10.20.10.244"/>
              </chart-value>
            </tile>
          </tiles>
        </column>      
        <column>
          <tiles layout="table" columns="2">
            <title></title>
            <tile field="Calls"/>
            <tile field="Errors"/>
            <tile type="chart" chart-type="bar">
              <chart-value field="Request Response Time">
                <chart-by-clause field="Node" value="10.20.10.244"/>
              </chart-value>
            </tile>           
          </tiles>
        </column>        
      </row>
    </table>
  </container>
</summary>

Dans l'exemple suivant, la valeur font-size est définie sur small pour le titre. Cela est utile pour créer une présentation réactive. L'attribut color est défini sur la valeur priority-high. Cette option affecte la même couleur que celle utilisée pour les libellés à priorité élevée.

Requête :

'Log Source' like 'Kubernetes %' | eval R = unit('Raw Size', byte) | link Node, Pod, cluster() | eventstats distinctcount(Node) as Nodes, distinctcount(Pod) as Pods, sum(Count) as Logs, sum(R) as Size | addfields [ * | where 'Potential Issue' = '1' | eventstats distinctcount('Cluster Sample') as I ], [ * | where Count = 1 and 'Potential Issue' != '1' | eventstats distinctcount('Cluster Sample') as O ] | eval O1 = if(O > 0, O, 0) | eventstats max(I) as Issues, max(O1) as Outliers | fields -I, -O, -O1, -'Cluster Sample', -'Potential Issue'

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles>
            <title font-size="small">Summary</title>
            <tile field="Nodes"/>
            <tile field="Pods"/>
          </tiles>
        </column>
        <column>
          <tiles>
            <title font-size="small">Usage</title>
            <tile field="Logs"/>
            <tile field="Size"/>
          </tiles>
        </column>
        <column>
          <tiles>
            <title font-size="small">Health</title>
            <tile color="priority-high" field="Issues"/>
            <tile field="Outliers"/>
          </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

Dans l'exemple suivant, l'icône de titre est utilisée à partir des images Oracle. La couleur de l'icône de titre est personnalisée.

Pour plus d'images d'icône, reportez-vous à Images Oracle.

Requête :

'Log Source' like 'Kubernetes %' | eval R = unit('Raw Size', byte) | link Node, Pod, cluster() | eventstats distinctcount(Node) as Nodes, distinctcount(Pod) as Pods, sum(Count) as Logs, sum(R) as Size | addfields [ * | where 'Potential Issue' = '1' | eventstats distinctcount('Cluster Sample') as I ], [ * | where Count = 1 and 'Potential Issue' != '1' | eventstats distinctcount('Cluster Sample') as O ] | eval O1 = if(O > 0, O, 0) | eventstats max(I) as Issues, max(O1) as Outliers | fields -I, -O, -O1, -'Cluster Sample', -'Potential Issue'

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles>
            <title font-size="small">Summary</title>
            <tile field="Nodes"/>
            <tile field="Pods"/>
          </tiles>
        </column>
        <column>
          <tiles>
            <title font-size="small">Usage</title>
            <tile field="Logs"/>
            <tile field="Size"/>
          </tiles>
        </column>
        <column>
          <tiles>
            <title>
              <title-icon color="#E32424">oj-ux-ico-warning-s</title-icon>          
              <title-text font-size="small">Health</title-text>
            </title> 
            <tile color="priority-high" field="Issues"/>
            <tile field="Outliers"/>
          </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant utilise l'option inline pour afficher le texte compact.

Requête :

'Log Source' like 'Kubernetes %' | eval R = unit('Raw Size', byte) | link Node, Pod, cluster() | eventstats distinctcount(Node) as Nodes, distinctcount(Pod) as Pods, sum(Count) as Logs, sum(R) as Size | addfields [ * | where 'Potential Issue' = '1' | eventstats distinctcount('Cluster Sample') as I ], [ * | where Count = 1 and 'Potential Issue' != '1' | eventstats distinctcount('Cluster Sample') as O ] | eval O1 = if(O > 0, O, 0) | eventstats max(I) as Issues, max(O1) as Outliers | fields -I, -O, -O1, -'Cluster Sample', -'Potential Issue'

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles>
            <title><title-text font-size="medium">Summary</title-text></title>
            <tile type="inline">
              <tile font-size="small" field="Pods"><text/></tile>
              <tile font-size="small" type="text" value=" Pods deployed on "><title/></tile>
              <tile font-size="small" field="Nodes"><title/></tile>
              <tile type="condition">
                <condition type="if" field="Nodes" operator=">" value="1">
                  <tile font-size="small" type="text" value=" Nodes"/>
                </condition>
                <condition type="else">
                  <tile font-size="small" type="text" value=" Node"/>
                </condition>
              </tile>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles>
            <title><title-text font-size="medium">Usage</title-text></title>
            <tile type="inline">
              <tile font-size="small" field="Logs"><text/></tile>
              <tile font-size="small" type="text" value=" Logs / "><title/></tile>
              <tile font-size="small" field="Size"><title/></tile>
            </tile>
          </tiles>
        </column>
        <column>
          <tiles>
            <title><title-text font-size="medium">Health</title-text></title>
            <tile type="inline">
              <tile font-size="small" color="priority-high" field="Issues"><text/></tile>
              <tile font-size="small" type="text" value=" Issues / "><title/></tile>
              <tile font-size="small" field="Outliers"><title/></tile>
              <tile font-size="small" type="text" value=" Outliers"><title/></tile>
            </tile>
          </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant présente une présentation verticale à l'aide d'icônes et de plusieurs graphiques.

Requête :

'Log Source' like 'Kubernetes%' and 'Kubernetes Cluster Name' = 'mushop app (skhu)' | eval NP = Node || Pod | eval 'Raw Size (byte)' = unit('Raw Size', byte) | link includenulls = true Time, 'Kubernetes Cluster Name', Namespace, NP, Deployment | stats unique(Node) as N1, unique(Pod) as P, sum('Raw Size (byte)') as S | eventstats distinctcount(Namespace) as NM, distinctcount(N1) as N2, distinctcount(Pod) as P, distinctcount(Deployment) as D, sum(Count) as Logs | eval Cluster = replace('Kubernetes Cluster Name', ' ', '%20') | oracle.logan.oke_demo_v2.build_urls('Nodes Drilldown', Nodes, Cluster, N2) | oracle.logan.oke_demo_v2.build_urls('Namespaces Drilldown', Namespaces, Cluster, NM) | oracle.logan.oke_demo_v2.build_urls('Pods Drilldown', Pods, Cluster, P) | oracle.logan.oke_demo_v2.build_urls('Deployments Drilldown', Deployments, Cluster, D) | timestats sum(Count) as 'Logs Trend', sum(S) as 'Log Size' | fields -N1, -N2, -NM, -P, -D, -NP, -S

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles layout="table" columns="1">
            <title>
              <title-text font-size="small">CLUSTER</title-text>
              <title-text> </title-text>
              <title-icon>oj-ux-ico-networking</title-icon>
            </title>
            <tile field="Namespaces">
              <title>
                <title-icon>oj-ux-ico-application-flower-variant</title-icon>
                <title-text> </title-text>
                <title-text>NAMESPACES</title-text>
              </title>
            </tile>
            <tile field="Deployments">
              <title>
                <title-icon>oj-ux-ico-deploy</title-icon>
                <title-text> </title-text>
                <title-text>DEPLOYMENTS</title-text>
              </title>
            </tile>
            <tile field="Nodes">
              <title>
                <title-icon>oj-ux-ico-laptop</title-icon>
                <title-text> </title-text>
                <title-text>NODES</title-text>
              </title>
            </tile>
            <tile field="Pods">
              <title>
                <title-icon color="#24E330">oj-ux-ico-check-circle-s</title-icon>
                <title-text> </title-text>
                <title-text>PODS</title-text>
              </title>
            </tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles layout="table" columns="1">
            <title>
              <title-text font-size="small">CONTROL PLANE</title-text>
              <title-text> </title-text>
              <title-icon>oj-ux-ico-game-controller</title-icon>
            </title>
            <tile field="Kubernetes Cluster Name">
              <title>
                <title-icon>oj-ux-ico-cluster</title-icon>
                <title-text> </title-text>
                <title-text>KUBERNETES CLUSTER</title-text>
              </title>
            </tile>
            <tile field="Logs">
              <title>
                <title-icon color="#E33524">oj-ux-ico-log</title-icon>
                <title-text> </title-text>
                <title-text>LOGS</title-text>
              </title>
            </tile>
            <tile type="separator" display="horizontal"/>
            <tile type="chart" chart-type="bar">
              <title align="bottom"><title-text>Log Trend</title-text></title>
              <chart-value field="Logs Trend"/>
            </tile>
            <tile type="separator" display="horizontal"/>            
            <tile type="chart" chart-type="area">
              <title align="bottom"><title-text>Log Size Trend</title-text></title>
              <chart-value field="Log Size"/>
            </tile>
          </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant présente des couleurs personnalisées. Les mosaïques cliquables sont développées pour afficher des informations supplémentaires.

Cliquez sur le nombre 3 sous Clusters pour développer :

Requête :

* | eval S = unit('Raw Size', byte) | link 'Log Source' | stats sum(S) as 'Log Source Size' | sort -'Log Source Size' | eventstats distinctcount('Log Source') as 'Log Sources', sum(S) as Size, sum(Count) as Records, earliest('Start Time') as 'First Log', latest('End Time') as 'Last Log', rownum as Row | addfields [ * | where Row = 1 | eventstats unique('Log Source') as L1 ], [ * | where Row = 2 | eventstats unique('Log Source') as L2 ], [ * | where Row = 3 | eventstats unique('Log Source') as L3 ] | eventstats unique(L1) as LS1, unique(L2) as LS2, unique(L3) as LS3 | fields -Row, -L1, -L2, -L3

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles background-color="#712D9B">
            <tile value="3" href="show(id=show-clusters)" color="#1D1D1D" font-size="large">
              <title>
                <title-icon font-size="large" color="#2D9B94">oj-ux-ico-cluster</title-icon>
                <title-text font-size="large">Clusters</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#69B069">
            <tile value="46" href="show(id=show-pods)" color="#1D1D1D" font-size="large">
              <title>
                <title-icon font-size="large" color="#9ADCE0">oj-ux-ico-component-block-container</title-icon>
                <title-text font-size="large">Pods</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#1D63CF">
            <tile value="32" href="show(id=show-deployments)" color="#1D1D1D" font-size="large">
              <title>
                <title-icon font-size="large" color="#9ADCE0">oj-ux-ico-copy-field-to</title-icon>
                <title-text font-size="large">Deployments</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#C9C53C">
            <tile value="19" href="show(id=show-namespaces)" color="#1D1D1D" font-size="large">
              <title>
                <title-icon font-size="large" color="#0823E4">oj-ux-ico-clipboard</title-icon>
                <title-text font-size="large">Namespaces</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#299988">
            <tile value="9.3M" href="show(id=show-logs)" color="#1D1D1D" font-size="large">
              <title>
                <title-icon font-size="large" color="#0841E4">oj-ux-ico-log</title-icon>
                <title-text font-size="large">Logs</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#7D1E28">
            <tile value="300" href="show(id=show-errors)" color="#1D1D1D" font-size="large">
              <title>
                <title-icon font-size="large" color="#0841E4">oj-ux-ico-error-s</title-icon>
                <title-text font-size="large">Errors</title-text>
              </title>
            </tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles background-color="#B197B3" id="show-clusters" hidden="true" layout="table" columns="5">
            <tile type="text" value="3">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-cluster</title-icon>
                <title-text font-size="medium">Clusters</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="22nd Feb 2023, 10:07pm PST">
              <title>
                <title-icon color="#248FE3">oj-ux-hcm-Growth_big_2x</title-icon>
                <title-text font-size="medium">Last Start Time</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="muShop Orders">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                <title-text font-size="medium">Last deployed Pod</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#9AB49B" id="show-pods" hidden="true" layout="table" columns="7">
            <tile type="text" value="46">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-component-block-container</title-icon>
                <title-text font-size="medium">Pods</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="3">
              <title>
                <title-icon color="#E3242D">oj-ux-ico-file-error</title-icon>
                <title-text font-size="medium" color="#E3242D">Pods with Errors</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="muShop Cart">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                <title-text font-size="medium">Recently Started Pod</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="muShop Test">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-git-parent-top</title-icon>
                <title-text font-size="medium">Recently Removed Pod</title-text>
              </title>
            </tile>
          </tiles>
          <tiles background-color="#9199DF" id="show-deployments" hidden="true" layout="table" columns="7">
            <tile type="text" value="32">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-copy-field-to</title-icon>
                <title-text font-size="medium">Deployments</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="expander">
             <tile background-color="#9199DF" value="muShop-orders-23jjsdkf8" href="show(id=deployment-fail-details, bounding-box=true, expand=bottom)">
              <title>
                <title-icon color="#248FE3">oj-ux-hcm-Growth_big_2x</title-icon>
                <title-text font-size="medium">Last Failed Deployment</title-text>
              </title>
              </tile>
              <expandtiles background-color="#9199DF" id="deployment-fail-details">
                <tile background-color="#9199DF" type="text" value="22nd Feb 2023 9:02am PST">
                  <title>
                    <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                    <title-text font-size="medium">Failed at</title-text>
                  </title>
                </tile>
                <tile type="separator" display="vertical"/>
                <tile background-color="#9199DF" type="text" value="2400">
                  <title>
                    <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                    <title-text font-size="medium">Number of users at this time</title-text>
                  </title>
                </tile>
                <tile type="separator" display="vertical"/>
                <tile background-color="#9199DF" type="text" value="83%">
                  <title>
                    <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                    <title-text font-size="medium">Load average at this time</title-text>
                  </title>
                </tile>
                <tile type="separator" display="vertical"/>
               </expandtiles>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="13">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                <title-text>Active Deployments</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="4">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-git-parent-top</title-icon>
                <title-text font-size="medium">Deployment Types</title-text>
              </title>
            </tile>
            </tiles>
          <tiles background-color="#DFDD91" id="show-namespaces" hidden="true" layout="table" columns="5">
            <tile type="text" value="19">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-clipboard</title-icon>
                <title-text font-size="medium">Namespaces</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="default">
              <title>
                <title-icon color="#248FE3">oj-ux-hcm-Growth_big_2x</title-icon>
                <title-text font-size="medium">Recent Namespace</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="muShop / 20">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                <title-text font-size="medium">Namespace with most Pods</title-text>
              </title>
            </tile>
            </tiles>
          <tiles background-color="#93DF91" id="show-logs" hidden="true" layout="table" columns="9">
            <tile type="text" value="9392348">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-log</title-icon>
                <title-text font-size="medium">Records</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="1.5TB">
              <title>
                <title-icon color="#248FE3">oj-ux-hcm-Growth_big_2x</title-icon>
                <title-text font-size="medium">Size</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="13">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-resource-service</title-icon>
                <title-text font-size="medium">Log Sources</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="4">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-git-parent-top</title-icon>
                <title-text font-size="medium">Entity Types</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="278">
              <title>
                <title-icon color="#248FE3">oj-ux-ico-book</title-icon>
                <title-text font-size="medium">Entities</title-text>
              </title>
            </tile>
            </tiles>
          <tiles background-color="#DA6868" id="show-errors" hidden="true" layout="table" columns="5">
            <tile type="text" value="300">
              <title>
                <title-icon color="#E3242D">oj-ux-ico-error-s</title-icon>
                <title-text font-size="medium" color="#E3242D">Errors</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="20">
              <title>
                <title-icon color="#E37E24">oj-ux-hcm-Growth_big_2x</title-icon>
                <title-text font-size="medium" color="#E37E24">Warnings</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="text" value="Socket Timedout">
              <title>
                <title-icon color="oj-ux-ico-error-s">oj-ux-ico-resource-service</title-icon>
                <title-text font-size="medium">Most Frequent Error</title-text>
              </title>
            </tile>
            </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>

L'exemple suivant présente des mosaïques cliquables, des icônes avec des couleurs personnalisées et des liens.

Cliquez sur 4 pour visualiser des détails supplémentaires :

Cliquez sur les catégories 2 pour afficher les tendances des catégories :

Requête :

'Log Source' = 'OCI Email Delivery Logs' | link 'Message ID', Action | stats unique(Type) as Type, unique('Error Text') as Error, unique('Event Category') as Category, unique('From (Email)') as Sender | addfields [ * | where Action = accept | eventstats sum(Count) as A1 ], [ * | where Error != null | eventstats count as ED1, distinctcount('Event Category') as EC1 ], [ * | where Action = literal(relay) | eventstats count as D1 ], [ * | where Action = bounce | eventstats count as B1 ], [ * | where Action = bounce and Error = soft | eventstats count as SB1 ], [ * | where Action = bounce and Error = hard | eventstats count as HB1 ], [ * | where Action = complaint | eventstats count as C1 ] | addfields [ * | where Category != null | timestats sum(Count) as 'Bounce Trend' ], [ * | where Category != null | timestats name = 'Bounce Categories' sum(Count) as 'Bounce Categories' by Category ] | eventstats max(A1) as A2, max(D1) as D2, max(B1) as B2, max(ED1) as ED2, max(SB1) as SB2, max(HB1) as HB2, max(C1) as C2, max(EC1) as Categories | eval Accepted = if(A2 >= 0, A2, 0) | eval Delivered = if(D2 >= 0, D2, 0) | eval 'Delivered %' = unit(round(100 / (Accepted / Delivered), 2), pct) | eval Bounced = if(B2 >= 0, B2, 0) | eval Complaints = if(C2 >= 0, C2, 0) | eval 'Bounced %' = unit(round(100 / (Accepted / Bounced), 2), pct) | eval 'Complaints %' = unit(round(100 / (Accepted / Complaints), 2), pct) | eval 'Soft Bounces' = if(SB2 >= 0, SB2, 0) | eval 'Hard Bounces' = if(HB2 >= 0, HB2, 0) | eval 'Soft Bounces %' = unit(round(100 / (Accepted / 'Soft Bounces'), 2), pct) | eval 'Hard Bounces %' = unit(round(100 / (Accepted / 'Hard Bounces'), 2), pct) | eval 'Error Delivery' = if(ED2 >= 0, ED2, 0) | eval 'Error Delivery %' = unit(round(100 / (Accepted / 'Error Delivery'), 2), pct) | fields -A1, -A2, -D1, -D2, -ED1, -ED2, -B1, -B2, -SB1, -SB2, -HB1, -HB2, -C1, -C2, -EC1

Définition XML :

<summary>
  <container display="none">
    <table>
      <row>
        <column>
          <tiles>
            <tile font-size="large" field="Accepted">
              <title>
                <title-text font-size="medium">Accepted</title-text>
              </title>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="condition">
              <condition type="if" field="Error Delivery" operator=">" value="0">
                <tile type="inline">
                  <title> 
                    <title-icon font-size="medium" color="#F4511E">oj-ux-ico-warning-s</title-icon>
                    <title-text font-size="medium" color="#F4511E">Suppressed</title-text>
                  </title>
                  <tile font-size="large" field="Error Delivery"/>
                  <tile value=" "/>
                  <tile font-size="large" type="separator" display="vertical"/>
                  <tile value=" "/>
                  <tile font-size="small" field="Error Delivery %"/>
                  <tile font-size="small" value=" of the Emails accepted"/>
                </tile>
              </condition>
              <condition type="else">
                <tile font-size="large" color="#558B2F" value="None">
                  <title>
                    <title-icon font-size="medium" color="#558B2F">oj-ux-ico-check-circle</title-icon>
                    <title-text font-size="medium">Suppressed</title-text>
                  </title>
                </tile>
              </condition>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="inline">
              <title>
                <title-text font-size="medium">Relayed</title-text>
              </title>
              <tile font-size="large" field="Delivered"/>
              <tile value=" "/>
              <tile font-size="large" type="separator" display="vertical"/>
              <tile value=" "/>
              <tile font-size="small" field="Delivered %"/>
              <tile font-size="small" value=" of the Emails accepted"/>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="condition">
              <condition type="if" field="Bounced" operator=">" value="0">
                <tile type="inline">
                  <title>
                    <title-icon font-size="medium" color="#F4511E">oj-ux-ico-warning-s</title-icon>
                    <title-text font-size="medium" color="#F4511E">Bounced</title-text>
                  </title>
                  <tile font-size="large" field="Bounced" href="show(id=bounce-details)"/>
                  <tile value=" "/>
                  <tile type="separator" display="vertical"/>
                  <tile value=" "/>
                  <tile font-size="small" field="Bounced %"/>
                  <tile value=" "/>
                  <tile type="separator" display="vertical"/>
                  <tile value=" "/>
                  <tile font-size="small" field="Categories" href="show(id=bounce-category-trend)"/>
                  <tile font-size="small" value=" Categories"/>
                </tile>
              </condition>
              <condition type="else">
                <tile font-size="large" color="#558B2F" value="None">
                  <title>
                    <title-icon font-size="medium" color="#558B2F">oj-ux-ico-check-circle</title-icon>
                    <title-text font-size="medium">Bounced</title-text>
                  </title>
                </tile>
              </condition>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="condition">
              <condition type="if" field="Complaints" operator=">" value="0">
                <tile type="inline">
                  <title> 
                    <title-icon font-size="medium" color="#F4511E">oj-ux-ico-warning-s</title-icon>
                    <title-text font-size="medium" color="#F4511E">Complaints</title-text>
                  </title>
                  <tile font-size="large" field="Complaints"/>
                  <tile value=" "/>
                  <tile font-size="large" type="separator" display="vertical"/>
                  <tile value=" "/>
                  <tile font-size="small" field="Complaints %"/>
                </tile>
              </condition>
              <condition type="else">
                <tile font-size="large" color="#558B2F" value="None">
                  <title>
                    <title-icon font-size="medium" color="#558B2F">oj-ux-ico-check-circle</title-icon>
                    <title-text font-size="medium">Complaints</title-text>
                  </title>
                </tile>
              </condition>
            </tile>
          </tiles>         
        </column>
      </row>
      <row>
        <column>
          <tiles id="bounce-details" hidden="true">
            <tile type="inline">
              <title>
                <title-text font-size="medium">Soft Bounces</title-text>
              </title>
              <tile font-size="large" field="Soft Bounces"/>
              <tile value=" "/>
              <tile font-size="large" type="separator" display="vertical"/>
              <tile value=" "/>
              <tile font-size="small" field="Soft Bounces %"/>
              <tile font-size="small" value=" of the Emails accepted"/>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="inline">
              <title>
                <title-text font-size="medium">Hard Bounces</title-text>
              </title>
              <tile font-size="large" field="Hard Bounces"/>
              <tile value=" "/>
              <tile font-size="large" type="separator" display="vertical"/>
              <tile value=" "/>
              <tile font-size="small" field="Hard Bounces %"/>
              <tile font-size="small" value=" of the Emails accepted"/>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile value=" "/>
            <tile type="chart" chart-type="sparkline">
              <title>
                <title-text font-size="medium">Bounce Trend</title-text>
              </title>
              <chart-value field="Bounce Trend"/>
            </tile>
          </tiles>
        </column>
      </row>
      <row>
        <column>
          <tiles id="bounce-category-trend" hidden="true">
            <title>
              <title-icon font-size="medium" color="#558B2F">oj-ux-ico-chart-line</title-icon>
              <title-text font-size="medium">Bounce Trend</title-text>
            </title>
            <tile type="chart" chart-type="sparkline">
              <title>
                <title-text font-size="medium">Bad Mailbox</title-text>
              </title>
              <chart-value field="Bounce Categories">
                <chart-by-clause field="Category" value="bad-mailbox"/>
              </chart-value>
            </tile>
            <tile type="separator" display="vertical"/>
            <tile type="chart" chart-type="sparkline">
              <title>
                <title-text font-size="medium">Policy Related</title-text>
              </title>
              <chart-value field="Bounce Categories">
                <chart-by-clause field="Category" value="policy-related"/>
              </chart-value>
            </tile>
          </tiles>
        </column>
      </row>
    </table>
  </container>
</summary>