Hi,

I want SQL query which will search for any specific file in system32 folder in a machine and will display the machine count if the file pr

Not possible to search for "any specific file". In order to do that you'd have to inventory the entire directory which isn't very feasible.

I concur with John. This is not collected by default and it would be very unwise to add it the software inventory to be collected.

My system32 folder contains almost 16,000 files. Multiply that by any number of systems, even a small number like 1,000, and now you have 16 million rows of data.

What's the value of doing something like this and what's your requirement?