Query Logic

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

Leave a Reply

Your email address will not be published. Required fields are marked *