How to alert on a virus found

SAM's SQL User Experience Monitor can be used to query the number of records in a table, then combined with the "Count Statistic as Difference" option to achieve what you describe above.

SELECT COUNT(*) FROM table_name;

Hi Thanks for the answer, but maybe I am not expressing myself as to what I am trying to do as this is my first attempt at an alert like this.

Also how do I use the SQL user experience monitor<

I have a SQL query that I want to have the output sent in a email when the condition is meet. The query is as follows

SELECT

  vTI.ThreatTypeName,

  vTI.ThreatSubTypeName,

  vTI.ThreatName,

  vTE.EventTime,

  vTI.FirstDetectedAt,

  vTI.FullFilePath,

  vC.Name AS ComputerName

FROM [SOPHOS521].[Sophos Reporting Interface].[vThreatEventData] AS vTE

JOIN [SOPHOS521].[Sophos Reporting Interface].[vThreatInstances] AS vTI

ON vTE.ThreatID = vTI.ThreatID

JOIN [SOPHOS521].[dbo].[ComputerHosts] AS vC

ON vTI.ComputerID = vC.ID

WHERE convert(datetime,vTE.EventTime) > DATEADD(MINUTES,-5,GETDATE())

ORDER BY vTE.EventTime

Thanks,

-Pat