Carbon Black Cloud: How to find Duplicate Names
search cancel

Carbon Black Cloud: How to find Duplicate Names

book

Article ID: 285009

calendar_today

Updated On:

Products

Carbon Black Cloud Endpoint Standard (formerly Cb Defense)

Issue/Introduction

How to find Duplicate Names.

Environment

  • Carbon Black Cloud Console: All Versions

Resolution

  1. Go to Endpoints Page or VM Workloads Page.
  2. Export the Device information by clicking the Export button.
  3. Open the exported device information csv format file in excel.
  4. Add 2 columns Duplicate and Duplicate Count to the end of the table.
  5. For Duplicate column use formula =COUNTIF(AG:AG,AG2)>1 and for Duplicate Count use formula =COUNTIF(AG:AG,AG2)
  6. Use the Filter functionality to filter rows having Duplicate column value as True. These are the devices with Duplicate Names.
  7. Copy the list of Duplicate Device names to new sheet. Go To Data->Remove Duplicates. This is the list of Device Names having duplicate value.

Additional Information

AG in the formula equals the "name" column, if the results are not as expected please verify column is still correct.