Can Sccm tell me how many computers have a specific folder in program files?

Posted on 2009-12-28
Last Modified: 2013-11-21
I am trying to find, or build a report or query that can tell me if a specific folder is found any of the computers in my managed network?  
Question by:wingsr4birds
    LVL 29

    Expert Comment

    If it contains an executable than yes (by default) you can also do unknown extensions as well but note that your database may grow substantially if it's a very common extension, i.e. .doc for example and may take longer for the inventory to run.

    Depending on what you're trying to achieve I'd just use a script to pull the information either via SCCM or a Logon Script.


    Author Comment

    The issue is we have Symantec Endpoint Installed, for some reason a certain percentage of the installations utilize a different file structure (even though they are the same versioni of the client) I believe these clients where upgraded from an older version of Endpoint. These clients all have some issues and i would like to run a report to find out how many of these "upgraded" clients are out there. In short the executiable is located in a different folder on these  clients.
    LVL 2

    Accepted Solution

    If the executable that is located in the "different" folder is known, then this might get you going in the right direction...

    1.  Create a report.
    2.  Name it what you'd like (e.g. Computers with a Specific File and Path)
    3.  Set Category to Software - Files
    4.  Use the SQL Statement labeled [Report SQL Statement--see code]
    5.  Click the Prompts button and create 2 prompts.
    5a.  Name = fileName, Prompt Text = File Name, SQL = [fileName SQL--see code]
    5b.  Name = filePath, Prompt Text = File Path, SQL = [filePath SQL--see code]

    This should atleast get you going in the right direction.  You might have to tweak it a little bit to suite your environment/situation but assuming you have Software Metering on and running, this should get you going.

    [Report SQL Statement]
    SELECT SYS.Netbios_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath
    FROM v_GS_SoftwareFile SF
    JOIN v_R_System SYS on SYS.ResourceID = SF.ResourceID
    WHERE SF.FileName LIKE @fileName AND SF.FilePath LIKE @filePath
    ORDER BY SYS.Netbios_Name0
    [fileName SQL]
     if (@__filterwildcard = '')
      select distinct FileName from v_SoftwareFile order by FileName
      select distinct FileName from v_SoftwareFile
      WHERE FileName like @__filterwildcard
      order by FileName
    [filePath SQL]
     if (@__filterwildcard = '')
      select distinct FilePath from v_GS_SoftwareFile order by FilePath
      select distinct FilePath from v_GS_SoftwareFile
      WHERE FilePath like @__filterwildcard
      order by FilePath

    Open in new window


    Expert Comment

    Really Thanks

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack.  My needle was an anti-virus version causing problems with my Exchange server. I have an HP DL350 with Windows Server 2008 Stand…
    1. Boot PC and press F10, select storage options and change the compatibility from “AHCI” to “IDE”, save and exit 2. Boot PC and press F12 3. Upon PXE display of searching for DHCP server, press Pause break to obtain MAC address 3. Open Configu…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now