Hi, I have been breaking my head to find the solution. I have a list of assets. Need to count the assets if it only has the FIXED status and not having any other rows with different status, also with Patch Type OS. I need to display the count for each domain.
For example if you look at the below table. For Domain ABC we should M2 since it belongs to patch type OS and with status as Fixed. But M1 belongs to OS but it has both Active and Fixed status.