NEW CMPivot search for files

[dmanrez]

Hi

In the the url below, it shows you have to find missing files in a collection with CMPivot. I would like to change it to look for the file 7z.exe but don't know what I should changed?


Device
| join kind=leftouter (File('C:\Program Files\7-Zip\7z.exe'))
| where isnull(FileName)
| project Device

Quickly Find Missing Files with SCCM CMPivot Query

In this post I will show you how to find missing files with SCCM CMPivot query. We will run the CMPivot query that returns computers that are missing a

www.prajwaldesai.com

 

[Garth]

So what exactly isn't working for you?

 

[dmanrez]

The script above would look for files that were not there. I was hoping to do the opposite and find files that are there.
I got it working with only running the one line

Device
| join kind=leftouter (File('C:\Program Files\7-Zip\7z.exe'))