mitre/microsoft-sql-server-2014-instance-stig-baseline

V-67843

rx294 opened this issue · 0 comments

rx294 commented

Current definition leads to erroneous reporting:

  ×  V-67843: SQL Server must have the Data Quality Services software component
    removed if it is unused. (2 failed)
     ×  Master Data Services is in use should equal true

     expected true
          got false

     ×  List if data quality services is used should be empty
     expected `["----", "-------------"].empty?` to return true, got false
     ✔  File C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\DQSInstaller.exe should not exist

Please update the query as shown below

  query = %(
  SELECT name FROM sys.databases WHERE name in ('DQS_MAIN', 'DQS_PROJECTS', 'DQS_STAGING_DATA');

  )