Giving Weight to "Needs Reboot" Information

Comments

1 comment

  • Fredryck Hale

    Shannon Hensley I was actually having the same issue and was trying to figure out a way to filter or sort out the machines that wanted to reboot for a pending file rename. I asked the question on their Q&A webinar this morning and Lex had the great suggestion of creating a SQL report that can drill down and find the machines that need a reboot based on Windows Update being in the detailed reboot summary. Right now I've just set up an auto report to send me an email every Monday morning with a list of what machines need to be rebooted for updates. Now mind you I am still pretty green when it comes to SQL, but this worked for me. 

    select
    Computers.Name as "Computer Name",
    [Computers].[DetailedReasonForReboot]
    from Computers
    where Computers.DetailedReasonForReboot LIKE 'Windows Update%'

     

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.