SQL Query not running agains selected source after upgrade

Comments

5 comments

  • Colby Bouma

    SQL Reports need to have the following clause in order to work with Select Collection Source:

    WHERE <ComputerFilter>
    1
    Comment actions Permalink
  • Colby Bouma

    You'll have to modify it like this:

    WHERE Computers.SimpleReasonForReboot LIKE 'Windows Updates asked for a reboot%' AND <ComputerFilter>
    1
    Comment actions Permalink
  • Steve Vujnovich

    I see the issue. I had to add the AND IsOnline

    SELECT
    Name AS 'Computer Name',
    BootTime,
    IPAddress AS 'IP Address',
    IsOnline, CurrentUser AS 'Current User',
    SimpleReasonForReboot AS 'Reboot Reason'
    FROM Computers
    WHERE SimpleReasonForReboot LIKE 'Windows Updates asked for a reboot%' AND IsOnline
    ORDER BY Computers.Name;

    1
    Comment actions Permalink
  • Steve Vujnovich

    Thank you

    1
    Comment actions Permalink
  • Steve Vujnovich

    I do have the WHERE clause in the query.

    WHERE Computers.SimpleReasonForReboot LIKE 'Windows Updates asked for a reboot%'

    0
    Comment actions Permalink

Please sign in to leave a comment.