• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2713
  • Last Modified:

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

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?  
1 Solution
If it contains an executable than yes (by default) you can also do unknown extensions as well http://technet.microsoft.com/en-us/library/bb632607.aspx 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.

wingsr4birdsAuthor Commented:
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.
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

Really Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now