Code: Select all
SELECT DISTINCT hosts.computer_name,hosts.uuid,waptwua_status->'status' as status
FROM hosts
WHERE waptwua_status @> '{"status" : "PENDING_UPDATES"}';The search returned 2 results
- March 9, 2024 - 7:24 PM
- Forum: Reporting - SQL Queries
- Subject: Wua update with a status other than OK
- Answers: 1
- Views : 22201
Re: Wua update with a status other than OK
I just found it for pending updates
Good day.
- March 8, 2024 - 2:58 PM
- Forum: Reporting - SQL Queries
- Subject: Wua update with a status other than OK
- Answers: 1
- Views : 22201
Update Wua with a status other than OK
Hello,
I'd like to create a report for machines with a status other than "OK" for WUA.
I tried this, but my WHERE clause is causing a problem.
If I remove the WHERE clause, it displays everything:
SELECT DISTINCT hosts.computer_name, hosts.uuid, waptwua_status->'status' as status
FROM hosts
WHERE waptwua ...
I'd like to create a report for machines with a status other than "OK" for WUA.
I tried this, but my WHERE clause is causing a problem.
If I remove the WHERE clause, it displays everything:
SELECT DISTINCT hosts.computer_name, hosts.uuid, waptwua_status->'status' as status
FROM hosts
WHERE waptwua ...
