[RESOLVED] Request for "Waiting for restart"

[jlatieule]

Good morning,


I'm trying out the reporting tool and I want to identify machines waiting to restart after installing a system update with wapt-wua (see screenshot)
Currently I have to manually walk through the park to identify the machines that need restarting.

2024-09-17_11h56_02.png (42.38 KB) Viewed 26976 times

[sfonteneau]

Hello,

in the hardware inventory, drag and drop "wuauserv_status -> reboot_needed" into the middle columns to get all the reboot_needed values ​​at once.

[jlatieule]

Thanks, it works perfectly. I would have preferred to add an icon instead of the text, but it's great

[mviale]

Hello,

is it not possible to retrieve this value via an SQL query?

I have this for all WUA statuses to retrieve the total per status, but it doesn't include "Pending Restart". `

SELECT waptwua_status->'status' as status, COUNT(DISTINCT hosts.computer_name) as total_computers
FROM hosts
GROUP BY waptwua_status->'status'`

[sfonteneau]

Code: Select all

SELECT host_info->'reboot_needed' as reboot_needed,computer_name FROM hosts

Like this