How to see the total amount of countermeasures and their status

You can check the total amount of countermeasures and their status by navigating to Dashboard and scrolling to Countermeasure status in the UI

 If you prefer to check them on your on premises database, you can use the following query:

SELECT COALESCE(control0_.state, 'TOTAL') AS countermeasure_status, COUNT(*) AS countermeasure_amount FROM control control0_ INNER JOIN component component1_ ON component1_.id = control0_.component_id INNER JOIN project project2_ ON project2_.id = component1_.project_id WHERE project2_.type = 'STANDARD' AND EXISTS (SELECT 1 FROM project_by_user projectbyu3_ WHERE projectbyu3_.id = project2_.id AND projectbyu3_.username IN (SELECT username FROM users WHERE username != 'system' )) AND NOT EXISTS (SELECT 1 FROM project_version projectver4_ WHERE project2_.id = projectver4_.project_id ) AND control0_.state IN ('RECOMMENDED', 'IMPLEMENTED', 'REQUIRED') GROUP BY ROLLUP (control0_.state);

You can also check them via IriusRisk API, the following article explains how Filtering an API call