Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008

    Unanswered: creating a query showing file not existing

    This is a SQL question while using Microsoft SMS.

    I am trying to write a SQL query looking for a specific file in a specific directory. If the File does not exist, then I want it to display.

    here is the Code that I have for it that shows that the file exists... how do I make it show that the file doesn't exist?... what am I doing wrong?

    Thanks for all your help in advance!


    SELECT TOP 100 PERCENT SYS.Netbios_Name0, SYS.User_Name0, SF.FileName, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath,
    FROM dbo.v_GS_SoftwareFile SF INNER JOIN
    dbo.v_R_System SYS ON SYS.ResourceID = SF.ResourceID
    WHERE (SF.FileName = 'UdaterUI.exe')
    AND (SF.FilePath = 'C:\Program Files\McAfee\Common Framework\')
    (SF.FileName = 'UdaterUI.exe')
    AND (SF.FilePath = 'c:\Program Files\Network Associates\Common Framework\')
    ORDER BY SF.FileVersion, SYS.Netbios_Name0

  2. #2
    Join Date
    May 2002
    General Deheza, Cba, Arg.
    hi, I nerver use SMS, but, do U explain to me, what is dbo.v_GS_SoftwareFile and v_R_System SYS (what contains each table).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts