Hi sureshmurgan,
thank you, I'm glad I could help. Your added complexity can easily be solved with the lookup based logic that I suggested:
For the different requirements per PC, define a lookup that defines different classes of PCs: appmap.csv
ClassName,AppName,AppStatus
OfficeStd,Word,Required
OfficeStd,Excel,Optional
OfficeFin,Word,Required
OfficeFin,Excel,Required
Create yet another lookup for the mapping between PC classes and PCs: classmap.csv
PC,ClassName
X, OfficeStd
Y,OfficeFin
A search to check if a PC has all required applications installed would be someting like this:
... search to get an event for every InstalledAppName installed on PC ... | transaction PC | lookup classmap.csv PC output ClassName | eval AppStatus="Required" | lookup appmap.csv ClassName,AppStatus output AppName | eval AppsMissing=if(InstalledAppName!=AppName,"Apps Missing","Apps Compliant") ...
... View more