I'm trying to make a query based on if folder exists on computers... Basically all I want is to do is SCCM console to find me computers which have C:\oracle\product\[version]. We have 2 different versions of oracle which are used, 10 and 11. They are placed differently depending which version is installed, e.g. C:\Oracle\product\11.2.0 OR C:\Oracle\product\10.2.0. I wouldn't mind even if I had to do 2 different queries for both versions, as long as I'm still getting those results.
I tried making query with (simple value) software files - file path & (operator) is equal to and value for C:\Oracle\product\11.2.0. Here's query language:
select * from SMS_R_System inner join SMS_G_System_CollectedFile on SMS_G_System_CollectedFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_INSTALLED_EXECUTABLE on SMS_G_System_INSTALLED_EXECUTABLE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath = "C:\\Oracle\\product\\11.2.0"
Nada. Tried playing around with different attribute classes and attributes, still nada. Query runs, but doens't get any results. Am I using totally wrong attribute class or method or what? I can make other queries which run and gets results back so requirements for queries should be OK in server and clients end. In theory it shouldn't be that hard to make a query in sccm to find out if computer have a specific folder... or is it?
Oh and ps. software inventory is enabled, inventory reporting detail is full details, file types - and collect files -. Should this also be configured in some way?
I would love if someone could point me to right direction!