Can someone help with a excel query for RSA endpoint analysis which will include columns such as Description,alertable,IOCLevel,machine Count &Machine Name?
For example I have ran the query below but just need to include more columns to it such as Description,Alertable,IOCLevel,MachineCount & MachineName
IQ.Description AS IIOC,
MAX(IE.AuditUTCDate) AS LastTriggered
dbo.IOCEvaluation AS IE WITH(NOLOCK)
INNER JOIN dbo.IOCQuery AS IQ WITH(NOLOCK) ON IQ.PK_IOCQuery = IE.FK_IOCQuery
INNER JOIN dbo.Machines AS MA WITH(NOLOCK) ON MA.PK_Machines = IE.FK_Machines
IQ.Active=1 AND IOClevel <= 1