9. Using the reporting functions in WAPT 
¶
9.1. Working principle¶
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. Once the package is installed, you will find different formats of the diagram in C:/Program Files (x64)/waptdbdiagram (Windows) or /opt/wapt/dbdiagram (Linux, MacOS).
9.2. 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 or on .
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 Save selected queries. The new queries will appear in the WAPT Console.
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 .query or a .json formated 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 Save Queries to save the imported queries.
To create a new SQL report, click on .
Designing a SQL query report in the WAPT Console¶
Hint
To rename a query, select the query and press the F2 key.
In the top banner, you can write your SQL query.
To edit / modify / save your reports:
The Refresh button is used to reload queries saved on the WAPT Server, for example, if a colleague has just edited a new query.
The New query button adds a new blank query to the list.
The Delete query button deletes the selected query from the WAPT Server.
The Save queries button saves the query on the WAPT Server.
The Execute button executes the selected query.
The Export to spreadsheet button exports the result of your query to a spreadsheet. The button is enabled only in edit mode.
The 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.
Options available for a SQL query report in the WAPT Console¶
Name |
Description |
|---|---|
Execute |
Executes the SQL query. |
Edit |
Edits the SQL query. |
Edit Name |
Edits the name of the SQL query. |
Export to spreadsheet |
Exports the result of the SQL query to a csv formatted file. |
Duplicate |
Duplicates the SQL query. |
Export queries to file… |
Exports the selected SQL queries to a file. This method allows to share or backup the SQL queries. |
Import queries… |
Imports queries from a file. |
Delete queries |
Deletes the selected queries. |
Note
SQL queries are saved in the PostgreSQL WAPT database.
Using CTRL+space allows to build queries more effectively as it will auto-complete some fields.
9.3. Using queries as a filter in the inventory tab¶
You can create a filter for use in the 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 Choose as Host UUID button. On the query result, right-click on host_id, which is a unique identifier, select this entry and click on the Choose as Host UUID button.
Querying on host UUID to create a dynamic view in the inventory tab¶
When done, save the query by pressing the Save query button then go to the Main Inventory tab.
Then, enable the Advanced Search panel and select the query in the drop-down field Filter hosts on 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”.
9.4. Query examples¶
9.4.1. Computers query¶
select count(*) as "number_of_hosts" from hosts
select
computer_name,
os_name,
os_version,
os_architecture,
serialnr
from hosts
order by 4,3,1
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
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
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
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'
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
select
computer_name,
os_name,
os_version,
host_info->'windows_product_infos'->'product_key' as windows_product_key
from hosts
order by 3,1
9.4.2. WAPT query¶
select
package,
version,
architecture,
description,
section,
package_uuid,
count(*)
from packages
group by 1,2,3,4,5,6
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
9.4.3. Packages query¶
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
9.4.4. Software query¶
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 %%')
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
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
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.
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.
9.5. 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 Softwares Inventory tab.
Normalizing the name of software titles in the WAPT Console¶
Click Normalize Software Names in the Tools menu.
Select the software titles whose names to standardize, for example, all different versions of Adobe Flash Player.
On the column normalized, press F2 to assign a standardized name to the selected software titles. Finally press Enter to save the changes.
Note
To select several software titles, select them with the shift-up/down key combination.
You can also indicate a software like windows update or banned (press spacebar in the corresponding column).
Press on the Save Modifications button to upload the changes onto the WAPT Server.
You can now run queries using this standardized name.
Hint
The Show host checkbox allows to see the software titles that are installed on the hosts.
Showing hosts with selected software in the Software Inventory tab¶
9.5.1. Using normalized software titles as a filter in the inventory tab¶
You can create a filter in the Main Inventory tab that uses the normalized software title names. To do so, normalize the software title names in Software Inventory then select one or several hosts. In the 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.
Defining a normalized software title name¶
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.
9.6. 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.
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
pg_hba.confof the PostgreSQL version in use. In/etc/postgresql/15/main/pg_hba.conffor Debian and/var/lib/pgsql/15/data/pg_hba.conffor RedHat and derivatives, add the IP address of the PostgreSQL client under # IPv4 local connections section.
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
/etc/postgresql/15/main/postgresql.conffor Debian and/var/lib/pgsql/15/data/postgresql.conffor RedHat and derivatives, section Connection Settings.
listen_addresses = '*'
Restart the service for your PostgreSQL version.
systemctl restart postgresql@12-main.service
Connect to PostgreSQL on the WAPT Server.
sudo -u postgres psql wapt
Then give a password to the wapt user.
wapt=# ALTER USER wapt WITH PASSWORD 'PASSWORD';
Example Grafana Dashboard for WAPT
{
"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": []
}
}
}
}
}