Computers with a specific File - Collection based

Computers with a specific File - Collection based:

select SYS.Netbios_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath, FCM.CollectionIDFrom v_GS_SoftwareFile SFjoin v_R_System SYS on SYS.ResourceID = SF.ResourceIDjoin v_FullCollectionMembership FCM ON SF.ResourceID = FCM.ResourceIDWhere SF.FileName LIKE @variable and SF.FileVersion=@Version and FCM.CollectionID=@CollIDORDER BY SYS.Netbios_Name0