This worked well, thanks for that Oliver. Actually my requirement is a lot more complex. I will try to explain it here,
This is the query am using now,
| pivot Application_ApplicationInventory
latest(InstallDate) as InstallDate
latest(DisplayVersion) as DisplayVersion
filter host in (101,102,103,104)
filter DisplayName in ("Adobe","Chrome","vlc")
| where isnotnull(DisplayName)
| eval PreReq=case((DisplayName="Adobe" AND DisplayVersion < "7.5") OR (DisplayName="Chrome" AND DisplayVersion < "2.0") OR (DisplayName="vlc" AND DisplayVersion < "6.0"),"1",true(),"0")
This is giving me the result as intended for the PCs where its installed. I have some more requirements and need to include those conditions as well,
1. Need to mark the PCs as non compliant where any of these applications is not installed at all. It would be nice if we know what application is not installed but not mandatory at this point.(This data is not available directly. I have an option to append the PCs separately but search goes longer.)
2. Compliance for another app AdobeAcrobat (this will not be present in all PCs but we need to consider only the PCs where its installed and check for the version to mark it as compliant or noncompliant)
3. Compliance for two apps IE and Mozilla (either IE or Mozilla will be present in the PCs, so if any of them is present - check for the respective version and mark as compliant or noncompliant. Also, here when both these apps are not installed we have to mark it as noncompliant)
Like I have said before we have to check for all these and mark a PC as compliant or noncompliant.
I have tried to explain as clearly as I could. Any suggestion is greatly appreciated.
... View more