Query for file in a particular location

[robishaw]

does anyone know how to write a query statement that will search for an (inventoried) file in a certain location? I wrote a query to search for 'user32.dll'. The query results lists more than one reference per system. I don't know which reference is the one I am looking for (i.e. c:\winnt\system32). Can anyone advise me how to set up a query to look SPECIFICALLY IN c:\winnt\system for the file info. I would appreciate any advice. Thanks.

 

[grahaml]

The information you require is not available in the SMS database. All that shows in resource explorer is all there is. Unless you can identify the file you require from these fields, you're ...er ....stuck. :-I

 

[grahaml]

However, if you collect the file, then the field "File Path" is available to query and this does holf the full pathname.