I had a simple SQL Query that ran properly until upgrading from 220.127.116.11 to 18.104.22.168.
When manually selecting the collection source offline systems are still showing up in the results when the collection that is selected should only be showing online systems only,
When I even select a collection that has only 2 systems listed the results still show a list of 30 results.
Computers.Name as "Computer Name",
Computers.IPAddress AS 'IP Address',
Computers.CurrentUser AS 'Current User',
Computers.SimpleReasonForReboot AS 'Reason For Reboot',
date(Computers.BootTime) AS 'Boot Time'
FROM Computers WHERE SimpleReasonForReboot LIKE 'Windows Updates asked for a reboot%'
ORDER BY Computers.BootTime;
Please sign in to leave a comment.