SQL Query to See the NOT RUN Status for Software Delivery Tasks

Instead of viewing the 'Status' tab on a software delivery task (which is never reliable) use this query to see a list of computers which have the status of 'Not Run' - meaning they have not received the Task or have not delivered any status on the task. Use the Collection Guid in your where clause.

select Guid from vResource where Guid in (select Guid from (select TOP 400 b.name, b.guid    
 from CollectionMembership a, vcomputer b    
 where a.CollectionGuid in ( '{e04bebd1-92dd-40e2-b014-9fed9ddcdd32}','{b6914ce4-55d5-4b4b-a8f6-c029c13794d2}')  -- Laptops    
  and a.ResourceGuid = b.Guid    
  and a.ResourceGuid not in (select _ResourceGuid from Evt_Aex_SWD_Execution where AdvertisementName = 'Pointsec Mandatory Install - 2-21-08')    
 order by b.name) xxx)