Tranquil IT Forum

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.

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.

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

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'`

Like this