Computers without a file - Collection based

Computers without a file - Collection based:

select distinct SYS.Netbios_Name0 'Name', SYS.Operating_System_Name_and0 'Operating System', LSS.LastScanDate, FCM.CollectionIDFrom v_GS_SoftwareFile SFjoin v_R_System SYS on SYS.ResourceID = SF.ResourceIDjoin v_FullCollectionMembership FCM ON SF.ResourceID = FCM.ResourceIDjoin v_GS_LastSoftwareScan LSS on LSS.ResourceID=SF.ResourceIDWhere SYS.ResourceID not in (select distinct SF.ResourceID from v_GS_SoftwareFile SFjoin v_FullCollectionMembership FCM ON SF.ResourceID = FCM.ResourceIDwhere FCM.CollectionID=@CollID and SF.FileName=@variable) and FCM.CollectionID=@CollIDORDER BY SYS.Netbios_Name0