1 Reply Latest reply on May 26, 2016 3:54 PM by Bill Robinson

    Compliance - compare Products from csv file to installed Products

    James Donohue

      Hello,

       

      Scenario: We have a System of Record that contains all Products / Versions that should be installed on certain Server types throughout the Organization. A scheduled job gets executed that reads the SOR and creates a csv file on the local Server listing all Products / Versions that this Server should have.

       

      I'm attempting to create a Compliance Rule that does the following:

      • Reads a CSV on each target, as shown(count, Product, Version):

      3,vasclnt,4.0.3-238

       

      4,vasgp,4.0.3-238

      • Search the first Product in the csv and determine if the value contains a Product in RPM:*.Name
      • AND Search the first Version in the csv and determine if the value contains a Version in RPM:*"."Version (Linux)

       

      If they are both satisfied than that part of the rule is compliant.

       

       

      I tried If, Exists and Count and have some success but it never seems to validate the Version. Any suggestions, examples are appreciated.

       

      Here's the Rule in its simplest form:

      "Configuration File Entry:/home/zkplun3/tmp/data.csv//**"."Value1 as String (All OS)" contains "RPM:*".Name  AND

      "Configuration File Entry:/home/zkplun3/tmp/data.csv//**"."Value2 as String (All OS)" = "RPM:*"."Version (Linux)"