I am running the following queries in Grafana, to get state, ram, disk information from Windows & Linux servers.
get state (up or down)
up{instance=~"WINDOWS1|WINDOWS2|WINDOWS3|WINDOWS4|LINUX1|LINUX2"}
get memory usage percentage for windows
100 - (windows_memory_available_bytes{instance=~"WINDOWS1|WINDOWS2|WINDOWS3|WINDOWS4"} / windows_memory_physical_total_bytes{instance=~"WINDOWS1|WINDOWS2|WINDOWS3|WINDOWS4"} * 100)
get disk usage percentage for windows
(1 - (windows_logical_disk_free_bytes{volume="C:", instance=~"WINDOWS1|WINDOWS2|WINDOWS3|WINDOWS4"} / windows_logical_disk_size_bytes{volume="C:", instance=~"WINDOWS1|WINDOWS2|WINDOWS3|WINDOWS4"})) * 100
get memory percentage for linux
100 - (node_memory_MemAvailable_bytes{instance=~"LINUX1|LINUX2"} / node_memory_MemTotal_bytes{instance=~"LINUX1|LINUX2"} * 100)
get disk usage for linux
100 * (1 - (node_filesystem_avail_bytes{instance=~"LINUX1|LINUX2", mountpoint="/"} / node_filesystem_size_bytes{instance=~"LINUX1|LINUX2", mountpoint="/"}))
I also added 2 transformations
It seems that because Linux queries are defined separately, they are also shown separately on the table.
How can I put the linux values under the correct tables.