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. ...
The way Simn describes CABAM is very good. (Thanks Simon)
CABAM is an acronym for:
C = Continuous and automated
A= Anomalies (Errors, Non-compliance
Exception Reporting, Transaction
Outliers, Reconciliation items)
BA = Business Assurance
M = Monitoring
It runs continuously and picks up any anomalies or exception that should not be there. I checks master data as well as transaction data. It can also be used to test integrity between systems
Here is a link to the brochure which describes CABAM
(Make sure you download the PDF as there are 2 pages)
I'd be happy to set-up a webinar next week for you and anyone else who wants to join so that you can see how it works and the depth it has to manage all sorts of compliance issues.
Let me know