All machines shown when clicking onto the view "Duplicate Computers"

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Navigating to Assets > Computers and clicking into the out of the box view called Duplicate Computers displays all machines

Environment

• App Control Server: 8.9.0 - 8.10.4

Cause

The view is not being automatically applied when selected.

Resolution

1. Manually click the "apply" button after navigating to the view each time
OR
2. Apply SQL fix:
   1. Log into SQL Management Studio as an account with permission to the das database
   2. Run query:

      SELECT *
        FROM [das].[dbo].[report_settings]
        where name = 'Duplicate_Computers' and table_name ='apiTable302' and read_only = 1

   3. If the query above displays 1 result, run query:

      Update das.dbo.report_settings set table_settings ='eyJzZXR0aW5ncyI6eyJzb3J0QnkiOiJsYXN0UG9sbERhdGUiLCJzb3J0RGlyZWN0aW9uIjoiREVTQyIsInNob3dDb2x1bW5zIjpbIm5hbWUiLCJjb25uZWN0ZWQiLCJlbmZvcmNlbWVudExldmVsIiwiZGlzY29ubmVjdGVkRW5mb3JjZW1lbnRMZXZlbCIsImlwQWRkcmVzcyIsInBvbGljeU5hbWUiLCJsYXN0UG9sbERhdGUiXSwiZ3JvdXBCeUNvbHVtbiI6Im5hbWUiLCJmaWx0ZXJzIjp7Imhhc0R1cGxpY2F0ZXMiOlt7Im5hbWUiOiJoYXNEdXBsaWNhdGVzIiwibW9kZSI6IiIsInZhbCI6InRydWUiLCJjb25qdW5jdGlvbiI6Im9yIn1dfX19'
      where name = 'Duplicate_Computers' and table_name ='apiTable302' and read_only = 1

Additional Information

This will be addressed in a future release and is being tracked under CRE-18618.