Microsoft SQL Query - Endpoints flagging with errors

Question

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.

QC · Accepted Answer

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