Hi Carly,
Great! I'm glad this helped you out!
Yes, NOT ProductName="*" should capture the null values. If the blank ProductName field is non-compliant, then I think the precise logic of the eval Compliant probably needs a little tweaking. I'm guessing something like this might be more appropriate for Windows OSs:
| eval Compliant=if((match(LifeCycleStatus,"(Mainstream|Emerging)") AND match(OSType,"^Windows")) AND (NOT isnull(ProductName)),"True","False")
Have a good one!
rmmiller
... View more