I run the following query every month to produce my top ten, however I would like to be able to exclude certain individuals, specifically if a service desk analyst is logging calls. Can someone amend my query so that I could add individual users and stop them appearing in the report for example Smith, John and Brown, David. Thanks.

 

 

 

SELECT top 10 aau.FIRST_NAME "Requester",max(dpt.DEPTNAME) "Department", count(aau.FIRST_NAME)"Count" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID WHERE dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00') >= convert(varchar,'2010-08-01  00:00',21) and dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00') <= convert(varchar,'2010-08-31  23:59',21)  AND wot.THD_WOID=wot.WORKORDERID and aau.FIRST_NAME <> 'helpdesk'  group by aau.FIRST_NAME ORDER BY 3 desc