.. Reminder for header structure:
  Parts (H1)          : #################### with overline
  Chapters (H2)       : ******************** with overline
  Sections (H3)       : ====================
  Subsections (H4)    : --------------------
  Subsubsections (H5) : ^^^^^^^^^^^^^^^^^^^^
  Paragraphs (H6)     : """"""""""""""""""""

.. meta::
  :description: Documentation version 2.6 WAPT Using the WAPT Console advanced features
  :keywords: WAPT, advanced, features, documentation.

.. |ok| image:: wapt-resources/icon-ok.png
  :scale: 5%
  :alt: Feature available

.. |nok| image:: wapt-resources/icon-nok.png
  :scale: 5%
  :alt: Feature not available

.. _wapt_reporting:

##########################################################
Using the reporting functions in WAPT |enterprise_feature|
##########################################################

*****************
Working principle
*****************

.. youtube:: UjBfelmJyKo
   :align: center
   :width: 50%

WAPT **Enterprise** offers advanced reporting capabilities.

Indeed, you are best to know what you want in your reports.

With WAPT you can write your own SQL queries in the WAPT Console, or you can download ready-to-run queries from Internet.

You can get the latest db structure diagram from the package `tis-db-structure-diagram-wapt <https://wapt.tranquil.it/store/fr/tis-db-structure-diagram-wapt>`_. Once the package is installed, you will find different formats of the diagram in :file:`C:/Program Files (x64)/wapt\dbdiagram` (Windows) or :file:`/opt/wapt/dbdiagram` (Linux, MacOS).

*******************
WAPT Query Designer
*******************

The query designer allows to edit and run SQL queries on the WAPT Server PostgreSQL database.

.. note::

  The PostgreSQL database is set to **Read-Only** mode, so queries run from the Report Designer that attempt to update, delete or insert data will fail.


You can import SQL queries from the Tranquil IT store by clicking on :menuselection:`Reporting --> Import queries... --> From Url` or on :menuselection:`Reporting --> Import queries... --> From File`.

.. figure:: wapt-resources/wapt_console-reporting-import-query.png
  :align: center
  :alt: Importing a SQL query report in the WAPT Console

  Importing a SQL query report in the WAPT Console

If you choose to import a query from the Tranquil IT store, select one or several queries, then click on :guilabel:`Save selected queries`.
The new queries will appear in the  WAPT Console.

.. figure:: wapt-resources/wapt_console-reporting-import-query-from-store.png
  :align: center
  :scale: 75%
  :alt: Importing a SQL query report in the WAPT Console from a URL

  Importing a SQL query report in the WAPT Console from a URL

If you import a query from a file, select your query from the file explorer.
The query can be either a :mimetype:`.query` or a :mimetype:`.json` formated file.

.. figure:: wapt-resources/wapt_console-reporting-import-query-from-file.png
  :align: center
  :scale: 75%
  :alt: Importing a SQL query report in the WAPT Console from a file

  Importing a SQL query report in the WAPT Console from a file

.. note::

  Irrelevant of the method you use to import queries, remember to click on the button :guilabel:`Save Queries` to save the imported queries.

To create a new SQL report, click on :menuselection:`Reporting --> Design Mode --> New query`.

.. figure:: wapt-resources/wapt_console_sql-report-designer_container-window.png
  :align: center
  :scale: 75%
  :alt: Designing a SQL query report in the WAPT Console

  Designing a SQL query report in the WAPT Console

.. hint::

 * To rename a query, select the query and press the :kbd:`F2` key.

 * In the top banner, you can write your SQL query.

To edit / modify / save your reports:

* The :guilabel:`Refresh` button is used to reload queries saved on the WAPT Server, for example, if a colleague has just edited a new query.

* The :guilabel:`New query` button adds a new blank query to the list.

* The :guilabel:`Delete query` button deletes the selected query from the WAPT Server.

* The :guilabel:`Save queries` button saves the query on the WAPT Server.

* The :guilabel:`Execute` button executes the selected query.

* The :guilabel:`Export to spreadsheet` button exports the result of your query to a spreadsheet.
  The button is enabled only in edit mode.

* The :guilabel:`Duplicate` button duplicates an existing query to avoid writing a SQL query from scratch.
  The button is enabled only in edit mode.

You have several options available when you right click on a query.

.. figure:: wapt-resources/wapt_console_sql-report-query-options.png
  :align: center
  :scale: 75%
  :alt: Options available for a SQL query report in the WAPT Console

  Options available for a SQL query report in the WAPT Console

.. list-table:: List of actions available on a selection of query on WAPT Console
  :header-rows: 1
  :widths: auto

  * - Name
    - Description
  * - :guilabel:`Execute`
    - Executes the SQL query.
  * - :guilabel:`Edit`
    - Edits the SQL query.
  * - :guilabel:`Edit Name`
    - Edits the name of the SQL query.
  * - :guilabel:`Export to spreadsheet`
    - Exports the result of the SQL query to a :mimetype:`csv` formatted file.
  * - :guilabel:`Duplicate`
    - Duplicates the SQL query.
  * - :guilabel:`Export queries to file...`
    - Exports the selected SQL queries to a file.
      This method allows to share or backup the SQL queries.
  * - :guilabel:`Import queries...`
    - Imports queries from a file.
  * - :guilabel:`Delete queries`
    - Deletes the selected queries.

.. note::

 * SQL queries are saved in the PostgreSQL WAPT database.

 * Using :kbd:`CTRL+space` allows to build queries more effectively as it will auto-complete some fields.

**********************************************
Using queries as a filter in the inventory tab
**********************************************

You can create a filter for use in the :guilabel:`Inventory` tab based on a SQL query.
You need to add an UUID column, is absolutely necessary in the query results.

In this exemple, we use a query which lists hosts onto which the 7zip software has been installed.

.. hint::

  This method is powerful because it allows to seach search for software that have not been installed using WAPT.

Do a right-click on the query result and click on the :guilabel:`Choose as Host UUID` button.
On the query result, right-click on :guilabel:`host_id`, which is a unique identifier, select this entry and click on the :guilabel:`Choose as Host UUID` button.

.. figure:: wapt-resources/wapt_console_sql-report-query-host-uuid.png
  :align: center
  :alt: Querying on host UUID to create a dynamic view in the inventory tab

  Querying on host UUID to create a dynamic view in the inventory tab

When done, save the query by pressing the :guilabel:`Save query` button then go to the :guilabel:`Main Inventory` tab.

Then, enable the :guilabel:`Advanced Search` panel and select the query in the drop-down field :guilabel:`Filter hosts on SQL query`.

.. figure:: wapt-resources/wapt_console_sql-report-host-uuid-inventory.png
  :align: center
  :alt: Filtering the host inventory using a SQL query

  Filtering the host inventory using a SQL query

You will then see a host list based on the selected query.

.. note::

  It is also possible to click on the "Show selected machines in inventory" button by right-clicking after selecting one or more machines appearing in the result of your query.

  Prior to this, it is necessary to click on "Choose as hosts UUID".

**************
Query examples
**************

Computers query
===============

.. tabs::

  .. code-tab:: sql Counting hosts

    select count(*) as "number_of_hosts" from hosts

  .. code-tab:: sql Listing computers

    select
    computer_name,
    os_name,
    os_version,
    os_architecture,
    serialnr
    from hosts
    order by 4,3,1

  .. code-tab:: sql Listing computers MAC addresses and IP

    select distinct unnest(mac_addresses) as mac,
    unnest(h.connected_ips) as ipaddress,
    computer_fqdn,h.description,
    h.manufacturer||' '||h.productname as model,
    h.serialnr,
    h.computer_type
    from hosts h
    order by 1,2,3

.. tabs::

  .. code-tab:: sql Listing Windows versions

    select
    host_info->'windows_version' as windows_version,
    os_name as operating_system,
    count(os_name) as nb_hosts
    from hosts
    group by 1,2

  .. code-tab:: sql Listing operating systems

    select host_info->'windows_version' as windows_version,
    os_name as "Operating_System",
    count(os_name) as "number_of_hosts"
    from hosts
    group by 1,2

  .. code-tab:: sql Listing hosts not seen in a while

    select
    h.uuid,
    h.computer_fqdn,
    install_date::date,
    version,
    h.last_seen_on::timestamp,
    h.connected_users from hostsoftwares s
    left join hosts h on h.uuid=s.host_id
    where s.key='WAPT_is1'
    and h.last_seen_on<'20190115'

.. tabs::

  .. code-tab:: sql Filtering hosts by chassis types

    select case
    dmi->'Chassis_Information'->>'Type'
    when 'Portable' then '01-Laptop'
    when 'Notebook' then '01-Laptop'
    when 'Laptop' then '01-Laptop'
    when 'Desktop' then '02-Desktop'
    when 'Tower' then '02-Desktop'
    when 'Mini Tower' then '02-Desktop'
    else '99-'||(dmi->'Chassis_Information'->>'Type')
    end as type_chassis,
    string_agg(distinct coalesce(manufacturer,'?') ||' '|| coalesce(productname,''),', '),
    count(*) as "number_of_hosts" from hosts
    group by 1

  .. code-tab:: sql Listing of hosts with their Windows Serial Key

    select
    computer_name,
    os_name,
    os_version,
    host_info->'windows_product_infos'->'product_key' as windows_product_key
    from hosts
    order by 3,1

WAPT query
==========

.. tabs::

  .. code-tab:: sql Listing WAPT packages in the WAPT Server repository

    select
    package,
    version,
    architecture,
    description,
    section,
    package_uuid,
    count(*)
    from packages
    group by 1,2,3,4,5,6

  .. code-tab:: sql Listing hosts needing upgrade

    select
    computer_fqdn,
    host_status,
    last_seen_on::date,
    h.wapt_status,
    string_agg(distinct lower(s.package),' ')
    from hosts h
    left join hostpackagesstatus s on s.host_id=h.uuid and s.install_status != 'OK'
    where (last_seen_on::date > (current_timestamp - interval '1 week')::date
    and host_status!='OK')
    group by 1,2,3,4

Packages query
==============

.. tabs::

  .. code-tab:: sql Listing packages with their number of installation

    select
    package,
    version,
    architecture,
    description,
    section,
    package_uuid,
    count(*)
    from hostpackagesstatus s
    where section not in ('host','unit','group')
    group by 1,2,3,4,5,6

Software query
==============

.. tabs::

  .. code-tab:: sql Listing WAPT Discovery Agents

    select
    h.uuid,
    h.computer_name,
    install_date::date,
    version,
    h.listening_timestamp::timestamp,
    name
    from hostsoftwares s
    left join hosts h on h.uuid=s.host_id
    where
    s.key='WAPT_is1'
    and (name ilike 'WAPT%%Discovery%%' or name ilike 'WAPT %%')

  .. code-tab:: sql Listing hosts with their 7zip version associated

    select
    hosts.computer_name,
    hostsoftwares.host_id,
    hostsoftwares.name,
    hostsoftwares.version
    from hosts, hostsoftwares
    where hostsoftwares.name ilike '7-zip%%'
    and hosts.uuid=hostsoftwares.host_id
    order by hosts.computer_name asc

  .. code-tab:: sql Listing hosts with their software

    select
    n.normalized_name,
    s.version,string_agg(distinct lower(h.computer_name),' '),
    count(distinct h.uuid)
    from hostsoftwares s
    left join normalization n on (n.original_name = s.name) and (n.key = s.key)
    left join hosts h on h.uuid = s.host_id
    where (n.normalized_name is not null)
    and (n.normalized_name<>'')
    and not n.windows_update
    and not n.banned
    and (last_seen_on::date > (current_timestamp - interval '3 week')::date)
    group by 1,2

  .. code-tab:: sql Listing normalized software

    select
    n.normalized_name,
    string_agg(distinct lower(h.computer_name),' '),
    count(distinct h.uuid)
    from hostsoftwares s
    left join normalization n on (n.original_name = s.name) and (n.key = s.key)
    left join hosts h on h.uuid = s.host_id
    where (n.normalized_name is not null)
    and (n.normalized_name<>'')
    and not n.windows_update
    and not n.banned
    and (last_seen_on::date > (current_timestamp - interval '3 week')::date)
    group by 1

You can also find several more examples of queries on `Tranquil IT's Forum <https://forum.tranquil.it/viewforum.php?f=18&sid=b2a0081dd9a8adb5c57386974d691c6d>`_.

Feel free to post your own queries on the forum with an explanation of what your query does, ideally with a screen capture or a table showing a sample of your query result.

.. _normalizing_software_names:

**************************
Normalizing software names
**************************

Sometimes, the version of the software or its architecture are an integral part of the software name.
When the software titles register with the WAPT Server inventory, they appear as different software titles whereas they are just one software for us humans.

To solve this problem, the name of software titles can be standardized in WAPT.
Go to the :guilabel:`Softwares Inventory` tab.

.. figure:: wapt-resources/wapt_console_sql-report-normalize_container-window.png
  :align: center
  :alt: Normalizing the name of software titles in the WAPT Console

  Normalizing the name of software titles in the WAPT Console

* Click :guilabel:`Normalize Software Names` in the :guilabel:`Tools` menu.

* Select the software titles whose names to standardize, for example, all different versions of Adobe Flash Player.

* On the column :guilabel:`normalized`, press :kbd:`F2` to assign a standardized name to the selected software titles.
  Finally press :kbd:`Enter` to save the changes.

.. note::

  * To select several software titles, select them with the :kbd:`shift-up/down` key combination.

  * You can also indicate a software like *windows update* or *banned* (press :kbd:`spacebar` in the corresponding column).

* Press on the :guilabel:`Save Modifications` button to upload the changes onto the WAPT Server.

You can now run queries using this standardized name.

.. hint:: 

  The :guilabel:`Show host` checkbox allows to see the software titles that are installed on the hosts.

  .. figure:: wapt-resources/wapt_console_normalize_container-window-show-host.png
    :align: center
    :scale: 75%
    :alt: Showing hosts with selected software in the Software Inventory tab

    Showing hosts with selected software in the Software Inventory tab

Using normalized software titles as a filter in the inventory tab
=================================================================

You can create a filter in the :guilabel:`Main Inventory` tab that uses the normalized software title names.
To do so, normalize the software title names in :guilabel:`Software Inventory` then select one or several hosts.
In the :guilabel:`Software inventory` tab of the selected hosts, drag and drop the software in the inventory list, it will create a view.

.. hint::

  This method is powerful because it allows to seach search for software titles that have not been installed using WAPT.

  Do not forget to normalize software titles beforehand.

  .. figure:: wapt-resources/wapt_console_sql-report-normalize-software-example.png
    :align: center
    :alt: Defining a normalized software title name

    Defining a normalized software title name


  .. only:: html

    .. figure:: wapt-resources/wapt_console_sort-normalized-software-inventory.gif
      :align: center
      :alt: Adding a normalized software title name to the software inventory for the selected hosts

      Adding a normalized software title name to the software inventory for the selected hosts

  You will see a host list sorted according to the normalized software title name.

*********************************************************
Connecting to the WAPT database using a PostgreSQL client
*********************************************************

You can connect a PostgreSQL client to the WAPT database if you prefer to use a PostgreSQL client.

To do so, you will have to change some configuration files on your WAPT Server.

* First, find the version of your PostgreSQL database.

.. code-block:: bash

  ps -ef | grep -i sql
  postgres   512     1  0 Jan05 ?        00:00:24 /usr/lib/postgresql/15/bin/postgres -D /var/lib/postgresql/15/main -c config_file=/etc/postgresql/15/main/postgresql.conf


* Modify :file:`pg_hba.conf` of the PostgreSQL version in use.
  In :file:`/etc/postgresql/15/main/pg_hba.conf` for Debian and :file:`/var/lib/pgsql/15/data/pg_hba.conf` for RedHat and derivatives, add the IP address of the PostgreSQL client under **# IPv4 local connections section**.

.. code-block:: ini

  host    wapt             all             192.168.0.65/32              md5

  where 192.168.0.65 is your IP address that is authorized
  to connect to the WAPT database.

* Allow PostgreSQL to listen on every interface in :file:`/etc/postgresql/15/main/postgresql.conf` for Debian and :file:`/var/lib/pgsql/15/data/postgresql.conf` for RedHat and derivatives, section **Connection Settings**.

.. code-block:: bash

  listen_addresses = '*'

* Restart the service for your PostgreSQL version.

.. code-block:: bash

  systemctl restart postgresql@12-main.service

* Connect to PostgreSQL on the WAPT Server.

.. code-block:: bash

  sudo -u postgres psql wapt

* Then give a password to the *wapt* user.

.. code-block:: sql

  wapt=# ALTER USER wapt WITH PASSWORD 'PASSWORD';


.. blue_toggle::
  :titleen: Example Grafana Dashboard for WAPT
  :titlefr: Exemple de tableau de bord Grafana pour WAPT

  .. code-block::

    {
      "apiVersion": "dashboard.grafana.app/v2",
      "kind": "Dashboard",
      "metadata": {
        "name": "adc6lwq",
        "namespace": "default",
        "uid": "b039ce16-9e11-4ea2-92ce-50b7faafbb43",
        "resourceVersion": "1782302720169013",
        "generation": 64,
        "creationTimestamp": "2026-05-26T15:00:04Z",
        "labels": {
          "grafana.app/deprecatedInternalID": "1143436040355840"
        },
        "annotations": {
          "grafana.app/createdBy": "user:efmppjwoz6ha8c",
          "grafana.app/folder": "",
          "grafana.app/saved-from-ui": "Grafana v13.0.2 (3fcdbc5a)",
          "grafana.app/updatedBy": "user:efmppjwoz6ha8c",
          "grafana.app/updatedTimestamp": "2026-06-24T12:05:20Z"
        }
      },
      "spec": {
        "annotations": [
          {
            "kind": "AnnotationQuery",
            "spec": {
              "query": {
                "kind": "DataQuery",
                "group": "grafana",
                "version": "v0",
                "datasource": {
                  "name": "-- Grafana --"
                },
                "spec": {}
              },
              "enable": true,
              "hide": true,
              "iconColor": "rgba(0, 211, 255, 1)",
              "name": "Annotations & Alerts",
              "builtIn": true
            }
          }
        ],
        "cursorSync": "Off",
        "description": "Bandeau 1",
        "editable": true,
        "elements": {
          "panel-10": {
            "kind": "Panel",
            "spec": {
              "id": 10,
              "title": "Répartion des hôtes par statut",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    CASE\r\n        WHEN host_status = 'OK' THEN 'OK'\r\n        WHEN host_status = 'TO-UPGRADE' THEN 'En attente upgrade'\r\n        WHEN host_status = 'ERROR' THEN 'En erreur'\r\n        ELSE 'Hors ligne'\r\n    END AS status,\r\n    COUNT(*) AS total\r\nFROM hosts\r\nGROUP BY status\r\nORDER BY total DESC;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "piechart",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "displayLabels": [
                      "percent"
                    ],
                    "legend": {
                      "displayMode": "list",
                      "placement": "right",
                      "showLegend": true
                    },
                    "pieType": "donut",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "sort": "desc",
                    "tooltip": {
                      "hideZeros": false,
                      "mode": "single",
                      "sort": "none"
                    }
                  },
                  "fieldConfig": {
                    "defaults": {
                      "color": {
                        "mode": "palette-classic"
                      },
                      "custom": {
                        "hideFrom": {
                          "legend": false,
                          "tooltip": false,
                          "viz": false
                        }
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "En attente upgrade"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "yellow",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "OK"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "green",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-11": {
            "kind": "Panel",
            "spec": {
              "id": 11,
              "title": "répartition des machines par tranche d'espace libre",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    CASE\r\n        WHEN free_percent < 15 THEN '0-14%'\r\n        WHEN free_percent < 30 THEN '15-29%'\r\n        WHEN free_percent < 50 THEN '30-49%'\r\n        WHEN free_percent < 75 THEN '50-74%'\r\n        ELSE '75-100%'\r\n    END AS tranche,\r\n    COUNT(*) AS machines\r\nFROM (\r\n    SELECT\r\n        (\r\n            (host_metrics->'local_drives'->'C'->'FreeSpace')::float\r\n            /\r\n            NULLIF((host_metrics->'local_drives'->'C'->'Size')::float, 0)\r\n        ) * 100 AS free_percent\r\n    FROM hosts\r\n    WHERE os_name ~ 'Windows'\r\n      AND host_metrics->'local_drives'->'C' IS NOT NULL\r\n) t\r\nGROUP BY tranche;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "piechart",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "displayLabels": [
                      "percent"
                    ],
                    "legend": {
                      "displayMode": "table",
                      "placement": "right",
                      "showLegend": true,
                      "values": []
                    },
                    "pieType": "donut",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "sort": "desc",
                    "tooltip": {
                      "hideZeros": false,
                      "mode": "single",
                      "sort": "none"
                    }
                  },
                  "fieldConfig": {
                    "defaults": {
                      "color": {
                        "mode": "palette-classic"
                      },
                      "custom": {
                        "hideFrom": {
                          "legend": false,
                          "tooltip": false,
                          "viz": false
                        }
                      },
                      "fieldMinMax": false
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byFrameRefID"
                        },
                        "properties": []
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "15-29%"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "red",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "30-49%"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "orange",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "50-74%"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "yellow",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "__systemRef": "hideSeriesFrom",
                        "matcher": {
                          "id": "byNames",
                          "options": {
                            "mode": "exclude",
                            "names": [
                              "machines"
                            ],
                            "prefix": "All except:",
                            "readOnly": true
                          }
                        },
                        "properties": [
                          {
                            "id": "custom.hideFrom",
                            "value": {
                              "legend": false,
                              "tooltip": true,
                              "viz": true
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-12": {
            "kind": "Panel",
            "spec": {
              "id": 12,
              "title": "Liste des systèmes d'informations",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    os_name AS \"Operating_System\",\r\n    COUNT(*) AS \"Nb_Machines\"\r\nFROM hosts\r\nGROUP BY os_name\r\nORDER BY COUNT(*) DESC;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "piechart",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "displayLabels": [
                      "percent"
                    ],
                    "legend": {
                      "displayMode": "list",
                      "placement": "right",
                      "showLegend": true
                    },
                    "pieType": "donut",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "sort": "desc",
                    "tooltip": {
                      "hideZeros": false,
                      "mode": "single",
                      "sort": "none"
                    }
                  },
                  "fieldConfig": {
                    "defaults": {
                      "color": {
                        "mode": "palette-classic"
                      },
                      "custom": {
                        "hideFrom": {
                          "legend": false,
                          "tooltip": false,
                          "viz": false
                        }
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "Windows 11 Pro"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "blue",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "debian"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "orange",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "almalinux"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "purple",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-13": {
            "kind": "Panel",
            "spec": {
              "id": 13,
              "title": "Total agents WUA",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "",
                          "version": "v0",
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT COUNT(*) AS nb_postes_wua\r\nFROM hosts\r\nWHERE waptwua_status IS NOT NULL;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "auto",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [
                        "lastNotNull"
                      ],
                      "fields": "",
                      "values": false
                    },
                    "showPercentChange": false,
                    "textMode": "auto",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "fixed",
                        "fixedColor": "blue"
                      }
                    },
                    "overrides": []
                  }
                }
              }
            }
          },
          "panel-14": {
            "kind": "Panel",
            "spec": {
              "id": 14,
              "title": "Répartition des statuts WUA des hôtes",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    CASE\r\n        WHEN waptwua_status->>'status' = 'OK' THEN 'OK'\r\n        WHEN waptwua_status->>'status' = 'NEED-SCAN' THEN 'Scan requis'\r\n        WHEN waptwua_status->>'status' = 'PENDING_REBOOT' THEN 'Redémarrage requis'\r\n        WHEN waptwua_status->>'status' = 'NEED-INSTALL' THEN 'Installation requise'\r\n        WHEN waptwua_status->>'status' = 'ERROR' THEN 'Erreur'\r\n    END AS status,\r\n    COUNT(*) AS total\r\nFROM hosts\r\nWHERE waptwua_status->>'status' IN (\r\n    'OK',\r\n    'NEED-SCAN',\r\n    'PENDING_REBOOT',\r\n    'NEED-INSTALL',\r\n    'ERROR'\r\n)\r\nGROUP BY status\r\nORDER BY total DESC;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "piechart",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "displayLabels": [
                      "percent"
                    ],
                    "legend": {
                      "displayMode": "list",
                      "placement": "right",
                      "showLegend": true
                    },
                    "pieType": "donut",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "sort": "desc",
                    "tooltip": {
                      "hideZeros": false,
                      "mode": "single",
                      "sort": "none"
                    }
                  },
                  "fieldConfig": {
                    "defaults": {
                      "color": {
                        "mode": "palette-classic"
                      },
                      "custom": {
                        "hideFrom": {
                          "legend": false,
                          "tooltip": false,
                          "viz": false
                        }
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "Scan requis"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "yellow",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "Redémarrage requis"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "blue",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-18": {
            "kind": "Panel",
            "spec": {
              "id": 18,
              "title": "Scan",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN waptwua_status->>'status' = 'NEED-SCAN' THEN 1 END) AS hosts_wua_need_scan,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN waptwua_status->>'status' = 'NEED-SCAN' THEN 1 END)::numeric\r\n            / COUNT(CASE WHEN waptwua_status IS NOT NULL THEN 1 END)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_wua_need_scan\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "auto",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [
                        "lastNotNull"
                      ],
                      "fields": "",
                      "values": false
                    },
                    "showPercentChange": false,
                    "textMode": "auto",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_wua_need_scan"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "yellow",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_wua_need_scan"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-19": {
            "kind": "Panel",
            "spec": {
              "id": 19,
              "title": "Error",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN waptwua_status->>'status' = 'ERROR' THEN 1 END) AS hosts_wua_error,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN waptwua_status->>'status' = 'ERROR' THEN 1 END)::numeric\r\n            / COUNT(CASE WHEN waptwua_status IS NOT NULL THEN 1 END)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_wua_error\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "auto",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [
                        "lastNotNull"
                      ],
                      "fields": "",
                      "values": false
                    },
                    "showPercentChange": false,
                    "textMode": "auto",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_wua_error"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "red",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_wua_error"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-2": {
            "kind": "Panel",
            "spec": {
              "id": 2,
              "title": "Total hôtes",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT COUNT(*) AS total_agents_wapt FROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "center",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [
                        "lastNotNull"
                      ],
                      "fields": "",
                      "values": false
                    },
                    "showPercentChange": false,
                    "textMode": "auto",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "fixed",
                        "fixedColor": "blue"
                      }
                    },
                    "overrides": []
                  }
                }
              }
            }
          },
          "panel-20": {
            "kind": "Panel",
            "spec": {
              "id": 20,
              "title": "Reboot",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN waptwua_status->>'status' = 'PENDING_REBOOT' THEN 1 END) AS hosts_wua_pending_reboot,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN waptwua_status->>'status' = 'PENDING_REBOOT' THEN 1 END)::numeric\r\n            / COUNT(CASE WHEN waptwua_status IS NOT NULL THEN 1 END)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_wua_pending_reboot\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "auto",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [
                        "lastNotNull"
                      ],
                      "fields": "",
                      "values": false
                    },
                    "showPercentChange": false,
                    "textMode": "auto",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_wua_pending_reboot"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "blue",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_wua_pending_reboot"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "dark-green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-21": {
            "kind": "Panel",
            "spec": {
              "id": 21,
              "title": "OK",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN waptwua_status->>'status' = 'OK' THEN 1 END) AS hosts_wua_ok,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN waptwua_status->>'status' = 'OK' THEN 1 END)::numeric\r\n            / COUNT(CASE WHEN waptwua_status IS NOT NULL THEN 1 END)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_wua_ok\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "auto",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [
                        "lastNotNull"
                      ],
                      "fields": "",
                      "values": false
                    },
                    "showPercentChange": false,
                    "textMode": "auto",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_wua_ok"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "green",
                              "mode": "fixed"
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_wua_ok"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-22": {
            "kind": "Panel",
            "spec": {
              "id": 22,
              "title": "Top 5 des paquets installés :",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    package,\r\n    COUNT(DISTINCT host_id) AS nb_postes\r\nFROM hostpackagesstatus\r\nWHERE install_status = 'OK'\r\n  AND section = 'base'\r\nGROUP BY package\r\nORDER BY nb_postes DESC\r\nLIMIT 5;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "barchart",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "barRadius": 0,
                    "barWidth": 0.97,
                    "fullHighlight": false,
                    "groupWidth": 0.7,
                    "legend": {
                      "calcs": [],
                      "displayMode": "list",
                      "placement": "right",
                      "showLegend": true
                    },
                    "orientation": "horizontal",
                    "showValue": "never",
                    "stacking": "none",
                    "tooltip": {
                      "hideZeros": false,
                      "mode": "single",
                      "sort": "none"
                    },
                    "xTickLabelRotation": 0,
                    "xTickLabelSpacing": 0
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "fixed",
                        "fixedColor": "blue"
                      },
                      "custom": {
                        "axisBorderShow": false,
                        "axisCenteredZero": false,
                        "axisColorMode": "text",
                        "axisLabel": "",
                        "axisPlacement": "auto",
                        "fillOpacity": 80,
                        "gradientMode": "none",
                        "hideFrom": {
                          "legend": false,
                          "tooltip": false,
                          "viz": false
                        },
                        "lineWidth": 1,
                        "scaleDistribution": {
                          "type": "linear"
                        },
                        "thresholdsStyle": {
                          "mode": "off"
                        }
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "options": "nb_postes"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "blue",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-23": {
            "kind": "Panel",
            "spec": {
              "id": 23,
              "title": "Postes non connecté depuis 10 jours",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    computer_name,\r\n    (last_seen_on::timestamptz)::date AS last_seen_date\r\nFROM hosts\r\nWHERE\r\n    last_seen_on::timestamptz < CURRENT_TIMESTAMP - INTERVAL '10 days'\r\nORDER BY\r\n    last_seen_on::timestamptz;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "table",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "cellHeight": "sm",
                    "showHeader": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "thresholds": {
                        "mode": "absolute",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 80,
                            "color": "red"
                          }
                        ]
                      },
                      "custom": {
                        "align": "auto",
                        "cellOptions": {
                          "type": "auto"
                        },
                        "footer": {
                          "reducers": []
                        },
                        "inspect": false
                      }
                    },
                    "overrides": []
                  }
                }
              }
            }
          },
          "panel-5": {
            "kind": "Panel",
            "spec": {
              "id": 5,
              "title": "OK",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN host_status = 'OK' THEN 1 END) AS hosts_ok,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN host_status = 'OK' THEN 1 END)::numeric\r\n            / COUNT(*)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_ok\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "center",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "showPercentChange": false,
                    "textMode": "value_and_name",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "unit": "none",
                      "thresholds": {
                        "mode": "percentage",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 0,
                            "color": "red"
                          },
                          {
                            "value": 25,
                            "color": "red"
                          },
                          {
                            "value": 50,
                            "color": "#EF843C"
                          },
                          {
                            "value": 75,
                            "color": "yellow"
                          },
                          {
                            "value": 90,
                            "color": "semi-dark-green"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_ok"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "dark-red",
                                  "value": 0
                                },
                                {
                                  "color": "red",
                                  "value": 25
                                },
                                {
                                  "color": "orange",
                                  "value": 50
                                },
                                {
                                  "color": "yellow",
                                  "value": 75
                                },
                                {
                                  "color": "green",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_ok"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "green",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-7": {
            "kind": "Panel",
            "spec": {
              "id": 7,
              "title": "Upgrade",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN host_status = 'TO-UPGRADE' THEN 1 END) AS hosts_upgrade,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN host_status = 'TO-UPGRADE' THEN 1 END)::numeric\r\n            / COUNT(*)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_upgrade\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "center",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "showPercentChange": false,
                    "textMode": "value_and_name",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "unit": "none",
                      "thresholds": {
                        "mode": "percentage",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 0,
                            "color": "dark-green"
                          },
                          {
                            "value": 25,
                            "color": "green"
                          },
                          {
                            "value": 50,
                            "color": "yellow"
                          },
                          {
                            "value": 75,
                            "color": "orange"
                          },
                          {
                            "value": 90,
                            "color": "red"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_upgrade"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "dark-green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_upgrade"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "yellow",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-8": {
            "kind": "Panel",
            "spec": {
              "id": 8,
              "title": "Erreurs",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN host_status = 'ERROR' THEN 1 END) AS hosts_errors,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN host_status = 'ERROR' THEN 1 END)::numeric\r\n            / COUNT(*)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_errors\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "center",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "showPercentChange": false,
                    "textMode": "value_and_name",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "unit": "none",
                      "thresholds": {
                        "mode": "percentage",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 0,
                            "color": "red"
                          },
                          {
                            "value": 25,
                            "color": "red"
                          },
                          {
                            "value": 50,
                            "color": "#EF843C"
                          },
                          {
                            "value": 75,
                            "color": "yellow"
                          },
                          {
                            "value": 90,
                            "color": "semi-dark-green"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_errors"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_errors"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "red",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          },
          "panel-9": {
            "kind": "Panel",
            "spec": {
              "id": 9,
              "title": "Hors ligne",
              "description": "",
              "links": [],
              "data": {
                "kind": "QueryGroup",
                "spec": {
                  "queries": [
                    {
                      "kind": "PanelQuery",
                      "spec": {
                        "query": {
                          "kind": "DataQuery",
                          "group": "grafana-postgresql-datasource",
                          "version": "v0",
                          "datasource": {
                            "name": "afmps43obr2f4c"
                          },
                          "spec": {
                            "dataset": "wapt",
                            "editorMode": "code",
                            "format": "table",
                            "rawQuery": true,
                            "rawSql": "SELECT\r\n    COUNT(CASE WHEN host_status <> 'OK' THEN 1 END) AS hosts_offline,\r\n    ROUND(\r\n        (\r\n            COUNT(CASE WHEN host_status <> 'OK' THEN 1 END)::numeric\r\n            / COUNT(*)::numeric\r\n        ) * 100,\r\n        1\r\n    ) AS percent_offline\r\nFROM hosts;",
                            "sql": {
                              "columns": [
                                {
                                  "parameters": [],
                                  "type": "function"
                                }
                              ],
                              "groupBy": [
                                {
                                  "property": {
                                    "type": "string"
                                  },
                                  "type": "groupBy"
                                }
                              ],
                              "limit": 50
                            }
                          }
                        },
                        "refId": "A",
                        "hidden": false
                      }
                    }
                  ],
                  "transformations": [],
                  "queryOptions": {}
                }
              },
              "vizConfig": {
                "kind": "VizConfig",
                "group": "stat",
                "version": "13.0.2",
                "spec": {
                  "options": {
                    "colorMode": "value",
                    "graphMode": "area",
                    "justifyMode": "center",
                    "orientation": "auto",
                    "percentChangeColorMode": "standard",
                    "reduceOptions": {
                      "calcs": [],
                      "fields": "",
                      "values": true
                    },
                    "showPercentChange": false,
                    "textMode": "value_and_name",
                    "wideLayout": true
                  },
                  "fieldConfig": {
                    "defaults": {
                      "unit": "none",
                      "thresholds": {
                        "mode": "percentage",
                        "steps": [
                          {
                            "value": 0,
                            "color": "green"
                          },
                          {
                            "value": 0,
                            "color": "red"
                          },
                          {
                            "value": 25,
                            "color": "red"
                          },
                          {
                            "value": 50,
                            "color": "#EF843C"
                          },
                          {
                            "value": 75,
                            "color": "yellow"
                          },
                          {
                            "value": 90,
                            "color": "semi-dark-green"
                          }
                        ]
                      },
                      "color": {
                        "mode": "thresholds"
                      }
                    },
                    "overrides": [
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "percent_offline"
                        },
                        "properties": [
                          {
                            "id": "unit",
                            "value": "percent"
                          },
                          {
                            "id": "thresholds",
                            "value": {
                              "mode": "absolute",
                              "steps": [
                                {
                                  "color": "dark-green",
                                  "value": 0
                                },
                                {
                                  "color": "dark-green",
                                  "value": 0
                                },
                                {
                                  "color": "green",
                                  "value": 25
                                },
                                {
                                  "color": "yellow",
                                  "value": 50
                                },
                                {
                                  "color": "orange",
                                  "value": 75
                                },
                                {
                                  "color": "red",
                                  "value": 90
                                }
                              ]
                            }
                          }
                        ]
                      },
                      {
                        "matcher": {
                          "id": "byName",
                          "scope": "series",
                          "options": "hosts_ok"
                        },
                        "properties": [
                          {
                            "id": "color",
                            "value": {
                              "fixedColor": "yellow",
                              "mode": "fixed"
                            }
                          }
                        ]
                      }
                    ]
                  }
                }
              }
            }
          }
        },
        "layout": {
          "kind": "RowsLayout",
          "spec": {
            "rows": [
              {
                "kind": "RowsLayoutRow",
                "spec": {
                  "title": "Statut général des Hôtes",
                  "collapse": false,
                  "hideHeader": false,
                  "fillScreen": false,
                  "layout": {
                    "kind": "GridLayout",
                    "spec": {
                      "items": [
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 0,
                            "y": 0,
                            "width": 5,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-2"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 5,
                            "y": 0,
                            "width": 7,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-10"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 12,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-5"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 15,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-7"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 18,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-8"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 21,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-9"
                            }
                          }
                        }
                      ]
                    }
                  }
                }
              },
              {
                "kind": "RowsLayoutRow",
                "spec": {
                  "title": "Vue d'ensemble des systèmes d'exploitation et de l'espace disque C:",
                  "collapse": false,
                  "layout": {
                    "kind": "GridLayout",
                    "spec": {
                      "items": [
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 0,
                            "y": 0,
                            "width": 12,
                            "height": 8,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-12"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 12,
                            "y": 0,
                            "width": 12,
                            "height": 8,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-11"
                            }
                          }
                        }
                      ]
                    }
                  }
                }
              },
              {
                "kind": "RowsLayoutRow",
                "spec": {
                  "title": "WAPTWUA",
                  "collapse": false,
                  "layout": {
                    "kind": "GridLayout",
                    "spec": {
                      "items": [
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 0,
                            "y": 0,
                            "width": 5,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-13"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 5,
                            "y": 0,
                            "width": 7,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-14"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 12,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-21"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 15,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-18"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 18,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-19"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 21,
                            "y": 0,
                            "width": 3,
                            "height": 6,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-20"
                            }
                          }
                        }
                      ]
                    }
                  }
                }
              },
              {
                "kind": "RowsLayoutRow",
                "spec": {
                  "title": "Autres",
                  "collapse": false,
                  "layout": {
                    "kind": "GridLayout",
                    "spec": {
                      "items": [
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 0,
                            "y": 0,
                            "width": 12,
                            "height": 8,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-22"
                            }
                          }
                        },
                        {
                          "kind": "GridLayoutItem",
                          "spec": {
                            "x": 12,
                            "y": 0,
                            "width": 12,
                            "height": 8,
                            "element": {
                              "kind": "ElementReference",
                              "name": "panel-23"
                            }
                          }
                        }
                      ]
                    }
                  }
                }
              }
            ]
          }
        },
        "links": [],
        "liveNow": false,
        "preload": false,
        "tags": [],
        "timeSettings": {
          "timezone": "browser",
          "from": "now-6h",
          "to": "now",
          "autoRefresh": "",
          "autoRefreshIntervals": [
            "5s",
            "10s",
            "30s",
            "1m",
            "5m",
            "15m",
            "30m",
            "1h",
            "2h",
            "1d"
          ],
          "hideTimepicker": false,
          "fiscalYearStartMonth": 0
        },
        "title": "WAPT Dashboard",
        "variables": [],
        "preferences": {
          "layout": {
            "kind": "GridLayout",
            "spec": {
              "items": []
            }
          }
        }
      }
    }