Hope this helps - trying to keep it as simple as possible.
In the table below there is an asset name (unique identifier), and based on the Class of technology, there is certain criteria that the asset must be to be compliant. So here a
- Workstation has to have a RAM >= 1gb which it is, however the Back up Disk is too small should be > 200GB.
- The POS has to have >= 1.5gb RAM - you can see one asset is and one asset isn't.
- Servers one hasn't doesn't have enough memory because it belongs to one of our subsidiaries, where as the other is in a different business... so it meets the min RAM criteria, but doesn't mean the number of CPUs allocated to the asset.
Not sure if you solved this challenge, but I saw something a few weeks ago that may be able to help you. I was at a conference in South Africa and a Qlik partner there called KPI Management Solutions was showcasing a Qlik based they have Solution called CABAM.
CABAM is designed to record all your compliance requirements and then run through a series of checks based on the compliance rules that you need to meet. It is a brilliant use of Qlik and a very clever solution. It scalable to any number of compliance requirements and doesn't rely on a long list of IF statements.
It might be worth emailing Roger Knocker the MD of KPI Management Solutions to see if they can help you in any way. ...