Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 1145 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.
Parents
  • 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

Reply
  • 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

Children
Unfiltered HTML