|
|
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 
Anonymous comments are disabled
|
|
|