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

Microsoft SQL Query - Endpoints flagging with errors

Hello. 

Can anyone help me in writing an query that will bring back all machines that are flagging with Sophos errors. 

Any help will be appreciated. 

Thanks, 

Will Janes. 



This thread was automatically locked due to age.
Parents
  • Hello Will Janes,

    flagging with Sophos errors
    in principle all errors are Sophos errors, aren't they? Could you give a more detailed description what you want to do?
    If you have the Management Studio take a look at the ComputerListWithErrorsAndAlerts table valued function.

    Christian

  • Hello Christian, 

    On the Sophos console you are able to filter, 'Managed Computers with outstanding Sophos product errors'

    I would like to run some SQL to display this through a script or such alike. 

    Thanks, 

    Will Janes.  

  • Hello Will Janes,

    basically

    SELECT DISTINCT ac.Name, ac.ID
     FROM dbo.AliveComputers ac WITH (NOLOCK)
        WHERE ac.Managed=1 AND
         (   ac.LastAUErrorAlert  IS NOT NULL
          OR ac.LastSAVErrorAlert IS NOT NULL
          OR ac.LastSCFErrorAlert IS NOT NULL
          OR ac.LastPmaErrorAlert IS NOT NULL
          OR ac.LastSEAErrorAlert IS NOT NULL
          )

    should return the same computers as the console.

    Christian

Reply
  • Hello Will Janes,

    basically

    SELECT DISTINCT ac.Name, ac.ID
     FROM dbo.AliveComputers ac WITH (NOLOCK)
        WHERE ac.Managed=1 AND
         (   ac.LastAUErrorAlert  IS NOT NULL
          OR ac.LastSAVErrorAlert IS NOT NULL
          OR ac.LastSCFErrorAlert IS NOT NULL
          OR ac.LastPmaErrorAlert IS NOT NULL
          OR ac.LastSEAErrorAlert IS NOT NULL
          )

    should return the same computers as the console.

    Christian

Children