SELECT
SYS.Netbios_Name0,
SF.FileName,
SF.FileSize/1024/1024 AS ‘Size, KB’,
SF.FilePath
FROM
dbo.v_GS_SoftwareFile AS SF
INNER JOIN dbo.v_R_System AS SYS ON SYS.ResourceID = SF.ResourceID
where
(SF.FileName LIKE ‘%.pdf’ AND SF.FilePath LIKE ‘%My Documents%’)
OR (SF.FileName LIKE ‘%.pdf’ AND SF.FilePath LIKE ‘%Desktop%’)
OR (SF.FileName LIKE ‘%.pdf’ AND SF.FilePath LIKE ‘%C:\%’)
and SF.FileSize>1024
ORDER BY SYS.Netbios_Name0