Ivan Camero

CIS compliance SQL query by policy and site

Discussion created by Ivan Camero on May 2, 2017
Latest reply on May 19, 2017 by Ivan Camero

I'm trying to build a "simple query" that will give me the following data given a specific policy and site:

  • IP
  • Hostname
  • OS
  • # of failed policy checks
  • # of passed policy checks
  • # of non applicable policy checks
  • Total policy checks
  • Compliance %

 

Please advice, I've tried different queries based on other discussions with no luck.

Outcomes