Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 1112 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Where in SQL is restart required warning?

Daniel Gebler

Dear All,

 

I am trying to get a list of machines per error message type in a report, but cannot find where these are stored in the SQL db.

 

Can you shed some light on this please?

 

Many thanks,

DanZi



This thread was automatically locked due to age.
  • 0

    Hello DanZi,

    the following gives you a List of Computers with an outstanding Restart required:
    SELECT C.Name FROM [SOPHOS551].[dbo].[Errors] AS E
            INNER JOIN [SOPHOS551].[dbo].[AliveComputers] AS C ON E.ComputerID = C.ID
                 WHERE E.Source = 'ALC' AND E.Number = 109 AND E.Outstanding = 1

    This is just a reply considering your post's subject. Processing the Errors table isn't exactly simple.

    Christian

  • 0 in reply to QC

    Thank you Christian, this is perfect! :) The 109 was my suspicion too. This works nicely! :)

Unfiltered HTML